Hi @HelpWanted17 ,
You can first set the gallery's items property:
Filter('EV PPQ Data Management', GUID(CurAprID) = User().EntraObjectId)
Then on the OnStart property, filter the data and store it in a collection:
ClearCollect(
colFilteredData,
Filter('EV PPQ Data Management', GUID(CurAprID) = User().EntraObjectId)
);
Then set the 'Items' property of the gallery to that collection:
gal_WaitingOnMyAction.Items = colFilteredData
And in the 'OnSelect' property of your button use this code:
Set(varCountPPQ, CountRows(colFilteredData))
To display the count on your menu screen or anywhere else, you can use a label and set its Text property to:
varCountPPQ
------------------------------------------------------------------------------------------------------------------------------
If I answered your question, please accept my post as a solution and if you liked my response, please give it a thumbs up.
Thanks!
