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 !
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Did you miss the call? Check out the recording here!