You’re offline. This is a read only version of the page.
Announcements
125
Morning,
I hope that someone is able to assist me with this.
I have a sharepoint list, that is effectively a contact list, with Peoples names and their role.
In my App I have a gallery that is grouped on the Role. What I want to be able to do is put a Choice control within the gallery so I can select which person I want to contact that is in that role.
The items section of my gallery has this formula
Share
ReportGroupBy(Filter(AddColumns(colApprovers,"ApName",Approver.DisplayName),varStage in'Project Stage'.Value),"ApproverRole","Details")
I have tried adding this formula to the choices box
Choices(ThisItem.Details.APName.Value)
But that just errors.
I'm sure the solution is really simple but I cant for the life of me find it, is anyone able to assist, please? I dont have to do a nested gallery do i?
I have resolved this.
Rather than use the group by function in the items of the gallery I used Distinct and a filter
All responses (
Answers (
Distinct(Filter(colApprovers,varStage in'Project Stage'.Value),'Approver Role')
Then in the combo box i used a similar formula to get the user name to appear.
Distinct(Filter(colApprovers,Title1.Text = 'Approver Role'),Approver.DisplayName)
This then Populates the combobox with the user name filtered to the role.
