cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter SharePoint List (datatable) using dropdown

I have a datatable with a Sharepoint list as its source and I have a dropdown with distinct values from column "Room Location". How can I get my dropdown field to help only display room locations that match the dropdown?

 

Ie. If Conference Room 3018 is selected from the dropdown, I only want to see Room locations that equal Conference Room 3018.

1 ACCEPTED SOLUTION

Accepted Solutions

Set the Items for data table to something like

 

Filter(DataSourceName, RoomLocation = Dropdown1.Selected.Result)

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

9 REPLIES 9

Set the Items for data table to something like

 

Filter(DataSourceName, RoomLocation = Dropdown1.Selected.Result)

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Anonymous
Not applicable

PERFECT!!!!! Thank you very much!!

Anonymous
Not applicable

Is there a way to select all options, in case a user wants to see them all instead of just one conference room?

Hi Shane,

I got the same issue, but that formula seems doesnt work, I have a online sharepoint list which have a Lookup column,
and that column is for the "CustomerID" which reflects on the DDCustomerID, If I put on Datatable2 Items the following "Filter(CustomerTable, CustomerID=DDCustomerID.Selected.Value) I got an error "Invocation of Unknown or unsupported function"

I need help. TIA

Hi TIA,

in my case I had to write e.g. "DDCustomerID.Value". I think the reason is that it's language specific. In my case it's the german language. some operands are different. I would prefer to have one way to write formulars and not language dependent.

Greetings, Alex

Shane... My filter dropdown is returning multiple redundancies for each selection. Example: Unit 1 appears in the dropdown 5 times if there are 5 records containing Unit 1. Anyway to have Unit 1 only show up as 1 choice?

Not with that control. You can use a combobox, it works very similar. Change the filter to something like this: Filter(DataSourceName, RoomLocation in ComboBox1.SelectedItems)

Do you use distinct to only show the distincs values in the filter dropdown?

No. I had not used it. It only shows "Table1" which is the Datasource

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,600)