Filter gallery on N:N relationship

(0) Share

Report

Posted on by Community Power Pla...

Hi All

I have a question.

I have the following use case:

Dataverse tables are CLIENTS / TECHNICIANS / CAMPAIGNS

The Technicians & Campaigns are a N:N relationship.

Is it possible to filter a canvas app gallery to show only the campaigns to where the logged in user(technician) is related to?

Can't seem to find this.

Thank you in advance & kind regards

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

I have a blog on many-to-many relationships - you need to make a Collection as the Gallery Items.

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
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

You are a lifesaver! 😄

Thank you!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

I tried replicating the article but I seem to have no luck, or I am missing something.

1. We have a backoffice application where our "Campaigns" are registered.
2. We assign multiple technicians to a certain campaign.

We now have a mobile application for the technicians.

When a technician logs into the mobile application, I want to Filter the starting page gallery immediately, based on the fact that the user().Email is present in the Related Technicians for the campaigns.

This way the technicians on the mobiles, only see the campaigns which they are related to.

Can't seem to make this to work.

Thank you in advance for your response.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Please share (in Text) the code you are using that does not work

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

None, Thats my Issue.

I need to check if the logged in user is in the 'Related Technicians', so he only sees his related campaigns, and i just don't see the logic.

I tried the way that i could figure it would work:

This does not give me an error that i am doing wrong things here, but i returns no data at all.

Thank you in advance & kind regards

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Your code is a One-to-many and will work up to your Delegation limit (the blue lines are a Delegation warning, not an error). Also please remember to post code also in Text.

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
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

At the moment in the onvisible property of my screen i collect all campaigns with a certain status.

On my Gallery(on my startscreen), I have the following Formula:
There should b 2 records.

In my gallery, it shows 2 records indeed, but without any attached information + the delegation warning for the relationship which I do not like.

I'm starting to think I need to extend the 'Campaign' table in Dataverse with 5 extra lookup columns for each possible technician, but that would be malpractice in my opinion.

Thank you & kind regards

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @WarrenBelz

At the moment in the onvisible property of my screen i collect all campaigns with a certain status.

On my Gallery(on my startscreen), I have the following Formula:

ForAll(colCampaigns, LookUp(colCampaigns, User().Email in Technicians.Email))
There should b 2 records.

In my gallery, it shows 2 records indeed, but without any attached information + the delegation warning for the relationship which I do not like.

I'm starting to think I need to extend the 'Campaign' table in Dataverse with 5 extra lookup columns for each possible technician, but that would be malpractice in my opinion.

Thank you & kind regards

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

Firstly in is not Delegable, hence the warning. You have also now mentioned Dataverse - I am a SharePoint user, so I am not sure how accurate my advice will be.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

I'm sorry I thought I mentioned that.

Thank you for the effort though, I have decided to instead of using the OOB N:N capabilities of Dataverse, I create Custom N:N tables.

I'm not fully confident in the OOB N:N after this issue 🙂

Was this reply helpful? Yes No