cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Elliottd
Frequent Visitor

Update a SharePoint list from two different SharePoint lists

Hi,

 

I have an online SharePoint list which I would like to get updated by another SharePoint list.

 

In my App which is connected to a SharePoint list called Latent Defect Tracker. When I submit the date this list gets updated from my forms Pending Latent Defect and Pending Latent Defect_2 all contained in one SharePoint list (LATENT DEFECT TRACKER)

 

Submit Button code

Patch('LATENT DEFECT TRACKER',{ID:Gallery3.Selected.ID},
Defaults('LATENT DEFECT TRACKER'),
'Pending Latent Defect'.Updates,'Pending Latent Defect_2'.Updates);
NewForm('Pending Latent Defect');
NewForm('Pending Latent Defect_2');
Navigate(Success)

 

I have a gallery called Gallery3 where I can select the data and edit the form.

 

I have now added a third form called 'Defect Type and Sub Type' this form has a second data source (SharePoint list) called Defect Type and Sub Type. I have created this second list as I am using cascading dropdowns (Category and Sub Category).

On preview, the form looks good and I can select all the field items and cascading dropdowns work.

 

When I submit the form I need it to update the SharePoint list 'Latent Defect Tracker' with the data from all three forms and the data from the second SharePoint list 'Defect Type and Sub Type'

 

In the SharePoint list 'Latent Defect Tracker' I have added columns for Category and Sub Category. (Not sure I need these)

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,345)