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

New app with two Dataverse tables - Relationship?

I am about to create an app with two main Dataverse tables:

  1. Different types of oil.
  2. Locations where one uses oil

It will be a canvas app with the following functionality:

  • Information about the oil.
    • With possibility to see which locations the oil is used for.
  • Information about the different locations.
    • With possibility to see which oil is used for this location.

What is the best way to connect oils and locations? I am not very familiar with realtionships and lookups.

One oil can be used in several places, but theres is only one oil for each location.


Super User
Super User


You need to create a one to many relationship between the oil and location tables.

In the Oil table, I created a lookup to Location (many to one).

In PowerApps, when adding this column to a form for "Oils", I get the choice between the different locations, but are only able to choose one. Why is this? Why am I not able to choose multiple locations to add this oil for?


When adding this lookup in a form for locations, there is an error and the Items consist of only: Choices(_).

Is it not possible to edit oil type from the location form, using this method?

Helpful resources

Ignite 2022


Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,956)