web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a sharepoint li...

Power Apps

Answered

Filter a sharepoint list to drop down field.

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello !

I have a Sharepoint with two different columns (Role, Name). I have a form what is calling a name field what has drop-down type. I would like to Filter or Lookup the sharepoint list with two mentioned columns that the name field (drop-down) has only those names what have "Admine role".

I just made an quick excel table in order to visualize my situation and goal (attached)

Thank you in advance.

2021-04-15 10_02_52-Book1 - Excel.jpg

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Name is not a good title for a column as it is a Reserved Word in Power Apps, but putting this aside, your drop-down Items would be

Filter( YourTableName, Role="Admin" ).Name

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Join the conversation