cannot use the formatDateTime expression to display the date fields in sharepoint list

(0) Share

Report

Posted on by sabrinekalbouss

Hello Team,

To start, I am not an expert with ms flow, but I am doing my best to learn...

I have an excel table( with a list of items) and I would like to use this excel to update some fields in my a sharepoint list. I created an ms flow and I can update the string fields without any issue. I have a problem just with Dates.. I have tried the FormatDateTime in different formats, but I still have an error message when I test the flow (see attached). I don't know in my case why I cannot use the normal expression : formatDateTime(items('Apply_to_each')?['Customer Payment Date'],'dd/MM/yyyy'...

I am struggeling with this for few days..I hope that someone can help me to solve it...

Thanks,

Sabrina

flow formatdate.png ,

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

Re: cannot use the formatDateTime expression to display the date fields in sharepoint list

@sabrinekalbouss
please use this expression-
if(empty(outputs('Dynamic content column from excel')),null,addDays('1899-12-30',int(outputs('Dynamic content column from excel')),'yyyy-MM-dd')).
Steps-
1. Use compose action and input- date column from excel
2. Add this expression.
3. in your case - Dynamic content column from excel : Customer payment Date

Note- Empty function is used to check if date column has value or not. if you do not need it use that with empty function.

Thanks
Hardesh

Was this reply helpful? Yes No
sabrinekalbouss 12 on at

Like (0)

Report

Re: cannot use the formatDateTime expression to display the date fields in sharepoint list

@Hardesh15 Thanks a lot for your reply.

I have tried to use your solution by adding a compose function first and then the expression in the update sharepoint item step ( see screenshot) and I got this time another error message.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: cannot use the formatDateTime expression to display the date fields in sharepoint list

@sabrinekalbouss

What is output of your compose? Can you share?
Thanks
Hardesh

Was this reply helpful? Yes No
sabrinekalbouss 12 on at

Like (0)

Report

Re: cannot use the formatDateTime expression to display the date fields in sharepoint list

@Hardesh15 It works now 🙂 thanks a lot for your help 🙂

Was this reply helpful? Yes No