You’re offline. This is a read only version of the page.
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.
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.
Share
Report
All responses (
Answers (
