cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Updating Sharepoint list value when date of the day corresponds to a date stored in another Sharepoint List with FLOW

Hello,

 

I'm pretty new to Flow and have really no idea where to start with this one.

Basically I'm using the "Leave Request" App on Powerapps (which i customise to use with Sharepoint), let's say Employee A has 15 vacation days credit and he took 3 days (17th to 20th)  of planned vacation on the app which leaves him with 12 "unofficial" credits. At the end of his 3 days (which correspond to 3 "planned" credits) of vacation (on the 20th) his "official "vacation days credit will be updated by another flow to 12 "official" credits ("unoficial" credits basically are "official" credits minus "planned" credits).  This would then bring his credits down to 9 (since the "planned credits haven't been deducted)

The credits are placed in SP list "VacCredit" (contains name of employee, "official" credit balance, "planned" credit balance) but "planned" credits also stored in "VacRequest" (which contains name of employee, approval,start and end dates, and total days or "planned" credits). Both of the sharepoint lists are in the same site.

What I would love to do would be that on the end date (in VacRequest) of employee A's vacation the  Flow would simply set to 0 the "planned" credits field in the VacCredit which correspond to Employee A.

If you have any tips, tutorial on how to do a part of it this would be of great help, this is my last project before I leave my company so I would love to get it done.

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Updating Sharepoint list value when date of the day corresponds to a date stored in another Sharepoint List with FLOW

Hi @Anonymous ,

 

It seems that you would like to update Planned to 0 on the end of employee’s vocation date?

 

Please try if the following workaround will work for you.

 

Add the Recurrence trigger.

 

Get items from VacRequest list, use Filter query field to get items that end date equals to Today.

 

Then get items from VacCredit, add a Condition or use Filter query field to filter out corresponding employee, the condition should be configured as employee name from VacRequest equals to employee name from VacCredit.

 

Then add action Update item to update the Planned to 0.

 

Please take a try with it on your side.

 

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Updating Sharepoint list value when date of the day corresponds to a date stored in another Sharepoint List with FLOW

Hi @Anonymous ,

 

It seems that you would like to update Planned to 0 on the end of employee’s vocation date?

 

Please try if the following workaround will work for you.

 

Add the Recurrence trigger.

 

Get items from VacRequest list, use Filter query field to get items that end date equals to Today.

 

Then get items from VacCredit, add a Condition or use Filter query field to filter out corresponding employee, the condition should be configured as employee name from VacRequest equals to employee name from VacCredit.

 

Then add action Update item to update the Planned to 0.

 

Please take a try with it on your side.

 

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Re: Updating Sharepoint list value when date of the day corresponds to a date stored in another Sharepoint List with FLOW

Thank you, this was a great starting pointwhere I built upon to be able to do what I needed!

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

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

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,740)