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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,281)