I have a PowerApp that filters the gallery view on the current user. On Start is set to Set(CurrentUser, User());. This part is working well. My gallery filters by Filter('DataSource', 'Contact'.Email = CurrentUser.Email). Now I want to add a filter that will also filter by this above filter OR Filter('DataSource', 'ContactManager'.Email = CurrentUser.Email). I need this to work if either one is true. Contact Manager will not be in the Contact field.
I am running into issues when trying to add the OR aspect.
Thanks
Solved! Go to Solution.
Here's my idea 🙂
Filter('DataSource', 'Contact'.Email = CurrentUser.Email Or 'ContactManager'.Email = CurrentUser.Email)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Here's my idea 🙂
Filter('DataSource', 'Contact'.Email = CurrentUser.Email Or 'ContactManager'.Email = CurrentUser.Email)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@mdevaney that worked thank you. I had tried something like this, but was over thinking and my syntax was off.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
276 | |
254 | |
87 | |
39 | |
34 |
User | Count |
---|---|
340 | |
247 | |
128 | |
73 | |
48 |