Answered

Using a Variable to Select which List To reference

(0) Share

Report

Posted on by 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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RosstheBoss 22 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No