Hello!
I think this is a formula or excel sheet problem, rather than a Power Automate problem, but here goes:
Some colleagues and I are trying to set up a flow which triggers an email to be sent 6 months post a certain date. We've managed to set up a flow which works on a very simple spreadsheet, however when we try to use it on the spreadsheet which needs to be our source data, it provides an error around processing DateTime to match the ISO 8601 format.
The flow relies on a column in excel which calculates 182 days from a previous column, using the formula =IF((ISBLANK(T3)),"",T3+182)
Using this formula in a sheet which purely has four columns (Name, Email, Date, 6 months post match date) and setting the flow to run from this sheet means the flow runs fine and sends the email we want it to.
When I try to set this flow against a sheet which is much more complicated and has various inputs from MS Forms, the flow returns the error above with the inability to process the formatDateTime, even though it's been asked to look at a column which is performing the same function (calculate a date using another column which is a manually inputted date). In that column, it will run the flow for manually inputted dates, but not for the dates calculated by the formula.
I'm about to spend some time deleting columns within a test spreadsheet to see if something in another column is affecting it. I've checked the regional settings of the source data sheet to check that's the right format, Any other ideas as to what may specifically be in this source spreadsheet that's causing the data to act differently?
General flow setup:
