Format Date issue

(0) Share

Report

Posted on by Kmayes

792

Hi All

I am in the middle of building a flow and i am trying to format the date columns within the create csv table so currently the dates are formatted as yyyy-MM-ddT00:00:00Z and i wish to change it to ISO 'u'. I thought that this would have been a simple formatdateTime(item()?['OData_x0032_hr_x002d_Due'],'u') however every item returned does not have a date therefore the flow fails.

Can anyone share the best work around for this situation?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Kmayes,

Can you try this expression instead?

if(empty(items('Apply_to_each')?['OData_x0032_hr_x002d_Due']), 'No date', formatdatetime(items('Apply_to_each')?['OData_x0032_hr_x002d_Due'], 'u'))

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus Unfortunately that didn't work either

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Kmayes,

Apologies, a bit too much copy pasting from my dev tenant 😁

It should have been item() instead of items('Apply_to_each')

if(empty(item()?['OData_x0032_hr_x002d_Due']), 'No date', formatdatetime(item()?['OData_x0032_hr_x002d_Due'], 'u'))

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus No problem i thought i took the apply to each out tbh ha ha. Now the flow seems to run but what I have noticed is that it is applying 'No Date' to every item... should the create csv be wrapped within an apply to each to make it work independently?

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Kmayes,

No, that shouldn't be necessary. Also see my test below.

Maybe it is worth checking if the internal name of that column is correct, in the SharePoint list settings.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Expiscornovus It looks like i miss typed an O or 0 🤣

Was this reply helpful? Yes No