Forall and UpdateIf not working

[Aionik]

Hi,

I have problems with UpdateIf and ForAll. Only the first value of my toClone collection is appended to the clone collection. It seems that the ForAll function does not work with UpdateIf. Any clues? 

Here is my code:

Set(OriginalRecord;GaToUpload.Selected);;

//Clone based on entrys to clone
ForAll(
    toClone.Unit;
    Collect(CloneCollection;OriginalRecord)
);;

//append toClone.Unit value to CloneCollection.Titel
//Does not work it does only take the first value
ForAll(toClone;
      UpdateIf(
            CloneCollection;
            Titel=GaToUpload.Selected.Titel;
            {
                Titel:Unit
            }
        )
    )

toClone Collection has

Unit

ABC

Peace

Harmony

CloneCollection looks like this

Field...n	Titel	Field...n
...	Harmony	...
...	Harmony	...
...	Harmony	...

Why is there three times occuring Harmony? And not ABC, Peace and Harmony?

 Thank you!

[Aionik]

I have added comments with new approach:

//Copy Record from Gallery  
Set(OriginalRecord;GaUnitToUpload.Selected);;

//Value to change titel from copied record 
ClearCollect(toClone;
        {Titel: "Unit"; Value:"Harmony"};
        {Titel: "Unit"; Value:"PEACE"};
        {Titel: "Unit"; Value:"Green"};
        {Titel: "Unit"; Value:"Red"}
);;

//Create Collection based on number of entries in toClone
ForAll(
    toClone;
    Collect(CloneCollection12;OriginalRecord)
);;

//change old titel from orginal record to toclone Value Text
ForAll(toClone;
      UpdateIf(
            CloneCollection12;
            Not(Titel = toClone[@Titel]);
            {Titel: toClone[@Value]}
        )
)

Please help with this issuse. It seems that ForAll and UpdateIf does not work with Collection Function.

This is my output:

[Aionik]

Any helpful ressources or work arounds when the ForAll and UpdateIf is not iterating? Please help.

Below is my current status. I take the values to be cloned as the unit number and only want to update the address and Title.

ForAll(toClone As cUnit;
      UpdateIf(
            CloneCollection As Unit;
            Not(Unit.Titel in  cUnit.Unit);
            {Titel:   cUnit.Unit;
            Adress: cUnit.Address
            }
        )
);;

[Aionik]

UpdateIf with ForAll still not working, I tried to work with official documentation and this forum. I have build a work around with AddColumns and DropColumns. But the error is still around with collection and interating with ForAll and using UpdateIf to update certain columns with the ID/Titel.

[mmbr1606 · Accepted solution]

try this please;

Set(OriginalRecord, GaToUpload.Selected);

// Clone and add a unique identifier (Index in this case)
Clear(CloneCollection);
ForAll(
    Sequence(CountRows(toClone.Unit)),
    Collect(
        CloneCollection,
        AddColumns(
            {OriginalRecord: OriginalRecord},
            "Index", Value
        )
    )
);

// Update Titel field using the unique identifier
ForAll(
    toClone,
    With(
        {currentIndex: Index},
        UpdateIf(
            CloneCollection,
            Index = currentIndex,
            {Titel: Unit}
        )
    )
);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[Aionik]

Cheers! You are a magician!