Need to submit multiple records to sharepoint list with one button

(0) Share

Report

Posted on by DBMSPA

Hi Community!

I have a custom form that has 5 sets of controls so it looks like this:

Because all entries will be submitted at once I would like the best way to patch the records above to the sharepoint list, and each entry needs to be a separate record because a user may need to go back and edit a specific date. Right now my submit button has 5 patch statements - one for each record - and 5 sharepoint error checks - one for each patch statement. But I feel there has got to be a better way to handle this.

HELP!?!?

Thanks,

DBMSPA

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DBMSPA ,

You could try:

Collect( YourSPList, ForAll( Table({Value:Monday Date},{Value:Tuesday Date},{Value:Wednesday Date},{Value:Thursday Date},{Value:Friday Date}), { DataColumn:Value, UserColumn:User, DropDownAColumn:dropdownA.Selected.Value, textboxAColumn:textboxA.Text， …… } ) )

Best Regards,

Bof
Verified answer

PaulD1 2,914 on at

Like
a
(0)

Report
Copy link

Link copied!

The suggestion above from @v-bofeng-msft is more concise code in that there are not five separate patches, but under the hood I believe the App will behave the same way, i.e. making 5 independent calls to SharePoint to save each of the five records and any of those calls could potentially fail. You can use the Monitor tool to see what actions the App is taking and I believe you will see 5 separate 'create row' actions, just as you do with 5 separate patch statements.
If you are trying to improve performance and/or wrap the calls into a transaction (so either all succeed or none succeed) then I'm afraid you are out of luck. You need to look to more sophisticated platforms for such features.
DBMSPA 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both for your replies, @v-bofeng-msft and @PaulD1. I may try Bof's suggestion but I feel Paul is probably correct in what will be the end result.