Unanswered

How to submit multiple changes in multiple items in a gallery at once?

(0) Share

Report

Posted on by Andygp25

I have a gallery and a 2 forms. One form to edit some fields from the item and one form to display some fields from the item.

How can I make changes in the edit form for multiple items in the gallery and save all changes at once?

This is what I have in the submit button but save the changes for 1 item only:

SubmitForm(Form2);
Refresh('Return to Office – Employee Selection');
Navigate(Screen1,ScreenTransition.None)

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report

Hi @andygp25 ,
A form will only ever contain the record of one item, so you only save one at a time.
A gallery can be turned into an editable list, but it is not a simple process. Even then you generally only save one item at a time. Why do you want to do this?

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Hi @andygp25 ,

You can achieve this by doing the following steps:
onstart property of the app Clear(ColModifiedData);
We have to first find is there any change on the form by checking Form1.Unsaved (replace form1 with your form name) on OnSelect event of the gallery.
Add this code block
if(Form1.Unsaved,
Collect(ColModifiedData,{ID:gal.selected.ID,col1:val1,col2:val2,col3:val3,col4:val4}));
Note: Val1, val2, val3.... are from the editform
onSelect of the submit button patch all these values as below
Forall('ColModifiedData', Patch(SPListName, LookUp(SPListName,ID=colModifiedData.ID), { Col1:Val1,Col2:Val2 ..... etc } ) )
I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Andygp25 86 on at

Like (0)

Report

Thank you.

I need to display items from a list. Some fields are not editable but some are. I need to submit all changes from all items at once.

On top of that, I have labels counting items from a Sharepoint list with the same criteria.

So how do I submit all changes and update my labels?

Was this reply helpful? Yes No
Andygp25 86 on at

Like (0)

Report

col1:val1

can you please give me an example for that?

thank you.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report

Col1 is the column name in your SharePoint list and Val1 is the value modified on the form.

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Andygp25 86 on at

Like (0)

Report

Can you please give me an example for a Sharepoint column and value?

thank you.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report

when you say list! what is that list is a SharePoint list? or any other my proposed solution will work for your scenario which will cover all the requirements. Coming to updating the labels with the count, you are just editing but not adding the new values. if the label is showing any count with criteria on data they will get update automatically as soon as you submit the data.

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Andygp25 86 on at

Like (0)

Report

Can you please give me an example for a Sharepoint column and value?

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report

what is the data source you are operating on?
Here is the example for Sharepoint column and value:

Regards,
Krishna

Was this reply helpful? Yes No
Andygp25 86 on at

Like (0)

Report

Sharepoint list.

I mean in the powerapps formula.

i am not sure what to use as col and val that is why i ask for a real example with a real col and val.

Was this reply helpful? Yes No