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.
User | Count |
---|---|
177 | |
118 | |
87 | |
44 | |
41 |
User | Count |
---|---|
241 | |
153 | |
127 | |
77 | |
72 |