Group by min date (looking at sp date column)

(0) Share

Report

Posted on by sasrsc

678

I have a SPO List that contains a date field. The format is mm/dd/yyyy - it displays as a date, power apps seems to recognize it as a date Note: this is a date column in SPO and not a date/time column. I then want to do a group by...to get the minimum date by email address...The date field is called Occ In Date.

ClearCollect(HotelSummary,AddColumns(GroupBy(Hotels,"Email","GroupedItems"),"MinCheckIn",Min(GroupedItems,'Occ In Date'))
);

The response I get for the "min" value is 1620100800000 when the date field was 5/6/2021.
This could be milliseconds or something???
How can I get that min calculation to appear as a recognizable date?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

sasrsc 678 on at

Like
a
(0)

Report
Copy link

Link copied!

Text(ThisItem.a,"[$-en-US]mm/dd/yyyy")

That displays it in the correct format... as 5/4/21.