Create multiple Child records and one master record on the same screen

(0) Share

Report

Posted on by johnjohn123

3,514

I have 2 SharePoint lists:-

1) Master List with these fields:-

ID
Title
Folio number
initial order qty
urgency level
Part description

2) Vendor List with these fields:-

Vendor
Part Number
Price
SID (which should store the ID of the master).

now my screen looks as follow:-

new item.png

where i need to have these 2 functionalities:-

1) when the user create a new item >> enter the master fields >> enter vendor fields >> click on "Add New" >> then new fields for the Vendor list should be shown >> so the user can add a master record and multiple vendor records on the same Save.

2) when the user edit the above form >> the related Vendor records should be shown..

so can anyone provide me with the details to implement this?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohn123 ,

Actually I don't think that append the two functionalities on only one button is a good idea, basically it would not work perfectly. One button for each update would be easier to operate for the App. Please refer to below video:

https://www.youtube.com/watch?v=xgznk4XlPCo

Best regards,

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jeffernibut can i add multiple child and a master record at one submit? or first i have to save the master record then add the child?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123

You will have to add the parent record first and ensure that it exists before the child records can be added to maintain the integrity of the relationship.

Was this reply helpful? Yes No