cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DuaneBergh
Level: Powered On

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
Community Support Team
Community Support Team

Re: Read and write to 2 seperate SharePoint lists

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.
Super User
Super User

Re: Read and write to 2 seperate SharePoint lists

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

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 4 members 2,119 guests
Please welcome our newest community members: