I created a canvas app and I added an Home page.
On this home page, I want to display the name of each user and their related records (records for which they are the owner).
But I don't really succeed to do this, and I don't know how I can handle that.
I would like to do a screen like below:
In this example, I created two labels, one for each user, because I don't want to display all users (some Microsoft's users that will never get any records associated with), and I put a Countif formula to count the number of records.
Depending on the label where the user will click, he will then see an other screen with a gallery filtered on the previous user selected:
Maybe my idea of having two labels is not the good start.
Can someone give me hints to manage this requirement?
Hi @LauM ,
I suppose that your data source is a Sharepoint List.
On your home screen, you can put a gallery seted like:
Items -> GroupBy(AddColumns(your_data_source,"UserName", Author.DisplayName),"UserName","Result")
and inside the gallery use 2 labels:
Label1 -> Text = ThisItem.UserName
Label2 -> Text = CountRows(Result)
OnSelect property of the gallery set a global variable:
Hope it helps !
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.