I am fairly new to flow. I am really hoping someone can help me here.
I have an excel file with future dates of accounts that need to be worked on before they expire (this would be the Exp. Date column). I am looking to setup a flow that will look at these dates and notify me when an account hits the 150 day mark from today so that it can remind me to begin working on that account.
I can seem to get the flow to work at all. Any help would be appreciated!
Thank you @leyburn19 ! Anything you would suggest I do with the left side of the Condition where I have the Exp. Date value from the excel file? Looks like its not reading that as a date. The flow runs fine but the output seems to be false for every row which it shouldn't. There's at least one that it should pull 150 days from today.
Yes there are issues with Flow reading dates from Excel.
In your apply to each - before the condition add a compose that extracts your date and formats it forts. Then use teh compose in teh condition
In the List rows present in a table action, click on the show advanced options and then select the date format as shown in the image below.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!