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 ?

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Problem with ISO 8601 on a SharePoint date

That worked like a charm, thank you ! 🙂
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Problem with ISO 8601 on a SharePoint date

Hi @Anonymous ,

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

Image reference:

Hope this helps.

Best Regards,
Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: Problem with ISO 8601 on a SharePoint date

Hello @Anonymous

Can you try to use the Convert time zone action. This will ensure your format matches ISO format
efialttes 14,756 on at

Like (0)

Report

Re: Problem with ISO 8601 on a SharePoint date

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
Community Power Pla... on at

Like (0)

Report

Re: Problem with ISO 8601 on a SharePoint date

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

Like (0)

Report
Re: Problem with ISO 8601 on a SharePoint date

Hi!

TRy this instead:

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

Hope this helps