Forum Discussion
Conditional Formatting isn't showing until the cell is interacted with
Looks like on updating the sheet Flow returns text instead of date, if user re-enter it is converted to date (actually number) and rule works.
Microsoft changed about a week ago how date from Excel sheet is recognized by Flow (text in ISO format instead of date). Perhaps that's related change. However, few days ago reverted change back and new version shall be introduced soon. That's somewhere on support page.
That's only the guess, I don't know for sure.
Looks like on updating the sheet Flow returns text instead of date, if user re-enter it is converted to date (actually number) and rule works.
Microsoft changed about a week ago how date from Excel sheet is recognized by Flow (text in ISO format instead of date). Perhaps that's related change. However, few days ago reverted change back and new version shall be introduced soon. That's somewhere on support page.
That's only the guess, I don't know for sure.
SergeiBaklan Ah that would certainly make sense considering the old version worked. Thank you, I will hold tight for the update and fingers crossed that fixes my problem!
