Answered

Submit several EditForm to update mutiple items on a single data souce, some changes cannot get saved

(0) Share

Report

Posted on by Gary919

Hello all

I have a screen with 7 Editform controls. I use it to update 7 items on a single data source(SharePoint online list) by clicking one button, which the Onselect property is "Submitform(form1);submitform(form2)...Submitform(form7)", but only first 2 forms can save the changes to list, not sure what happens and how to fix, I appreciate if you could give me a hint.

Thanks for your time and help 🙂

Ps. the item property of edit forms look like

LookUp('List name,'Form Identifier'=Gallery1_3.Selected.Result && FormNo=1/2/.../7)

I don't use gallery because the last row is the calculated row

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gary919 ,

The formula you provided has no grammatical problems.

So, if you set up 7 buttons and submit 7 forms, will they be saved in the list ?

Best Regards,
Wearsky

Was this reply helpful? Yes No
Gary919 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, Xiao Chen, I had a try, used two Patch(s) as below to update 2 items each time, that works, but if more than 3 Patch(s), only two items are updated, that means one Patch doesn't work. I think it is the same for Submitform. you are only able to update 2 items at the same time.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gary919 ,

This may be a limitation, please try to use the Concurrent function.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No