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

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow that calculates y...
Power Automate
Unanswered

Flow that calculates years of seniority and increase leave balance

(0) ShareShare
ReportReport
Posted on by 8

Hello, I am working on a leave request application. I have a sharepoint list for the profile of each employee, in the list there is a column called "Hire Date" and other called "Seniority", i want a flow that compares if hire month and day are equal to current month and day then increase "Seniority" by one . Then each time "Seniority" is increased add to the "Leave Balance" column. 

 

For example, if an employee was hired on September 20, 2020 curently his "Seniority" column will be 0 aswell as his "Leave Balance" column but when September 20, 2021 comes i want "Seniority" column to increase to 1 and "Leave Balance" to 15

 

Thanks in advance.

Categories:
I have the same question (0)
  • Paul_M Profile Picture
    264 on at

    Hi @Paulo_Dima ,

    you can use a schedules flow with excel connector

    1) Every day at a certain time, the flow with run and check

    2) Hire date = utc()  (current data and time) then

    3) Increase the "Seniority" column and update the leaves column.

     

    I believe, you can have a simpler answer if you try using excel vlook up rather than power automate for this problem.

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard