0
I have a flow that connects an MS Forms form to an Excel sheet. The Excel sheet has a column with conditional formatting that highlights duplicate cells. When I manually add a name to the column in the table with the formatting, it highlights correctly, but if I submit the form and trigger the flow, the response added to the table by flow will not trigger the conditional formatting, and after that even if I add a duplicate response manually it will not trigger the conditional formatting.
I am trying to figure out why rows added to my Excel table by Flow do not trigger the column's conditional formatting which should highlight duplicate values red.
The flow is as follows
BakuninUnbound
Posted 2019-06-12T12:48:25.583
Reputation: 1
I have added a specific question and a picture of the conditional formatting rule. Does the make the question more clear? Thank you. – BakuninUnbound – 2019-06-12T13:19:32.270
I don't know the answer, hence this comment, but I believe the problem is because conditional formatting, like any other "format", needs to be applied to the new rows before it has its desired effect. Flow may not be capable of extending a conditional format to new rows, so you may need to solve this by doing that manually or with a macro. – I say Reinstate Monica – 2019-06-12T21:56:17.480