Hello,
I hope you're doing well.
I have an issue regarding a gallery that I want to filter based on the user's email (which is stored in a SharePoint list).
I want some items to be visible only if the user's email is stored in a list called "VIP users" and the others only if their email is stored in a list called "Normal users".
Could you guys please help me with this ?
Thanks,
Arman
Consider this:
Filter(Datasource, EmailColumn=User().Email)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hello,
Could you please be more specific ?
Thanks,
Arman
I was not specific because your columns in your list are not known. Can you show a sample of your list or Give the names of columns containing the user emails?
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hello @eka24 , my bad.
The columns containing the users' emails are called "User email" for both lists.
Try
Filter('VIP users', 'User Email'=User().Email)
And
Filter('Normal users', 'User Email'=User().Email)
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
259 | |
122 | |
85 | |
80 | |
70 |