web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help with Multiple SP ...
Power Apps
Unanswered

Help with Multiple SP Lists

(0) ShareShare
ReportReport
Posted on by Shaguar357 221

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!

 

Shaguar357_2-1701876020750.png

Shaguar357_3-1701876076406.png

Shaguar357_6-1701876262051.png

Shaguar357_7-1701876302490.png

 

 

 

 

 

Categories:
Building Power Apps
I have the same question (0)
  • AARON_C Profile Picture
    AARON_C 2,235 Most Valuable Professional on at

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

  • Shaguar357 Profile Picture
    Shaguar357 221 on at

    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 Profile Picture
    AARON_C 2,235 Most Valuable Professional on at

    @Shaguar357 

     

    How are you submitting your data to your data source?

     

    Are you using Patch or SubmitForm?

  • Shaguar357 Profile Picture
    Shaguar357 221 on at

    @AARON_C 

     

    I'm using SubmitForm.  


    Thanks,
    Craig

  • AARON_C Profile Picture
    AARON_C 2,235 Most Valuable Professional on at

    @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 Profile Picture
    Shaguar357 221 on at

    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!

    Shaguar357_0-1702391820519.png

     

  • AARON_C Profile Picture
    AARON_C 2,235 Most Valuable Professional on at

    @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 Profile Picture
    Shaguar357 221 on at

    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 Profile Picture
    AARON_C 2,235 Most Valuable Professional on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 426

#2
WarrenBelz Profile Picture

WarrenBelz 381 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 315 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans