web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Formatting the date co...

Power Automate

Answered

Formatting the date coming from Get Items

(0) Share

Report

Report

Posted on by CReay

13

I am using Get Items to grab some rows from a Sharepoint list, then want to summarise these in a table to email out once per day. I have got this working, but am having some issues formatting the dates in the table. I have attempted the below solution, with an array, but I just get the whole array in every row of the table. Any suggestions on how I can format the dates?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @CReay,

If you want apply formatting to an item in a select you can actually use an expression directly in the value field of that key.

Below is an example of that approach.

I have used this expression for my Date and Time value field:

formatDateTime(item()?['DateandTime'], 'yyyy-MM-dd')

Was this reply helpful? Yes No
CReay 13 on at

Like (0)

Report
Copy link

Link copied!

Thanks. I tried this first, but was getting an error returned. It seems to work now, so clearly I had a small issue somewhere.

Was this reply helpful? Yes No

Join the conversation