cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
davipilot
Frequent Visitor

Filter a Drop Down Menu Based on Related Items in a Many to Many Relationship

I have two dataverse tables which we will call TableA and TableC.  They are related to each other through a Many to Many relationship.

 

I then have a Combo box to display the list of values from ColumnA in Table A.  A user will select a value from this list and save it which will now relate the selection from Table A to Table C.

 

What I would like to do and am unable to figure out, is how to filter out the values that are already related.

 

Example:

Initially the Combo box shows values of:

ValueA

ValueB

ValueC

ValueD

 

The user then relates ValueC to TableC and should only see the available values below.

 

ValueA

ValueB

ValueD

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,641)