web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to filter what is ...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 3

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! 

 

 
Screen Shot 2020-06-02 at 9.21.48 PM.png
Screen Shot 2020-06-02 at 9.17.09 PM.png
Categories:
I have the same question (0)
  • v-siky-msft Profile Picture
    on at

    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:

    Gallery.Items: 

    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.

    Sik

  • jcongote Profile Picture
    3 on at

    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!!!! 

     

    Screen Shot 2020-06-15 at 10.59.56 AM.png
    Screen Shot 2020-06-15 at 11.06.57 AM.png
    Screen Shot 2020-06-15 at 11.06.11 AM.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 405 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 280 Super User 2025 Season 2

#3
Kalathiya Profile Picture

Kalathiya 272

Last 30 days Overall leaderboard