Problem with ISO 8601 on a SharePoint date

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I'm struggling with a problem on a SharePoint date not in ISO 8601 format.

formatDateTime('triggerBody()?["Created"]', 'dd/mm/yyyy hh:mm tt')

It returns that the submitted date/hour chain is not valid and must match the ISO 8601 format. I tried converting the date to ISO format using the convertToUtc() function, still returned that in order to use this function I need a valid date.

I'm really stuck with this issue, could someone help me figure this out please ?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Hi!

TRy this instead:

formatDateTime(triggerBody()?['Created'], 'dd/mm/yyyy hh:mm tt')

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Unfortunately it cannot help, there is a larger function around, at first I used the single quotes, still got me the same error.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!

I am afraid the sintaxis from your first expression IS wrong.

You can simply add a dummy 'Compose' action block before the action block where your flow crashes, then assign my suggested expression as its input. REexecute the flow, see if it works

If it does, just share the whole expression (with the larger function around) so we can try to help putting the pieces together

Hope this helps

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @Anonymous

Can you try to use the Convert time zone action. This will ensure your format matches ISO format

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @Anonymous ,

We should add '' outside Created and need to remove '' outside the triggerBody()?[‘Create’].

Image reference:

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

That worked like a charm, thank you ! 🙂

Was this reply helpful? Yes No