Answered

Formatting the date coming from Get Items

(0) Share

Report

Posted on by CReay

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
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

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