Unanswered

Virtual table to another Dataverse instance

(0) Share

Report

Posted on by pcalder1

Is it possible to create a virtual table to another Dataverse instance? If possible, I am looking for help as to how to do it. I can't find any information. Thanks in advance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report

Yeah, you can query any data source you want from a custom data provider virtual entity.

In order to do it, you will need to build an API query as though you were external to the dv instance, because you are. This will involve building a proper authentication header, so you will need an App Registration that can use MSAL to get a valid token (either for the app itself or for a user it has Delegate Privs to act as) then send a REST API request to the target DV instance with that auth token.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report

...But, I should mention, that as cool as that idea is, you will probably find it MUCH easier to use a Dataflow to just pull in that table from the other DV and copy it into your target DV instead. That Dataflow can be set up in a few minutes and without code, and because it will be real data in your db instead of a virtual table, that means that you can trigger events like Create to drive notifications, or update flows, or whatever.

Was this reply helpful? Yes No