Unanswered

Dynamic filtering of many-to-many lookup [Model-driven app]

(0) Share

Report

Posted on by tschopp

311

In my model-driven app, I have a many-to-many relationship between 2 tables. On the form for one of the tables, I want to have a lookup into the other table, but be able to dynamically filter the other table options. I've seen some many-to-many PCF controls that allow for filtering with FetchXML in the settings, but not the ability to change the filter FetchXML based on form values. Has anyone seen a solution for this?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (1)

a33ik 3,306 Most Valuable Professional on at

Like (1)

Report

Hello,
I would recommend to keep using OOB grids and just use setFilterXml - https://carldesouza.com/filtering-subgrids-in-dynamics-365-power-apps-with-setfilterxml/
You will be able to use filtering based on any type of attribute.

Was this reply helpful? Yes No
tschopp 311 on at

Like (0)

Report

Hi a33ik,
That will filter the contents of the subgrid, but will it filter the options that are available if the user clicks on "Add Existing <table name>"? That's the list I need filtered.

Was this reply helpful? Yes No
Verified answer

a33ik 3,306 Most Valuable Professional on at

Like (1)

Report

Ok. In case you want to add filter there you should check this post - https://blog.magnetismsolutions.com/blog/paulnieuwelaar/2018/05/17/filter-n-n-add-existing-lookup-dynamics-365-v9-supported-code/

Was this reply helpful? Yes No
tschopp 311 on at

Like (0)

Report

Thanks a33ik! That looks like what I need. I'll give that a try and let you know if it works.

Was this reply helpful? Yes No