Power Platform Community Forum Thread Details

Hi,

I am looking to build a Power Automate flow for Teams Approvals. Here are the conditions:

1. Ask user to choose the location from a list of 5 choices (ex: us, uk, asia, eur, afr)
2. Ask user to choose the amount from a list of 4 ranges (ex: 0 to 5, 6 to 10, 11 to 25, 26 and up)

Depending on the location and the amount, a Teams Approvals form is sent to a different list of approvers.

Approval list 1 would handle location 1 and amount 1
Approval list 2 would handle location 1 and amount 2 etc.

resulting in 20 separate Approval lists

I'm not sure whether to use "Post a choice of options as the Flow Bot to a user array" for Location, then a second time for the Amount or if there is a more efficient method. Once the location and amount are chosen, is it a matter of using if/else conditions to arrive at the correct approval list to send?

Thank you.

Categories:

Building flows

Hi @AL-03022141-0 ,

Thank you for choosing Microsoft Power Platform Community.

Power Automate can efficiently handle this kind of conditional approval routing.

Recommended Approach:
Use "Post a Choice of Options" Twice

First, ask users to select the Location.

Then, ask users to select the Amount range.

Store User Responses

Save the responses into two variables (e.g., SelectedLocation & SelectedAmount).

Use a Condition-Based Logic for Routing

Utilize "Switch" or "Condition" actions to match the chosen location and amount to the corresponding approval list.

Example:

If SelectedLocation = "us" and SelectedAmount = "0 to 5", then send approval to List 1.

If SelectedLocation = "uk" and SelectedAmount = "6 to 10", send approval to List 7, and so on.

Dynamically Route to the Approval Group

Use a lookup table (such as an Excel sheet or SharePoint list) where each location/amount pair maps to an approver group.

This avoids excessive conditions and makes the process more scalable.

Alternative Option: Use Adaptive Cards
Instead of "Post a Choice of Options," consider an Adaptive Card to present both dropdowns in a single Teams message.

This reduces the number of prompts and improves user experience.

Final Step:

Once the user selects both options, trigger the approval process using "Start and Wait for an Approval" while dynamically selecting the correct approval list.

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

Happy to help
Robu 1
SuperUser|Moderator