Nesting Conditions - have reached maximum nested conditions - how to create better if Functions?

[bluelemon247]

Hello All,

Currently part of my flow reads like this:

Condition 1: if Managers name = Person A

Yes - Person A ID No - Condition 2: if Managers name = Person B

                             Yes - Person B ID / No - Condition 3: if Managers Name = Person C

                                                            Yes - Person C ID / No - Condition 4 etc....

Please see picture attached for better visual 

Is there a way of creating a list of options in a 'set variable' for all so that if A is selected it knows to use person A ID?

Or just a better way of tidying this flow up to future proof it a bit incase multiple people need adding

Thank you in advance 🙂

[Expiscornovus · Accepted solution]

Hi @bluelemon247,

You could create an array with the mapping of Manager name and the related id. You could use your input to filter the array and find the correct related person id.

Below is an example of that approach.

This could be the array.

[
{
"ManagerName": "Person A", 
"ID": "Person A ID"
},
{
"ManagerName": "Person B", 
"ID": "Person B ID"
},
{
"ManagerName": "Person C", 
"ID": "Person C ID"
}
]

This would be the expression in the set variable which retrieves the id of the first (and I assume only) item it found after filtering:

first(body('Filter_array'))['ID']

[bluelemon247]

Thank you @Expiscornovus massive help - all sorted now 

I dont suppose you would know anything about another issue i'm having - I'm getting an 'invalid URL value' error - 

Invalid URL value.

A URL field contains invalid data. Please check the value and try again.
clientRequestId: 449d2f9c-4e3d-4550-900f-018d295f7437
serviceRequestId: 449d2f9c-4e3d-4550-900f-018d295f7437

Which basically means that the URL is too long to process - is there a way round this? 

Thank you again for your help above - been working on trying to get that flow to work for ages!