web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Balance remaining on a...
Power Automate
Unanswered

Balance remaining on annual request list

(0) ShareShare
ReportReport
Posted on by 7

Hello

I am building a better annual leave process for my team and I have a starting balance of 28 in a column (sharepoint list) stating Balance remaining, then every time they request time off I would like the no of days to be minus'd from the previous balance remaining and updated on the item. 

So if they take 2 days off on the 1st request it would update balance remaining with 26, then 5 days on the 2nd request it would update to 21 etc. 

I was going to do this within the sharepoint however I dont think the calculated column can work so I thought power automate would be better. 

I have created the flow based on a new item created, get item, send for approval, when I approve, update item with approved and with the new balance remaining. 

I thought it I pick up Get Item (current item) and get items (all items) I could

sub (Balance remaining (from all items), (No of days requested(from current item) 

How this just falls over can I use get items for the balance and make it look only at the previous row? I know how to do this in excel just cant get sharepoint or flow to look at the previous row 

 

Any help would be greatly appreciated @Reza 

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @LornaB 

    What you'll need to do is use a Get items action to retrieve the employees record from the SharePoint list where the leave balance is stored - I assume that there is only one entry in the list for each employee.  You'll need a way to connect the leave request with the entry in the list where the accumulated leave is stored - probably a person or group column which stores the employee name.  You'll filter the Get items action with an ODATA filter query.  

    Can you post a screen shot of your existing Flow with as much detail as possible?  I will try to assist.

     

     

     

     

  • zmm14 Profile Picture
    72 on at

    Hi  @ScottShearer I know this have some time but how do I get the ODATA filter query on the list that store employee balance info?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Expiscornovus Profile Picture

Expiscornovus 199 Most Valuable Professional

#2
David_MA Profile Picture

David_MA 194 Super User 2025 Season 2

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard