Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Filter gallery on the basis of user location

(0) ShareShare
ReportReport
Posted on by

I am having a sharepoint list that has a column "location" which stores name of particular city where discount is available. Now In powerapps, I am having a gallery where I need to filter gallery with discounts based on the logged in user's location.  For ex - If the user belongs to Chicago he should be able to see discounts available in Chicago.

  • zmansuri Profile Picture
    zmansuri 6,048 on at
    Re: Filter gallery on the basis of user location

    Let's say you have user table where location is stored for each user.

    App.OnStart:

    Set(varUser,User());

    Set(varLocation,LookUp(UserList,Email=varUser.Email).Location);

     

    This will store logged in user's location in variable.

    in your gallery item property:

    Filter(SpList,Location.Value=varLocation)

    This will filter your list by logged in user's location

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard