Hello,
I am facing issue querying through data in my canvas app. There are 2 Dataverse tables - 'Projects' and 'Assignments' (see examples at the bottom).
Here is a scenario:
I am logged in to the app as User().Email = 'support2'. This means, that I am supporting projects 'Project1' and 'Project2'.
When I open app, I want to see all the resources assigned to the projects, where I am assigned.
So the formula in Items of Resources gallery, looks like this:
Filter(Assignments, User().Email in LookUp(Projects, ProjectName = ProjectName).SupportTeam)
Is there a way to make this delegable? Assignments table contains 2000+ rows.
Projects table
| ProjectName | SupportTeam |
| Project1 | support1; support2; support3... |
| Project2 | support2; support4; support5 |
| Project3 | support6 |
Assignments table
| Resource | ProjectName |
| resource1 | Project1 |
| resource2 | Project1 |
| resource3 | Project2 |
| resource4 | Project3 |