Here is the current formula for my Gallery's Item Property:
FirstN(SortByColumns(AddColumns(GroupBy('SP Data Source', "Points_x0020_Given_x0020_To","ByEmployee"),"Points Given", Sum(ByEmployee,PointsGiven)),"Points Given",Descending),10)
It currently provides a distinct last of names and the # of points each person has accumulated.
SharePoint List Items:
Gallery in PowerApps:
I would like to add row numbers to the gallery after grouping the items by name.
If you want to make a new column with a row number I suggest you check out this blog post by forum user Tim Leung: http://powerappsguide.com/blog/post/generating-row-numbers
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @lparkerMDVIP ,
Could you please share a bit more about your scenario?
Do you want to add a Row Number Index into your Gallery?
Based on the needs that you mentioned, I have made a test on my side, please consider take a try with the following workaround:
Set the OnStart property of the App to following:
GroupBy('SP Data Source', "Points_x0020_Given_x0020_To", "ByEmployee"),
RowIndex: CountRows(RecordsCollection) + 1,
PointsGivenTo: 'Points Given To',
PointsGiven: 'Points Given',
Set the Items property of the Gallery to following:
SortByColumns(RecordsCollection, "PointsGiven", Descending),
Then re-load your app (fire the OnStart property of App), check if the issue is solved.
Within your Gallery, you could reference the Row Index value through the following formula:
More details about the ForAll function, please check the following article:
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020