New Column to Classify String Values from Other Columns

[RDF25087]

Hi all -

I'm sure this is ridiculously easy, but I'm scratching my metaphorical beard...

For example, I have a column called [Colour One] and another column called [Colour Two] containing string values. I want to create a third column called [Mixed] that creates the following:

[Colour One] = Black [Colour Two] = Grey [Mixed] = Black

[Colour One] = Yellow [Colour Two] = Red [Mixed] = Orange

[Colour One] = Red [Colour Two] = Blue [Mixed] = Purple

[Colour One] = White [Colour Two] = Pink [Mixed] = White

You get the idea. Sometimes I want to create a new string value based on [Colour One] AND [Colour Two] and sometimes I just need to reference [Colour One].

Any help as always greatly received and appreciated.

RDF

[messi007 · Accepted solution]

@RDF25087,

Please see below how you can do it :

Attached the workflow.

Hope this helps!

Regards,

[Qiu]

@RDF25087 
almost same with @messi007 😁

[RDF25087]

Thank you both for the quick response. @messi007 I've amended your response for my workflow and have set it running. Fingers crossed it does the trick. It takes about an hour to run the flow - even on the business network so I'll keep you advised.

[RDF25087]

Thanks @messi007  - worked a treat.

[messi007]

@RDF25087,

Happy to help 🙂

Regards,