Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Accessing Dynamics 365 Intersect Tables

Hi folks,


I'm wondering if someone can help with a problem I'm having. I'm trying to access a Dynamics 365 CE intersect table (N:N relationship). I've used the guide here: but unfortunately it's not working and I'm getting an error when I run/test the Flow. The error is BadGateway and looks like this: 

  "error": {
    "code": 502,
    "source": "",
    "clientRequestId": "9e06f5e0-546a-4001-9343-be3e137a7860",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "Dynamics 365 system returned invalid entity metadata.",
      "source": "",
      "debugInfo": "clientRequestId: 9e06f5e0-546a-4001-9343-be3e137a7860"

If I use the API URL then it doesn't return an error with the name of the table - <relationshipname>set


Any ideas?

Thanks in advance,



Community Support
Community Support

Hi @MattTaylor ,


Could you please share a screenshot of the configuration of your flow?


Best regards,



Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Alice,

Thanks for getting back to me, here's what I have: 




This is using the Dynamics connector but I've tried with the CDS one as well. 


Kind regards,


Hi Alice,

We really need to be able to do this, could you confirm that accessing intersect tables should be possible and if so link me to instructions?

Kind regards,


Hi Matt,


Not sure why you are getting 'Bad Gateway' error, I am able to access the intersect entity using '<relationshipname>set'. Do you want to try using just 'List Records' action and see if you are still getting the same error. 


Though, I still have to figure out a way to update intersect entity using Flow.






Hi Mohit,

What's weird is that I was able to do this before on another environment but I just can't get it working now - I'll have another go with the 'list records' action but I'm pretty sure I already tried that. 

When I was testing before (using a canvas app) I couldn't find a way to update the intersect table, I don't believe it's possible at the moment. For that system I had to then use a custom N:N table. 



Did you ever figure out how to get the list of relationship records. I get the same error = Bad Gateway 'Dynamics 365 system returned invalid entity metadata' when I try to list records on a relationship entity '[relationshipentityname]set' even if I add a filter.



I don't suppose you've had a chance to look at the Flow? Still experiencing the same issue and not had a response yet.


Kind regards,




Sorry for not replying, I've been working on another project but have come back to this - it still doesn't work. Have you found a solution? Not heard back from Community Support yet.



We ended up using the XRM Toolbox to move the set of N:N relationships from one instance of CRM to another which contained records which had been exported and imported from that instance, but the N:N connections were lost.


I hope this helps.

Helper I
Helper I

hi ,

try to use the Common data service (current environment ) and to give your fetchxml in the query and it should work.


Not applicable

I do not have the field to add Fetch XML. Was it removed?

Resolver I
Resolver I


As I see that a lot of people are still looking at this topic; I managed to find a solution.


Step 1: Look into the relationship in the solution, and find the Table name (Attachment 1)

get table nameget table name

Step 2: Go to Power Automate and select the Dataverse (Current Environment) connector and select a 'List Records'.

Step 3: Choose 'Custom value' and paste the table name with the following suffix: 'set'. (Attachment 2)

Add suffixAdd suffix

Step 4: Run the flow, and you get an array with the relations that you can map using the guid. 



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (2,492)