Help with Multiple SP Lists

(0) Share

Report

Posted on by Shaguar357

211

Good Day Everyone,

I'm seeking help on a project where I have two SP lists: One that populates the app (first screen shot), then the user navigates to the second screen to enter vehicle inspection details which would populates the second SP list (Vehicles_Equipment_Inspections). The third screen shot was included to show how I had originally set up the SP List, before realizing I'd need another SP list to capture the inspection details.

Can someone instruct me as to what is required here?

Thank you kindly!

Categories:

Copilot

General Questions

Mobile App

All responses (9)

Answers (0)

AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Help with Multiple SP Lists

@Shaguar357

You need to create a one-to-many relationship, where a vehicle/equipment can have many inspections.
You could use the VIN number of the vehicle if you don't have another ID column. In your child list (Vehicle_Equipment_Inspections) you would create your columns 'Inspection Date', 'Comments/Notes', 'Attachments' and a loop up column to the parent table (Vehicle and Equipment List).

Once you have created your list and added the new form to your app let me know. There is another trick I can show you once this has been set up.
Shaguar357 211 on at

Like (0)

Report

Re: Help with Multiple SP Lists

Hi @AARON_C

Yes. You are correct, there will be many inspections. As I'm fairly new to building apps, automation, etc, can you elaborate on how I would go about doing this?

Thanks again for your time!
AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Help with Multiple SP Lists

@Shaguar357

I assume that if you want two separate lists the relationship between the two would be a one-to-many relationship. Where a vehicle/equipment can have many inspections.

If so, you would need to create a lookup column in the Vehicle_Equipment_Inspections to the Vehicle and Equipment List.
Shaguar357 211 on at

Like (0)

Report

Re: Help with Multiple SP Lists

Hi @AARON_C

The item is BrowseGallery1.Selected. Which updates the record in the first SP List (Vehicle and Equipment List), however, I'd like to have this update a second SP List (Vehicle_Equipment_Inspections). Any idea on how to do this?

Thank you!
AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Help with Multiple SP Lists

@Shaguar357

How are you opening your form? By the looks of the photos, I assume you have something like 'gallery1.Selected' in the Items property of the form. This would update the record you have selected.
Shaguar357 211 on at

Like (0)

Report

Re: Help with Multiple SP Lists

@AARON_C

I'm using SubmitForm.

Thanks,
Craig
AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Help with Multiple SP Lists

@Shaguar357

How are you submitting your data to your data source?

Are you using Patch or SubmitForm?
Shaguar357 211 on at

Like (0)

Report

Re: Help with Multiple SP Lists

Hi @AARON_C

I thought I needed one list to populate the Vehicle/Equipment inventory and another to capture the inspections for each Vehicle/Equipment. I had it originally set up in the one list and it would capture inspection data, however, if someone completed another inspection, it would overwrite the first inspection. I need to be able to capture all inspection data entered on app.

Can you offer specific advice on how I'd go about doing so?
AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Help with Multiple SP Lists

Hi @Shaguar357,

Why do you think you need to add another SharePoint list if that new list only contains 3 extra columns?

You can just use one list and just select which columns you would like to display in the gallery (first screen), and the columns you would like to display in your form (second screen).