Hello all,
I'm rather new to Power Automate, Sharepoint, flow, etc., but feel I've come a long way until I hit a road block!
My Flow idea:
- Submit a request for someone to cover me while I'm out of office.
- Email the Team asking for coverage.
- Who ever can cover, have our Team Calendar updated with the Dates that I'm OOO and "Covered by" filled in with that person.
Yes, I can email the Team asking the same and creating an Event manually, but how boring is that???
I've built a flow that does the following:
Created a form for a user to fill out. Required is their AD login (in a text field), and start/end dates for their time off.
When a new response is submitted => Apply to each
- Get response details - List of responses
- Compose - Inputs = AD Username
- Resolve person - gets AD account
- Create item => populates 3 of 4 fields in the list (Requester, First Day and Last Day)
THIS IS WHERE I'M STUMPED!!
I created a "Send email with options" to send to my team with just 1 option of "I got you covered". I did with the intention of who ever clicks the link, their response would update the item field "Covered by". It only updates the field with MY user account!
The next step in my flow is to have an event created in a group calendar. This works but again, the issue is finding the best way to get the user account of the person that will cover me.
I attempted going the "Approvals" route but no one has that role.
I was thinking of maybe building an email template and sending that out with a link to update a list item.
I've googled everything and watched a ton of videos with hopes of finding a similar flow.
Does anyone have any suggestions? Any assistance is always appreciated!!!
