Power Platform Community Forum Thread Details

Hello!

I am implementing a small Project Management app using SharePoint lists and I am facing an issue that I've tried to research here and did not manage to find a solution..

I have a table "Projects" containing (showing the information of Value) the Project with some characteristics as below :

ProjectID (text)	Title (text)
P8	Lorem Ipsum.
P9	This is definitely a project.

and I have another table called "InvolvedUsers" containing a LookUp to the mentioned above table and some People involved in the project. The tricky thing is that the column containing Person or Group data, is of multiple values as per below.

Project (LookUp to Projects)	ProjectID (text) (the same as the column on the left for convenience and avoidance of delegation)	Internal Assignee (multiple person/group column)
P9	P9	User 1 User 2 User 3
P8	P8	User X User 1
P1	P1	User 4
P2	P2	User 5 User 7

In my PowerApp, I have a gallery filtering Projects. What I want to achieve is filtering Projects, based on whether me - User 1 is inside the Internal Assignee column of InvolvedUsers table.

Therefore I need to see P9 and P8.

Thank you in advance to anyone taking some time to review my issue!

Already tried this and this with no success 😔

Categories:

Using Apps Using Formulas

@SmoothOperator

The problem you are dealing with is that you are actually trying to model a many to many relationship with two tables when actually three tables are a better way to do it. !1.jpg For more information about how to design your data sources, see my blog post here https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 and how to implement them in PowerApps here: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521 . In the screenshot, there is a junction table that uses the ID from the other two tables to describe the interaction between them.