How to convert Modified date from Sharepoint List in Flow

Like (0) Share

Report

Posted on 27 May 2020 00:08:38 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 28 May 2020 at 01:08:50

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 27 May 2020 at 01:05:03

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,