cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
datamaster
Level 8

Re: Filter and Patch a Saher Point List

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

sajarac
Level 8

Re: Filter and Patch a Saher Point List

Hello,

 

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

Capture.PNG

datamaster
Level 8

Re: Filter and Patch a Saher Point List

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}
)
)

View solution in original post

sajarac
Level 8

Re: Filter and Patch a Saher Point List

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
Level 8

Re: Filter and Patch a Saher Point List

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

Honestly you are the man. With this stuff

🙂

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,270)