use forall to filter all items in a gallery using another gallery

[Daniel20]

Good afternoon everyone, I am trying to solve a seemingly simple problem. I am filtering a gallery with certain conditions after which I am left with the items from the EmployeeID column that interest me. With each of these EmployeeIDs I need it to save the word "Retired" in all EmployeeIDs that match this one.

My sharepoint list:

My gallery with filters

In the "ActiveRetired" column the word "Retired" must be saved if the EmployeeID column matches some of the filtered elements in the gallery.

I'm trying this formula but it only saves one item and not all of them.

ForAll(Gallery13.AllItems;Patch([@HabilitacionEmpleado];ThisRecord;{ActivoRetirado:"Retirado"}))

Thank you very much for your support.

[Gochix]

@Daniel20 ,

First do the Patch function correctly:

Patch(
    'HabilitacionEmpleado',
    ForAll(
        Gallery13.AllItems,
        {
            ID: ThisRecord.ID,
            ActivoReirado: "Retirado"
        }
    )
)

If this doesn't work then:
Is ActivoRetirado a text column? How many records total in your SharePoint list?
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[Daniel20]

@Gochix 
thanks for your quick response. But I still can't get what I need.

Save only for one item but there are several items in sharepoint that meet that condition:

Any other ideas please?

In my list I have 30,000 items.

[Gochix]

@Daniel20 ,

I think I got it now. Correct me if I'm wrong:

You are filtering your gallery and you get a list of EmployerID in the gallery with other column data.
For example you set your filter and you get a record of:

EmployerID = 3133

And your goal is to patch the column "ActivoRetirado" to value "Retirado" for each record where EmployerID is 3133?


_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[Daniel20]

Yeeeesssss.

[Gochix · Accepted solution]

@Daniel20 ,

Then you will have to use:

ForAll(
    Gallery.AllItems As _Data,
    UpdateIf(
        'HabilitacionEmpleado',
        IDEmployer = _Data.IDEmployer,
        {
            ActivoRetirado:"Retirado"
        }
    )
)

I'm just not sure what's the data row limit for the UpdateIf function. You will have to test it and see if it works.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic! 

[Daniel20]

Thank you very much, I think I already got what I wanted but some do keep the word retired in all of them and others don't.

I guess I should wait for everything to finish loading?

[Gochix]

@Daniel20,

It might take a while to display the new data in SharePoint. But it should be visible in application straight away after update.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!