Share
Report
59Making a flow that parses a table in an excel spreadsheet to send out an email with a list of all rows with a date that is within a month of flow execution. However after googling for hours I've finally come to realize that my problem stems from excel storing dates as serial date format.
I know I need to compose an expression prior to running my comparison between formatDateTime of the spreadsheet and the current time, however all solutions I've found seem to run into different errors such as the value needing to be an array rather than a string despite converting back from string.
My error is as follows: 'In function 'formatDateTime', the value provided for date time string '44389.4583333333' was not valid. The datetime string must match ISO 8601 format.'
Please feel free to ask any questions if necessary, this project is really important to my clients and me. I know people don't like when someone asks a question without prior research, but I have been at it for like 5 hours now. Thank you in advance for any assistance you can provide.
All responses (
Answers (
