Filter and Patch a Saher Point List

[datamaster]

Can you confirm that the ID field you are using is a unique for all records in the collection?

[sajarac]

Hello,

Yes, the ID taht I am using is the ID generate for my Share Point List.

[datamaster · Accepted solution]

Perhaps it doesn't like the ID=ID. So let's try this.

ClearCollect(
ColMySPLTable,
AddColumns(
Filter(
MySPLTable,
Year=Cboyear.Selected.Year
),
"TheID",
ID
)
);
ForAll(
ColMySPLTable,
UpdateIf(
MySPLTable,
ID = TheID,
{MarchInterest: Savings * March_Interest.Text}
)
)

[sajarac]

Thank you, I will try today your solution, I don’t understand the expression “TheID”.

I was thinking if this is affecting the result:

When I bring back my table “ColMySPLTable” I am presenting that table into a “gallery”, that gallery shows the filtered values based on my combobox selection. It is related with this ? Or no relation ?

Sorry sir I am going mental, almost a week just trying to figure out this formula

Your help is very appreciate

[sajarac]

Thank you, thank you, thank you !!!
The formula proposed works perfect.

Honestly you are the man. With this stuff

🙂