Connect Logic App to Dataverse in another tenant

Question

Connect Logic App to Dataverse in another tenant

Conor Deegan | CloudAssist 1

We are trying to use the List Rows (preview) flow on a logic app to connect to a dataverse on a different tenant but the only default environments available are on the 'home' tenant.

A similar question was posted 2 years ago:

https://learn.microsoft.com/en-us/answers/questions/326428/use-logic-apps-to-update-cds-dataverse-in-a-third

The answer was conflicting saying first of all not possible, then maybe possible. Is there any way of confirming if this is possible and if so, how do we go about doing this?

Dan Rios 165 Reputation points

2023-09-24T13:52:43+00:00

I’ve not done this but there is a Dataverse API with OAuth. You should look into an Azure Function or Azure Runbook that would go away and query the list rows in the third party tenant using the API and the third party’s OAuth connection (looks like an App registration in the third party tenant which you can use to connect to their dataverse with to get what you need). Then you can return the values back into the Logic app as there are both Function Invoke and Automation Runbook invoke connectors that can wait for their job outputs which can then be used further in the logic app flow once ran. So in theory it does seems doable.

More auth details here:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/authenticate-oauth

GitHub repository explaining the auth with some NET code examples which you could jump start with a Function or something:

https://github.com/MicrosoftDocs/powerapps-docs/blob/main/powerapps-docs/developer/data-platform/authenticate-oauth.md

Dan Rios 165 Reputation points

2023-09-24T13:52:43+00:00

I’ve not done this but there is a Dataverse API with OAuth. You should look into an Azure Function or Azure Runbook that would go away and query the list rows in the third party tenant using the API and the third party’s OAuth connection (looks like an App registration in the third party tenant which you can use to connect to their dataverse with to get what you need). Then you can return the values back into the Logic app as there are both Function Invoke and Automation Runbook invoke connectors that can wait for their job outputs which can then be used further in the logic app flow once ran. So in theory it does seems doable.

More auth details here:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/authenticate-oauth

GitHub repository explaining the auth with some NET code examples which you could jump start with a Function or something:

https://github.com/MicrosoftDocs/powerapps-docs/blob/main/powerapps-docs/developer/data-platform/authenticate-oauth.md

Connect Logic App to Dataverse in another tenant

Activity