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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,557)