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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,832)