Answered

Formatting Date Time Variables

(0) Share

Report

Posted on by rk2048

Issue with the formatting of the date time format
The formatting works with the dynamics connector in the flow but whilst using the CDS connector it seems to fail.

formatDateTime(variables(‘File Created On’),’dd-MM-yyyy’)

Error
Unable to process template language expressions in action ‘CREATE_File_in_Sharepoint’ inputs a’In function ‘formatDateTime’, the value provided for date time string ‘’ was not valid. The datetime string must match ISO 8601 format.’.

@abm

Raj

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rk2048 ,

Could you please share a screenshot of the configuration of your flow?

What is the output of the "File Created On" variable?

The error message told that the expression variables(‘File Created On’) have a date time string ‘’ was not valid, please check from your flow and make sure the variable should have a date time output.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
rk2048 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks the file created on variable's value had been cleared.

Was this reply helpful? Yes No