Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Trouble with flow using multiple choice

(0) ShareShare
ReportReport
Posted on by 87

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.
Screenshot_13.pngScreenshot_12.png

 

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

After flow was finished I get the following changes. 
Screenshot_17.png
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.
Screenshot_18.pngScreenshot_19.png

  • eliotcole Profile Picture
    4,266 Super User 2025 Season 1 on at
    Re: Trouble with flow using multiple choice

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

  • Pavel48n0sh Profile Picture
    87 on at
    Re: Trouble with flow using multiple choice

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

  • eliotcole Profile Picture
    4,266 Super User 2025 Season 1 on at
    Re: Trouble with flow using multiple choice

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

    1. create a new single line of text column called 'purchaseType'
    2. now create your calculated column with the calculation =[purchaseType]
    3. delete you single line of text column 'purchaseType'
    4. 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. 😉

  • eliotcole Profile Picture
    4,266 Super User 2025 Season 1 on at
    Re: Trouble with flow using multiple choice

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1