Power Platform Community Forum Thread Details

Hi,

I am creating an approval flow. The approval request should be send to a certain person depending on the resort the item is requested for. There are different persons for each resort.

The information is collected in a list in the sharepoint. How can I send the aproval to a certain person depending on the resort filled in?

Best

Sebastian

Categories:

Building flows

Hi SG-08101454-0 ,

Thank you for choosing Microsoft Community.

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.

For more detailed instructions, you can refer to https://learn.microsoft.com/en-us/power-automate/modern-approvals

If this fixes the issue, please mark as resolved to help others with find it.

Happy to help,

Robu 1