Power Platform Community Forum Thread Details

Hi everyone,
I'm moving from a SQL environment to dataverse because of the speed. Using SQL, I was able to create views to link several tables together to minimize the use of lookups. but actually don't see this option in dataverse. Only if you use a primary key.
Now I have the following situation.

Table Recipe Table Combi Table Cycle Table link_table
RecipeID (primary key) CombiID (Primary key) CombiID (Primary key) cr_CombiID (primary key)
Recipe Combination name Cycle cr_RecipeID

How can I request the RECIPE ID and the Recipe name from the link_table?

I hope it's a bit clear.

Categories:

Building Power Apps