Answered

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

(0) Share

Report

Posted on by tschopp

306

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?

All responses (4)

Answers (1)

tschopp 306 on at

Like (0)

Report

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

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

a33ik 3,304 Most Valuable Professional on at

Like (1)

Report

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

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/
tschopp 306 on at

Like (0)

Report

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

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.
a33ik 3,304 Most Valuable Professional on at

Like (1)

Report

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

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.