Hi All,
I added a relationship between Contact entity and Customer custom entity in Power Portals. This created a Lookup field in Contact entity pointing to Customer entity. This works very well and is what I needed on the UI but I'm having trouble formulating a fetchxml query for this specific scenario. Below is my fetchxml query but it's throwing an invocation error. I've tried all sorts of combinations but can't seem to figure it out.
The lookup relationship field is cr8e8_customeraccountmserp and unfortunately, it is always blank when I try to log its value. I have confirmed in the dataverse that the field does have a value but it might be a whole object or some sort of pointer.
Hi @gospa
The key thing required for lookup fetchxml is a "link-entity" element used to define a relationship. I can see you have link entity and from and to element.
If you are getting an invocation error, then there may be entity attribute misspelt, or incorrect entity relationships or unsupported operators used.
The easiest way I would suggest is to use the FetchXML builder tool to generate and validate FetchXML queries.
Official link below
FetchXML Builder · XrmToolBox
Hope it helps.
------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
Fubar
69
Super User 2025 Season 1
oliver.rodrigues
49
Most Valuable Professional
Jon Unzueta
43