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 |