Unanswered

Trouble with flow using multiple choice

(0) Share

Report

Posted on by Pavel48n0sh

Hi,
The Result column should be automatically populated with the value from the Type column. The Type column has a choice view. This works well if you use calculated in the Result column.
However, I may have the option to select multiple values at once in the Type column, so I use checkboxes (allow multiple selections). In this case, calculated no longer works in the Result column.
I tried to set up a flow in power automate, but failed.
Please tell me what am I doing wrong and how can I fix it. Perhaps there are other options.

My PA flow:
Then I add the document to the library. Set the Type ID1 and DEV from checkboxes for it.

After flow was finished I get the following changes.

The debugger shows that the flow was finished successfully, but it showed the true for the first condition, although there was a condition for DEV, not for my ID1;DEV.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

eliotcole 4,363 Moderator on at

Like (0)

Report

Show us what you've tried so far, @Pavel48n0sh.

I might not be able to help, as I'm a bit looped out ... but if you place pictures of your failed flow in your question it can really assist people here in helping you.

Just blank out (obfuscate) any private data.

Also, watch out for running a flow on a SharePoint list triggered by modifications if you want to modify the list ... things get complicated fast because you could make loops.

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report
Alternatively, @Pavel48n0sh, you could try this hack from stack exchange (which I'm putting in my bookmarks for later! )

create a new single line of text column called 'purchaseType'

now create your calculated column with the calculation =[purchaseType]

delete you single line of text column 'purchaseType'

create a new multi choice column called 'purchaseType'

You will need to ensure that your calculated columns calculations are all finalised before step 4.

This requires zero Power Automate use, and means that you also avoid having to deal with loop avoidance. 😉

Was this reply helpful? Yes No
Pavel48n0sh 87 on at

Like (0)

Report

Oh, sorry. I forgot to add screenshots of my flow.
Already fixed 🙂

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report

Yep! Plus I think that I gave you a solution, here, @Pavel48n0sh.

Was this reply helpful? Yes No