working with multiple sharepoint lists

(0) Share

Report

Posted on by ammarfassy

124

Dears,

I do have 2 sharepoint list as the datasource to work with.

stationary request master
stationary request detail

Once i insert a record in the master datasource (stationary request master), i need to get the ID of that inserted record. Then i will get that ID and needs to insert some data to the detailed list (stationary request detail) in addition to some other fields.

I wanted to achieve the aboev funationality using PowerApps + Microsoft Flow (in case if its needed).

how can i proceed with?

appreciate your valuable answers. thanks in advance.

Ammar

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
In the OnSuccess property of the Master form you can use the LastSubmit property of the form to get the ID of the item that was just created or updated. Here is an example of using Patch to create a new item in Detail and setting the MasterID SharePoint field to the value of the item Id that was just submitted to Master.

Patch( [DetailDataSource], Defaults( [DetailDataSource] ), { MasterID: EditForm.LastSubmit.ID } )
If you want to set additional fields or update an existing item in Detail list then you will need to make sub changes to the Patch formula.
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ammarfassy,

You can also create an app using the stationary request master list and create records using the app. Then create a flow.

Trigger:

SharePoint - When a new item is created (Master list)

Actions:

SharePoint - Create item (Detail list)

Regards,

Mona