cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajarac
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,251)