cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattTaylor
Level: Powered On

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: https://www.sikich.com/insight/how-to-find-n-n-relationships-with-dynamics-365-logic-apps-and-flow/ 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": "europe-002.azure-apim.net",
    "clientRequestId": "9e06f5e0-546a-4001-9343-be3e137a7860",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "Dynamics 365 system returned invalid entity metadata.",
      "source": "commondataservice-we.azconn-we.p.azurewebsites.net",
      "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,


Matt

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: Accessing Dynamics 365 Intersect Tables

Hi @MattTaylor ,

 

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

 

Best regards,

Alice       

 

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.

MattTaylor
Level: Powered On

Re: Accessing Dynamics 365 Intersect Tables

Hi Alice,


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

 

flowerror.jpg

 

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

 

Kind regards,


Matt

Highlighted
MattTaylor
Level: Powered On

Re: Accessing Dynamics 365 Intersect Tables

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,


Matt

MohitPowerBI
Level: Powered On

Re: Accessing Dynamics 365 Intersect Tables

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.

 

Thanks,

Mohit

 

 

MattTaylor
Level: Powered On

Re: Accessing Dynamics 365 Intersect Tables

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. 

Cheers,

Matt

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 213 members 5,184 guests
Please welcome our newest community members: