I have a PowerApps app that connects to a SharePoint list. There is a column, Approver, that I want to use to filter a report. Approver is a People Picker field. I want to have a drop-down input box on my PowerApps screen that has the names of Approvers from the SharePoint list, so that I can filter the results based on approvers rather than typing in a name from the GAL. Is this possible, and if so, any tips on how to do this?

1 Answer 1


This is how you can display Approvers in a dropdown:

Collect all values from the Approver field. We want to only take "DisplayName". But you can also take an email if you wish. We collect all of these values in the Approvers array:

ClearCollect(ContractsList, Contracts);
Collect(Approvers,ForAll(ContractsList, 'Approver'.DisplayName));

Now you can simply use the Approvers array as a data source for a dropdown:

[1]: https://i.sstatic.net/mijls.png

Next, you can filter your table or a galery based on the selected value in your dropdown.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.