I am trying to only show distinct choices from 2 sharepoint fields on my powerapp. My sharepoint list is called RWA Approver Matrix. The choices I need to show are from the fields called Division Contracts Manager and Delegates. These are both people fields. Here is what I currently have in the items field, and it works fine for the Division Contracts Manager field but I am not able to get it to work for both of the fields. It would be a bonus if anyone can help me also filter by a Field called Division that is also on my RWA Approver Matrix list. Any help would be greatly appreciated.
​
For your request to show distinct choices from two fields, you could try to combine the two column rows by Table.
Try something like below
Distinct(
Table(
RenameColumns(
ShowColumns(
Students,
Owners
),
Owners,
Persons
),
RenameColumns(
ShowColumns(
Students,
Manager
),
Manager,
Persons
)
),
Persons.DisplayName
)
Replace Students with your data source, and replace Owers&Manager with your own fields.
Regards,
Meekou Personal Support
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
