CODEWITHSUNDEEP
powerappspowerapps-formulapowerapps-collection
SJJ9166
SJJ9166

Reputation: 73

How to create collection with last visit date for each store in SharePoint list

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 copied the following code from another response with a similar task. I just replaced fields with my info. 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 am I doing wrong?

Upvotes: 0

Views: 375

Answers (1)

Emily Kessler
Emily Kessler

Reputation: 231

The GroupBy() function requires 3 arguments: the table, the column names in the table you want to group by, and the new name that you are giving your group. It looks like you're missing the third argument.

Here is more information: https://learn.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby

Upvotes: 1

Related Questions