I have tried sending just the filter node and sending the entire fetchXML.
my subgrid is on the customer form.
I would like to show the just the powerapps owner teams to which the customer belongs.
the view for the subgrid is all of the owner teams for my application (about 40)
Due to the sorry-4ssed microsoft query for a view I cannot access the intersect table teammembership therefore I cannot make a view that works as needed.
the new xml contains a link entity to teammembership with a filter for the systemuserid of the customer currently shown.
my javascript is good, error free, the setFilterXml will not change the xml
I have successfully used setFilterXML to filter a subgrid on the same customer form for another table. However there is no link-entity in it.
yes I refresh afterwards
Perhaps their is a better way? Thoughts? I am at the end of my rope, swinging in the wind :D