Power Platform Community Forum Thread Details

Hi, I'm trying to build a Time Logging app in Powerapps using SharePoint lists.

I have some SharePoint lists:

1. A list of ships with some data and 1 or more agreements

2. A list of agreements that I want to link with the ship lists( many agreements to 1 ship)

3. A list of projects that I want to be linked with the agreements with dates of the agreement(many projects per agreement)

4. A list for logging the time spent on a project(will be used in a Powerapps form)

I'm struggling with linking the different lists so that in the app the user can select a ship, then be given different options(dropdown lookup lists) of how to fill the form to minimize input errors. Basically, if I select a ship, it would filter the lookup column of projects based on the ship name and only display projects associated with the ship, and so on.

I'm not sure how to link these lists so that this is possible. It's a pretty long chain of relationships and I can't lookup a lookup column in SharePoint. I think I have to use IDs but I'm not sure how to implement this.

Any thoughts?

Categories:

Building Power Apps