Announcements
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?
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.
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.
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/
Thanks a33ik! That looks like what I need. I'll give that a try and let you know if it works.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
