You can create an approval flow in Power Automate that sends the approval request to a specific person based on the resort selected in your SharePoint list. Here's a step-by-step guide to set this up:
Create a SharePoint List:
Ensure your SharePoint list includes a column for the resort and a column for the approver's email.
Create an Approval Matrix:
Create another SharePoint list (or use an existing one) to map each resort to the corresponding approver. This list should have columns for the resort name and the approver's email.
Create a Flow in Power Automate:
Go to Power Automate and create a new flow.
Select the trigger "When an item is created" or "When an item is modified" for your main SharePoint list.
Get the Approver's Email:
Add a "Get items" action to retrieve the approver's email from the approval matrix list based on the resort selected.
Use a filter query to match the resort in the main list with the resort in the approval matrix list.
Start and Wait for an Approval:
Add the "Start and wait for an approval" action.
In the "Assigned to" field, use the dynamic content to insert the approver's email retrieved from the approval matrix list.
Handle the Approval Response:
Add actions to handle the approval response, such as updating the item status in the SharePoint list or sending a notification.
Here's a basic example of how the flow might look:
Trigger: When an item is created in the main SharePoint list.
Action: Get items from the approval matrix list where the resort matches the resort in the main list.
Action: Start and wait for an approval, assigned to the approver's email from the approval matrix list.
Action: Update the item in the main SharePoint list with the approval status.
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
Share
Report
All responses (
Answers (
