cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrpowergage
Resolver I
Resolver I

How to create a lookup from teams dataverse table to a dataverse table in another environment?

I've created a table in teams dataverse. I want it to lookup to a table in my default environment. How do I achieve this?

mrpowergage_0-1634286609583.png

ie I want the related table options to include tables from another environment.

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

Hi @mrpowergage ,

 

Not possible, sorry.  All tables must be in same environment.  Also, be careful utilizing tables in your Default Environment in general.  The Default Environment can. not be copied, backed up, etc.  See details here:  https://docs.microsoft.com/en-us/power-platform/admin/environments-overview#the-default-environment 

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,

 

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

3 REPLIES 3
dpoggemann
Super User
Super User

Hi @mrpowergage ,

 

Not possible, sorry.  All tables must be in same environment.  Also, be careful utilizing tables in your Default Environment in general.  The Default Environment can. not be copied, backed up, etc.  See details here:  https://docs.microsoft.com/en-us/power-platform/admin/environments-overview#the-default-environment 

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,

 

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

mrpowergage
Resolver I
Resolver I

thanks @dpoggemann what would you suggest as the best way to reference / work with our core client table (which I will move out of our default environment, thanks)?

Is it to create an automation to copy the records to a duplicate table. Or would you recommend a field that is a link to the record in our core table? Or to create all the data in the dataverse, and stear clear of dataverse for teams entirely? Or something else? 
many thanks

dpoggemann
Super User
Super User

Hi @mrpowergage ,

 

You can only create relationships between entities in the same environment.  Overall if it is not a licensing issue I would just go with the full Dataverse because you will probably run into limitations soon around what you can do within a Dataverse for Teams environment (especially around security) -  See the following for details (https://docs.microsoft.com/en-us/powerapps/teams/data-platform-compare)

 

From what I read (have not tried) you should be able to integrate from a full Dataverse environment to Dataverse for Teams but not sure the other way...  See here:  https://docs.microsoft.com/en-us/powerapps/teams/data-platform-compare#integration 

 

The FAQ has some good information as well...  https://docs.microsoft.com/en-us/powerapps/teams/data-platform-faqs 

 

hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,


Drew

 

 

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-odata-dataflows-migrati...  

https://powerapps.microsoft.com/en-us/blog/announcing-power-query-dataflows-for-dataverse-in-teams-p... 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,957)