HI,
Here's what I may try and on the 1st version I wouldn't automate everything.
For starters, I would have two "helper" SharePoint Lists: 1) For the people giving hours and 2) for people receiving hours. As stated, I wouldn't automate populating these automatically to start.
So here's the process:
Employee A gives Employee B 2 hours. Manually, I would add Employee A and their employeeID to the donation List and as Employee A and hours column with 2. Repeat with Employee B in the receiver List.
So now you have two Lists, givers and receivers. When you form responses are submitted you have two checks. First you check if the giver has reached their 8 hours yet. You can do this by using Get Items with a filter query on the employeeID and you check if their total hours is equal to 8.
If that is true, you have a condition that sends an email, sorry you are not authorized to give more than 8 hours totals.
If not true, next you check if the receiver has been given more than 8 hours total. You use another Get Items with a filter query on the receiver employeeID and check if their total hours is equal to 8.
If true, you send an email stating the request is outside of the parameters of the program to both the receiver and giver.
If not true, you send an email to the program administrator to update the giver and receiver values to the new values, and notify both the transaction was approved.
You could automate all this with a lot more steps not described here.
------------------------------------------------
⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!
Always glad to help! 💯💯💯💯💯
Tom
Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn
