Dear,
We have two PowerPlatform Dataverse Environments: one Dynamics 365 Sales environment, and one custom Dataverse environment.
In the custom environment, we have some custom entities that we want to be able to read in the Sales environment, to be able to create Orders and Invoices from these entities...
I thought using Virtual Tables in the Sales environment to link to the custom entity in the custom environment, but it seems that it's not possible as stated here: Virtual table walkthrough using the OData Data Provider in Microsoft Dataverse - Power Apps | Microsoft Docs
You can't use the OData v4 Data Provider to connect to another Microsoft Dataverse environment
I had not read that part before, so I already tried to create a Data Provider to my custom entity, but when trying to get the data in the Sales environment, I got an error "An OData error occurred (0x880040224)", which is likely because of the limitations (or am I doing something wrong...)?
I have also tested the "Dataflow" option, but that would mean I would have to duplicate the data from the custom entities into the sales environment... The same goes with a Power Automate flow that copies data over from one to the other environment...
Is there any other way to read and use the data from one environment in another environment (in the same tenant) without duplicating everything?
We would like to keep the environments separate for security...
Best regards,
Koen
