Unanswered

Flow based on a column with multiple choice

(1) Share

Report

Posted on by JorisVanBossche

Dear Power Automate experts,

I'm having a library where I've added two columns, same type (Choice) but the only difference is that in the column 'Fase' a user is allow to select multiple options where for the column 'Discipline' only one value can be selected:

Now when I add a condition I can use 'Discipline Value'

Where for 'Fase' I cannot use the value:

Result is that I cannot build a flow where for the 'Fase Value' contains 'Contractual' the file needs to be moved to a specific folder.
I hope someone has the answer?

I have the same question (0)

All responses (3)

Answers (0)

tom_riha 10,179 Most Valuable Professional on at

Like (0)

Report
Re: Flow based on a column with multiple choice

Hello @JorisVanBossche ,

once you enable multiple selection in a choice column, Power Automate will process the column as an array. To access its values it'll need to loop through all the choices inside 'Apply to each' and only then you can access the values.

You've got two options how to solve this:

1. the brute force one: convert the whole Fase dynamic content into string and check if the string contains the text 'Contractual'

string(outputs(....)?['Fase']) <contains> Contractual Note: outputs(...)?['Fase'] is the dynamic content Fase, replace it

2. extract the values from the multiple choice column using the xpath(...) expression as explained here and then compare it: https://tomriha.com/format-multiple-choice-sharepoint-column-in-csv-using-power-automate/

e.g.

xpath(xml(json(concat('{"body":{"value":', outputs(....)?['Fase'] , '}}'))), '/body/value/Value/text()')

Was this reply helpful? Yes No
diane513 4 on at

Like (0)

Report

Re: Flow based on a column with multiple choice

What is supposed to go in the "outputs(...)"?

Was this reply helpful? Yes No
tom_riha 10,179 Most Valuable Professional on at

Like (0)

Report

Re: Flow based on a column with multiple choice

outputs(...) means output from some of the previous actions

Was this reply helpful? Yes No