Hi @rsymmons,
One approach could be to create an array in your flow with the mappings of countries and email addresses and filter that array based on the response in the form.
Below is an example of that.
1. Add a compose action. Use a mapping like below.
[
{
"Country": "UK",
"Email": "uk@contoso.onmicrosoft.com"
},
{
"Country": "Netherlands",
"Email": "nld@contoso.onmicrosoft.com"
},
{
"Country": "Belgium",
"Email": "blg@contoso.onmicrosoft.com"
}
]
2. Add a parse json action. Use the outputs of the previous compose as content. I used the following schema
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Country": {
"type": "string"
},
"Email": {
"type": "string"
}
},
"required": [
"Country",
"Email"
]
}
}
3. Add a filter array action. Use the Outputs of the Parse Json for the From field. Compare the Question with the Country value. This should result in only one row with the correct email.
4. Add a compose action and add the following expression. Obviously you can use this expression also directly in other actions. This is just an example.
body('Filter_array')[0]['Email']
