cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DuaneBergh
Advocate I
Advocate I

Read and write to 2 seperate SharePoint lists

I’m trying to build an equipment order app. I have 2 Sharepoint lists, 1 that's a data base of product and the second captures all the orders. Is it possible to read data from a SharePoint list, then write back to a separate list on the same screen? The area circled in blue on my screenshot is data coming from my product list, the red circle is the data I’d like to write back to the order list which has a separate column for each piece if equipment.

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

Hi @DuaneBergh,

 

Yes, it is possible.

Writing data into another SharePoint list is available, mostly that would depend on your requirements.

We could take use of Patch() function to create new, or update the existing records.

For example:

To create new record:

 

Patch(DataSource, Defaults(DataSource), {RecordElements})

 

To update existing record:

Patch(DataSource, Lookup(DataSource, expression), {RecordElements})

Sepcify the DataSource to the Order list, then use the data from the Equipment App  for the RecordElements part within the Patch function.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@DuaneBergh

 

PowerApps Multiple Data Sources

 

In that video, I show you exactly how to do it. I use Excel for the data source but I pull from SharePoint. Basically, on your form just change the Update value of the cards.

 

Give it a watch and let me know if you have other questions. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,195)