Action to Set Value to ALL Selected ROWS

[Amit_Jain1]

Action to Copy From [Key] Column Having Condition ([Type] =“Yes”)
To Column [New Key] to ALL Selected ROWS

Any Idea How to Achieve This Result?

[Steve]

Action of type Data: set the values of some columns in this table, column New Key, value LOOKUP("Yes", "MyTable", "Type", "Key").

[Amit_Jain1]

I Tried Your Formula
It is Setting Same Value Every Time
I have More than One Yes in That Column
I Want to Copy Valve From Selected Column Having Value “Yes”

[Steve]

Amit_Jain:

It is Setting Same Value Every Time

That’s what you indicated you wanted, so that’s what I provided.

Amit_Jain:

I have More than One Yes in That Column

You didn’t say that originally and there was no way for me to know that.

Amit_Jain:

I Want to Copy Valve From Selected Column Having Value “Yes”

There is no simple solution for that.

[Amit_Jain1]

Any Other Solution?

[Amit_Jain1]

Anyone Can help me with This Issue?