cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Poulpy0728
Level: Powered On

Filter and Dropdown

Hello everyone,

Based on an excel spreadsheet, I would like to display results, filtered by a drowdown.

The excel is simple :

 

Column 1 "Name" = Mickael / John / Bruce 

Column 2 "Type" = Gaming / Media / Entertainment

 

The dropdown (Dropdown1) value refers to Column2.

Below the dropdown, I created a gallery to display results, filtered by the dropdown.  I used this formula:

Filter(Tableau2,Dropdown1.Selected.Value)

But it doesn't work 😞 - A screenshot below

 

dropdown.png

 

Could you please help me ?

 

Thank you for your support.

 

1 ACCEPTED SOLUTION

Accepted Solutions
SimonPiquer
Level 8

Re: Filter and Dropdown

Hi!

 

That's great! It was my bad, I missed the fact that you set the Dropdown's Item value to the datasource's Industry column.

 

My method would work if you instead set the dropdown to a fixed range of options i.e. ,["Gaming","Media","Entertainment"], in that case, what you choose is the value. 

 

But since you have it set to Tableau2.Industry,  you have to choose from 'Industry' in the dropdown. Hope that makes sense!

 

Good job!

View solution in original post

6 REPLIES 6
SimonPiquer
Level 8

Re: Filter and Dropdown

Hi!

 

Try changing it to: 

 

Filter(Tableau2,Type = Dropdown1.Selected.Value)

This makes sure that you filter on the column called "Type". 

Poulpy0728
Level: Powered On

Re: Filter and Dropdown

@SimonPiquer 

Thank you for the quick reply. I tried but it doesn't work.

Please note that I change the name of the column "Type" by "Industry"

 

So the formula used is :

Filter(Tableau2,Industry = Dropdown1.Selected.Value)

Image2.png

 

 

SimonPiquer
Level 8

Re: Filter and Dropdown

Hi!

 

What errors are you getting on the little red crosses?

Poulpy0728
Level: Powered On

Re: Filter and Dropdown

I have tested this new one and it works :

 

Filter(Tableau2;Industry=Dropdown1.Selected.Industry)

I do not really understand the formula and if you have explaination to understand it, it will be helpful 🙂

 

SimonPiquer
Level 8

Re: Filter and Dropdown

Hi!

 

That's great! It was my bad, I missed the fact that you set the Dropdown's Item value to the datasource's Industry column.

 

My method would work if you instead set the dropdown to a fixed range of options i.e. ,["Gaming","Media","Entertainment"], in that case, what you choose is the value. 

 

But since you have it set to Tableau2.Industry,  you have to choose from 'Industry' in the dropdown. Hope that makes sense!

 

Good job!

View solution in original post

Poulpy0728
Level: Powered On

Re: Filter and Dropdown

@SimonPiquerThanks a lot! that makes sense indeed!

I was happy by the way to find the update needed by myself 🙂 and thank you for the explaination and the first formula.

Cheers!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,953)