Hi all,
I have a flow that runs when employees request time off. All the requests are added to a SharePoint list which is then connected to Power BI to provide a live calendar view of who is currently off. I am wondering what the easiest way is to update a different list with the total amount of available time off each employee has. The "Time Off" list has one row for each employee, and the "Vacation Request" list has over a thousand. I have seen people suggest using a variable in a Power Automate flow to update the proper row when an item is created, but I'm struggling a little bit figure out where to start.
My flow works fine for getting your time off approved or rejected, so I just need to update a Column in the "TIme Off" sharepoint list. Would it make sense to add a column to both lists that collect the users IDs every time they submit a request? My thought being the number of requested hours off would be copied to the other list based on the ID, I'm not sure if there is a better solution or if that will work how I am imagining.
I appreciate any feedback!
Hello,
What I would do is just after the request has been approved, I will lookup the record in the Time Off sharepoint list that correspond to the request initiator and then update that list item with CURRENT_TIME_OFF_VALUE - NUMBER_OF_HOURS_TAKEN
Best regards,
Alaa