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.
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
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
183 | |
70 | |
43 | |
34 |
User | Count |
---|---|
339 | |
266 | |
116 | |
66 | |
66 |