Help with Max date

(0) Share

Report

Posted on by Sjj9166

Hello all,

I'm a new PowerApps user, I'm tasked with building a proof of concept app for my organization.

I've built everything thus far buy watch YouTube videos and Google searches. My current issue is how to return the Max date or last date for each store.

background

I have a sharePoint list with a Store id called SCID and a date field with the visit date.

I want to create a 2 column collection with the SCID and the last vist date for the SCID.

I used the solution posted here and I just replaced fields with my info: https://powerusers.microsoft.com/t5/General-Discussion/Max-date/td-p/299657

PowerApps states invalid arguments received 2 expected 3 or more

ClearCollect(colLastVisit, 
 AddColumns(
 GroupBy(Store_Visit,Store_Visit.Store_SCID),
 "LastVisitDate", Max(Visit_Date))
 )
)

What did I do wrong?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sjj9166

GroupBy will return a collection with only 1 column called Result

You can just try adding a temp collection and store
GroupBy(Store_Visit,Store_Visit.Store_SCID)
and check

Hence when you try
AddColumns( GroupBy(Store_Visit,Store_Visit.Store_SCID), "LastVisitDate", Max(Visit_Date)) )
it will fail since Visit_Date is not a part of that collection

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sjj9166 ,

Based on the formula that you provided, I think there is something wrong with it. I have made a test on my side, please consider modify your formula as below:

ClearCollect(
colLastVisit,
AddColumns(
GroupBy( Store_Visit,
Store_SCID,
"GroupData" ),
"LastVisitDate",
First(Sort(GroupData, Visit_Date, Descending)).Visit_Date
)
)

Please take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No