cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Filter Gallery by Dropdown and a Search Box

Hi, 

 

i would like to filter my Gallery by a dropdown and a searchbox. My searchbox work very well but my dropdown doesn't work.

 

Here is what I put in Gallery > Items : 

 

Filter(CR_1; 'Nom du projet'.Value = Gallery1.Selected.Title; TextInput3.Text in 'Décision')

 

I can't take off the formula " 'Nom du projet'.Value = Gallery1.Selected.Title" because this gallery is linked to another Gallery.

 

Do you have an idea where can i put my formula for my dropdown ? 

 

Thanks a lot!

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you for your advice I just made a test, and it worked :

 

Filter(CR_1; 'Nom du projet'.Value = Gallery1.Selected.Title; TextInput3.Text in Décision) 

 

I think its the dropdown that bothers me.

 

Thank you for your help!

 

 

View solution in original post

7 REPLIES 7
Dual Super User II
Dual Super User II

Hey!

 

Please have a look at the screenshot below: 

 

MicrosoftTeams-image (11).png

 

Expression used: 

 

Filter('[dbo].[employees]',first_name=Gallery1.Selected.first_name && last_name = Dropdown3.SelectedText.Value && first_name = TextInput2.Text)

 

Note: 

 

This is a sample snippet that will work in your case also, please replace the actual values for all the attributes and controls. In this scenario, we are filtering Gallery2 based on the selected value in Gallery one, and also the firstname is mapped to search text and last name is mapped to dropdown. Since all the conditions are returning true, the record is populated in Gallery 2

 

Hope this Helped. 
 
Thanks, 

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hello! Thank you very much for your answer but unfortunetely my gallery still doesn't work...here a screenshot.

 

PB 2.png

 

Thank you for your help!

Dual Super User II
Dual Super User II

Hey Can you please post the error that you are getting in English? 

 

Note: Ensure that the Gallery1.Selected.Title is getting mapped to the correct record of "Nom Du Projet.Value" attribute in cr_1. Verify that the data types of "Validation"and "Decision" are of type string (and if not, we will have to do a typecast to convert these values to strings). 

 

Thanks, 

 

yes in fact "Validation" is a yes or no type of data from a toglgle!

 

I haven't got a message error, just mine who said that "There is no data detected."

 

Thanks a lot!

Dual Super User II
Dual Super User II

Hi @ClemD , 

 

Can you please verify the result that you are getting from Gallery1.selected.Title, you can put that into a new label, just to test out the returned data. The filters that you are using are correct, kindly verify the data that satisfies the condition (AND condition between all the three variants).
 
Thanks, 

Thank you for your advice I just made a test, and it worked :

 

Filter(CR_1; 'Nom du projet'.Value = Gallery1.Selected.Title; TextInput3.Text in Décision) 

 

I think its the dropdown that bothers me.

 

Thank you for your help!

 

 

View solution in original post

Dual Super User II
Dual Super User II

Perfect!

 

Happy that it worked for you. 

 

Thanks, 

 

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (18,599)