News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Flow that auto populat...

Power Automate - Building Flows

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?

All responses Img

All responses (1)

Answers Img

Answers (0)

tom_riha 10,127 Most Valuable Professional on at

Like (0)

Report
Re: Flow that auto populate column based on other columns values

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans