You’re offline. This is a read only version of the page.
39
Hi,
I have an issue with using excel dates in my flow, for the past hours I have read many posts here but non had my issue.
In the "list row present in table" I have changed the date format to ISO 8601.
And still when I'm running the flow and trying to use a formula like convert date the response is that the input is not in ISO 8601.
So I tried the add days function
And the output I receive is very weird:
I have tried to use the function:
The solution was like that:
First of all, compose to set the Excel base time:
Where the base date is the composed base time from excel (always 12-30-1899)
Then converting the time from the add date to an ISO 8601 format
Share
Report
All responses (
Answers (
