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.


Report
All responses (
Answers (