Skip to main content

Notifications

Power Apps - Building 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! 

 

 
  • jcongote Profile Picture
    jcongote 3 on at
    Re: How to filter what is shown in a gallery based on user input

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

     

  • v-siky-msft Profile Picture
    v-siky-msft on at
    Re: How to filter what is shown in a gallery based on user input

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard