Bulk update sharepoint list very slow

[Petter120]

Hi i have this Gallery connected to a sharepoint list and when i update the column "Utfall" thats yellow marked by pressing the save button "Spara",  it takes 1 minutes and 30 seconds to update it. 

Is there any faster way to get this done?

The code that im using for the OnSelect event for the button is:

ForAll(Gallery1.AllItems;
    UpdateIf(
        Produktionskommentar; ID = Value(ID); {Utfall:Value(txtUtfall.Text)}))

Thanks Petter

[gabibalaban · Accepted solution]

Hi @Petter120 ,

This approach will reduce the execution time:

ForAll(
    Gallery1.AllItems AS dataFromGallery;
    Patch(
        Produktionskommentar;
        LookUp(Produktionskommentar; ID = dataFromGallery.ID); 
        {Utfall:Value(txtUtfall.Text)}
    )
)

Hope it helps !

[Petter120]

Wow no it takes 3 seconds. 

Thanks 🙂

[Petter120]

Now i was too fast its not updating the sharepoint list (Probably why it goes so fast), any ideas why is it something with the ID?

[gabibalaban]

I updated my post. Please give it a try in this form.

[Petter120]

Now it works, thank you

[askondo]

@gabibalaban Thank you for all your responses to the forum.