I am working on automation processes that use the run flow button to export to Excel/ csv,
However, I am running into this error :
" Unable to process template language expressions in action 'Append To Array Variable' inputs at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string '000Z' was not valid. The datetime string must match ISO 8601 format.'. site:powerusers.microsoft.com"
my goal is to change the date format on the output from the default that Power BI "2022-01-01T16:44:13.537Z" has to the short date format 1/1/2022
This is one of my format expression
formatDateTime(parseDateTime(split(items('Apply_to_each')?[' Date'], '.')[1]), 'MM/dd/yyyy', 'en-US')
WHERE AM I DOING WRONG?
Flow overview
apply to each control
output
