Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Dataverse lookup to non primary key

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.


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,509)