Problem with ISO 8601 on a SharePoint date

[Anonymous]

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 ?

[efialttes]

Hi!

TRy this instead:

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

Hope this helps

[Anonymous]

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

[efialttes]

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

[Jcook]

Hello @Anonymous 

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

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

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

Image reference:

Hope this helps.

Best Regards,

[Anonymous]

That worked like a charm, thank you ! 🙂