web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow that auto populat...

Power Automate

Unanswered

Flow that auto populate column based on other columns values

(0) Share

Report

Report

Posted on by cnapan

24

Hi, I have a two columns, each of them is a type of multiple choice. I want to build a flow, that will auto populate 3rd column based on the chosen combination in two other columns.

So far I constructed this:

The compose expression is like that:

if(and(contains('Location', 'Tokio'),contains('Asset_x0020_type', 'Laptop')),'TOKIO-L-',if(and(contains('Location', 'Miami'),contains('Asset_x0020_type', 'Desktop')),'MIAMI-D',''))

The update item step has just Output of expression in desired column.

The flow though does not work. I think I miss some step in the schema. Can anybody help me?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @cnapan ,

as you have it now you're comparing two strings, but I think you want to compare values in columns. Therefore, you should use dynamic content in the expression. The expression should look similar to the example below:

if(and(contains(triggerOutputs()?['body/Location'], 'Tokio'),contains(triggerOutputs()?['body/Asset_x0020_type'], 'Laptop')),'TOKIO-L-',if(and(contains(triggerOutputs()?['body/Location'], 'Miami'),contains(triggerOutputs()?['body/Asset_x0020_type'], 'Desktop')),'MIAMI-D',''))

Note: it's just a guess from my side, you should use dynamic content when building the expression to get the right values.

Was this reply helpful? Yes No

Join the conversation