I think I've read just about every forum posting on here regarding the Add Days command for Conditions, and I'm still lost. I think I'm super close to having this nailed down but need a someone to look over what I'm doing wrong.
Here's an example of what my Excel table looks like:
As you can see, I've set up conditional formatting to highlight any Expiration Dates that are within 45 days in yellow, and any that are past the expiration date in red.
Now, I'm trying to set up a flow that will send an email when the expiration date is 45 days out. This is what I have:
Here are the Condition parameters:
The error I get is this when testing.
"Action 'Condition_2' failed: Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '45688' was not valid. The datetime string must match ISO 8601 format.'.
You can see I have my dates in ISO 8601 formatting in the spreadsheet. I'm so lost on how to fix this and I'm running out of time before my next meeting to have it working appropriately. Help!