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

New app with two Dataverse tables - Relationship?

Hi!
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.


Cheers.

2 REPLIES 2
Drrickryp
Super User
Super User

@mrstian89 

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

Announcements
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.

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