web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering on a many to...

Power Apps

Unanswered

Filtering on a many to many relationship

(0) Share

Report

Report

Posted on by berofeev

65

Hi Community!,

I have two tables: Users and Sheets.

Between these two tables I have a N:N relationship, as any number of users can be assigned to any sheets, and vice-versa.

I am trying to filter the sheets table for a gallery based on the current logged in user being assigned to the sheet.

My current logic is:

Filter(Sheets, varCurrentUser.'Primary Email' in Users.'Primary Email')

As expected, this does not work.

I am at a loss as to how I could filter this collection.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @berofeev ,

For a many-to-many relationship, this blog of mine may be able to assist - you need to make a collection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
mcbaec 28 on at

Like (0)

Report
Copy link

Link copied!

@berofeev did you solve the problem in the end? I am having the same issue. It does not through any error but it returns an empty table

Was this reply helpful? Yes No

Join the conversation