Unanswered

Filter List of Table 1 using Table 3 records to match Table 2 (here are stored relationships between T1 and T3)

(0) Share

Report

Posted on by Robert94

520

Let`s put it this way. We have 3 tables
Primary Table (PT)
Secondary Table (ST)
Relationship Table (RT) (in this table are stored new relationships that are created between PT and ST)

I have a List from PT shown in the portal, I want to filter that list this way:
I want a dropdown menu to show all records from the ST.
When selecting a record, the Name of that record should match all the rows in RT that have that Name, this way

I will see in the List only the PT rows that have the RT Name matching the ST Name.

Categories:

Tips & Tricks

General

All responses (3)

Answers (0)

Robert94 520 on at

Like (0)

Report

Re: Filter List of Table 1 using Table 3 records to match Table 2 (here are stored relationships between T1 and T3)

Hi @ragavanrajan , this solution is for filtering the Lookup records.
I`m looking to filter the list/view of a table, using M-to-m relationships.
Hugo Bernier on at

Like (0)

Report

Re: Filter List of Table 1 using Table 3 records to match Table 2 (here are stored relationships between T1 and T3)

Hi @Robert94 did @ragavanrajan 's response help you solve your issues? Is so, please consider selecting Accept as Solution on his response so that we can better help future visitors.

Thanks in advance!
ragavanrajan 7,036 Most Valuable Professional on at

Like (1)

Report

Re: Filter List of Table 1 using Table 3 records to match Table 2 (here are stored relationships between T1 and T3)

Hi @Robert94

Please have a look at the following thread from Oliver

https://www.dancingwithcrm.com/custom-lookup-filtering-powerapps-portal/

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.