Showing results for 
Search instead for 
Did you mean: 
New Member

How to filter what is shown in a gallery based on user input

My app allows the user (a new guest) to input their information. Based on their age range (shown in the attachment) and sex, that should provide options in the gallery (a group that matches their criteria) on the next screen that match their input. How can I add this logic? 

The age range and sex populates one Sharepoint document, while the gallery contains information from a different Sharepoint source. 

Please help! 


Community Support
Community Support

Hi @jcongote ,


Could you please share more about your scenario? What are the common columns between two sharepoint sources? What is the Items property of age range combo box?


It seems that there is a column in gallery storing the age range, so let's say that age range is the common column of two sources.  Hence, this should be a simple filter problem, please refer to this sample code:


Filter('SP list', 'Age Range' = ComboboxName.Selected.'Age Range')


Please provide the detailed column construct of source, so that we can provide the accurate code.


Hi @v-siky-msft !! I so appreciate your help! 
Attached you can see more info: 

  • Lideres de Grupos Integracion Sharepoint contains the possible groups available. 
  • Next Step Ex Sharepoint contains the information of the guest.
  • I also attached a screenshot of the actual app. The guest puts in their age range, which is registered in Next Step Ex Sharepoint. The app should then look into Lideres de Grupos Integracion Sharepoint and filter based on that age range to provide the guest with options. 


So in this case, the guest (John Doe), should see groups that match their age range (13-15), which would be Juliana Congote's group. Does that make sense?


Thank you again for your help!!!! 


Helpful resources

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,959)