UPDATE SELECTED ITEMS IN A POWERAPPS GALLERY

[Gorilla_8]

Hey community,

I have an app that I need to update the field status of the selected item through a PowerApps gallery, and I don't know how to do that, follow the screenshots:

Here I have some items selected and others not, but I want only the selected items to be updated, could someone help me?

Here my flow:

I also posted on the stream community: https://powerusers.microsoft.com/t5/General-Power-Automate/UPDATE-SELECTED-ITEMS-IN-A-POWERAPPS-GALL...

[Gorilla_8]

@RandyHayes 

Okay, let's take it easy now....

I have a gallery and each item has a checkbox, okay?

And the "user" will select the items within that gallery, okay?

And so there will be a button to update the selected item in the gallery, okay?

-------------------------------------------

And answering your questions:

1 - Does this mean every item in the Gallery or only the Selected ones?

Every item in the gallery, I wanna only the selected ones

Get it now?

[RandyHayes]

@Gorilla_8 

Yes, I thought I was following you completely, but I find no distinction between what is being said except around the word "Selected".  By "Selected" do you mean there is a Checkmark in the CheckBox?

[Gorilla_8]

@RandyHayes 

For example:

Here I have the gallery with three items- with the ID's in the right corner (1, 2 and 3):

And here I have 2 items selected in the gallery - ID's (2 and 3, notice that the item with ID 1 - is not selected:

And then I want to update the "status_de_preenchimento" field for the selected items.

Get it?

[RandyHayes]

@Gorilla_8 

Yes, I got that a long time ago and offered this as your formula on the OnSelect action of your button:

ForAll(Filter(Gallery1.AllItems; Checkbox_encerramento.Value);
   UpdateIf(Gestor; ID=ThisRecord.ID; 
       {Status_de_preenchimento: {Value: "Encerrado";
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}
       })
)

This will do a loop on all the items that are checked.  In your Example, this would end up being #2 and #3.  It then executes an UpdateIf on your datasource (Gestor) for the ID of the record in the Loop (in the example, first 2 then 3), and it sets the Status_de_preenchimento to "Encerrado".

This is exactly the case that you just described. 

[Gorilla_8]

@RandyHayes 

Yes, I know, and I say it again, it updates all the items in the gallery, as I said before

See:

[RandyHayes · Accepted solution]

@Gorilla_8 

What is the Text property for the Label that initially shows "xx" and then shows "encerrado"??

[Gorilla_8]

@RandyHayes 

Here:

Sorry I press the button 

[RandyHayes]

@Gorilla_8 

Something is not right...That should not be happening.  We need to diagnose a little here.  I will reply back in a few minutes while I put together some troubleshooting steps for you.

[RandyHayes · Accepted solution]

@Gorilla_8 

Oooooh....I've been BURNED by the new ThisRecord operator!!!!!!!!!!!!!

This is very good to know, and I am glad we stuck through this because we've been using the same formulas in several apps and apparently ThisRecord (just released a short while ago) has some problem.

The test that I did:

1) I set up an exact scenario to yours - SharePoint list called Gestor and Choice column etc...4 sample records.

2) Quick app with Gallery, Checkbox, label for Status and ID

3) Button with the exact formula we have been working with (small changes for commas over semicolons).

Ran test, selected 2 and it did exactly what you were seeing to all 4 records.

Picked myself up off the floor.

I put another function in the loop to collect all of the ThisRecord.ID values.  After the test of checking 2 records - the COLLECTION had 2 values in it that were exactly correct.  YET, the list updated all 4 Items.  What??

I ran a monitoring session on it and saw that yes indeed, it generated an update for all items in the list regardless of the filter. Yet only two items in the collection.

I will need to sum this up and report it back to the team in another forum post.  This should not be this way (unless I am missing something completely bizarre) 

ANYWAY, in the meantime, let's fall back to the old way of doing this before ThisRecord.   Change your formula to this now:

ForAll(
   AddColumns(
        Filter(Gallery1.AllItems; Checkbox_encerramento.Value);
        "inID", ID
   );

   UpdateIf(Gestor; ID=inID; 
       {Status_de_preenchimento: {Value: "Encerrado";
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}
       })
)

I hope this one hits the nail on the head!!!!!!!!!!

[Gorilla_8]

@RandyHayes 

You got it!

That's exactly what I needed!

But I found his execution on the list a little slow and I will try to improve it later, but I really appreciate the help and attention ...

8 pages of interaction.

Thank you very much!