cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Kingpin
Kudo Kingpin

Filter and Patch a Share Point List

Hi there,

 

I hope someone could help me here:

 

This is my situation:

An the beginning of the year I have to produce a list of employees with their savings, every month somebody give me the month end interest and I have to apply that interest to all of the employees that fit into that year. So I need to filter my saherpoint list with the year i.e 2019 and then pacth the month once I have the interest for that month.

 

In the sample bellow you can see that I have two months Jan and Feb with their interest value, so I need to get March value and hit the Patch this month to have a formula that multiply "interest + Savings" and repeat this for every employee in that list.

 

Could someone point me in the right direction?

 

Thank you in advance,

 

Regards,

 

Capture.PNG 

14 REPLIES 14

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

Hello,

 

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

Capture.PNG

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

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

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

Honestly you are the man. With this stuff

🙂

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (31,004)