Creating a lookup to a dataverse table belonging to another enviroment

(1) Share

Report

Posted on by PC-01081428-0

Hello,

I am creating a dataverse table in my Dev environment and I would like to create a lookup column to a table located in another environment. Is it possible? How should I do?

Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi

The answer is no, not really.

I mean you could try to setup a Virtual Table, but you cannot use the Dataverse connector on any environment but the current. You would have to use the HTTP Connector to even connect over the API.

So ... sorta... but not really something I see a lot of.

Was this reply helpful? Yes No
Suggested answer

ankit_singhal 590 Super User 2025 Season 2 on at

Like (1)

Report

No. But now you can access data from another environment using Power Automate. There is a new action 'selected environment' for dataverse where you can perform action on another environment using Power automate.

Was this reply helpful? Yes No
Suggested answer

powerJu 34 on at

Like (1)

Report

You cannot access table from another environment. If you need a table from other environment, you should create a solution, add the table in it, export and import in the DEV environment.

*Export and Import Solution don't bring data in it. In order to bring the data to the table you can use the Migration Tool on the Import Option in the table and connect to the environment you want to bring data from.

Was this reply helpful? Yes No