Answered

Formatting the date coming from Get Items

Like (0) Share

Report

Posted on 25 May 2022 13:55:05 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?

All responses (2)

Answers (1)

CReay 13 on 25 May 2022 at 14:29:53

Like (0)

Report

Re: Formatting the date coming from Get Items

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

Expiscornovus 31,671 Most Valuable Professional on 25 May 2022 at 14:25:31

Like (1)

Report
Re: Formatting the date coming from Get Items

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')