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

[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)

[WarrenBelz]

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?

[KrishnaV]

Hi @andygp25 ,

You can achieve this by doing the following steps:

1. onstart property of the app Clear(ColModifiedData);
2. 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.
3. 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
4. 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.

[andygp25]

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?

[andygp25]

col1:val1

can you please give me an example for that?

thank you. 

[KrishnaV]

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.

[andygp25]

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

thank you. 

[KrishnaV]

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.

[andygp25]

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

[KrishnaV]

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

Regards,

Krishna