How to convert Modified date from Sharepoint List in Flow

(0) Share

Report

Posted on by peaches

In my flow I am reading a Sharepoint list via Get Items. Then I perform a Select data operation. At this point I like to convert the Modified date by the formatdatetime function. But at this point the Modified date field is not available under Dynamic Content. Thanks for your help.

All responses (2)

Answers (1)

peaches 4 on at

Like (0)

Report

Re: How to convert Modified date from Sharepoint List in Flow

That worked. I had tried something similar but had typed it into the value field instead of the Expression area. Thank you very much!
Verified answer

v-bacao-msft on at

Like (1)

Report
Re: How to convert Modified date from Sharepoint List in Flow

Hi @peaches ,

Please try to use the expression to get Modified and format it:

formatDateTime(item()['Modified'],'MM/dd/yyyy')

Best Regards,