Using a Variable to Select which List To reference

[RosstheBoss]

I am trying to use power automate desktop to help enter some information into Excel. The problem I am having is I have three different lists I need to reference, depending on the value of a cell in my excel Data. I tried creating a variable that will reference the cell, pulls in the name, and then use that to tell it which list to pull from but I could not get it working. I tried %[Condition]% as the syntax and %'Conditon'%. Is it possible to do this?

Condition	Data1	Data2
List 1	NR	R
List 2	R	R

[MichaelAnnis · Accepted solution]

For forks in your process, you want to use a Switch action combined with a Case action. It kind of looks like this.

read Excel to %DecisionMaker%

Switch on %DecisionMaker%
    Case Option1

        ‘Do option 1

    Case Option 2

         ‘Do option 2

    Case Else

        ‘Do option 3

End

best of luck

[RosstheBoss]

I was hoping to avoid that, but if I cannot use a variable to point to another variable I will have to do it.