You’re offline. This is a read only version of the page.
Hi
I have a Power Automate visual in Power BI that exports a CSV with field (that can include nulls) in ISO 8601 format (eg: 2024-07-03T14:00:00.000Z) that I would like to convert to dd/MM/yyyy.
I've tried several variations of the expression below, but keeps returning nulls, not sure what I am doing wrong?
if(empty(item()?['_Table[Datefield]']),null,formatDateTime(item()?['_Table[Datefield]'],'dd/MM/yyyy'))
This is my flow with the expression in the compose step;
And 'Outputs' from the Compose in the Append to array variable step
I realized what I was doing wrong, I was referering the field as if I was using 'Run query against a dataset', rather than referencing the table array.
I also didn't bother with the compose as I had previously, and instead simply did the expression in the 'append to array variable' step.
Only problem is now I need to convert the date to local and not UTC, I'm not sure how to wrap it with the right timezone? (Aus Eastern Standard Time)
EDIT; Figured it out
Instead of
Share
Report
All responses (
Answers (
if(empty(item()?['DateFieldfromTableArray']),'',formatDateTime(item()?['DateFieldfromTableArray'],'dd/MM/yyyy'))
Amended it to
if(empty(item()?['DateFieldfromTableArray']),'',convertTimeZone(item()?['DateFieldfromTableArray'],'UTC','AUS Eastern Standard Time','dd/MM/yyyy'))
Hi @Ry009_ ，
Please try this expression:
if(empty(item()?['_Table[Datefield]']),'',formatDateTime(item()?['_Table[Datefield]'],'dd/MM/yyyy'))If it still returns a null value, could you please show me a screenshot of your overall output _Table [Datefield] array?
Best Regards,
Sunshine Gu
#1
stampcoin
87
#2
Michael E. Gernaey
70
Super User 2025 Season 1
#3
David_MA
48
Super User 2025 Season 1
