You’re offline. This is a read only version of the page.
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.
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
Share
Report
All responses (
Answers (
6,048
