I have a Gallery which contains 6 x manually-applied (lowercase) email address Fields from an SQL Data Source - each for various user roles of a Task. I only want to display the Items in the Gallery if the logged in user's email address appears in any of those 6 Fields. I have tried a multitude of ways to achieve this, including;
Adding OnStart Set(USEREMAIL,Lower(User().Email))
...then applying a Filter to the Items in the Gallery...
Filter(DATATABLE,USEREMAIL in Allocated_To || Delegated_To || Managed_By || Administered_By || Governed_By || Reporting_Manager)
This does not work and I feel like there is something more fundamental that I could use (such as "CountRows") however, each permutation presents it's own issues (delegation, etc.) I was hoping that this something that someone has successfully achieved?
Thanks!
