Dealing with Multi select choice fields in Microsoft Flow

Multi Select Choice Fields in SharePoint

I have a list with a multi select choice field, depending on which option has been selected I want to run some steps in Flow.

This could be difficult.

The logic of field equals value doesn’t work as I might have multiple values selected.

Choice fields in Flow

This is where Flow makes things easy for you.

My Choice column is called Checks.

In my form I can pick form 3 different options.

Now when I look in Microsoft Flow I can see 3 different Checks.

  • Checks
  • Check Item
  • Checks Value

Which one should I use?

Checks returns you a json objects as an array so that you can step through the different options selected in your tick box.

Checks

this option is good if you would like to get hold of the other information in your json. For example the Id of the option.

 

Check Item

The Check Item gives you the full json as a single array object that you can work with. If for example you want to count the number of item selected you might want to use this.

 

Checks Value

Now finally the option that I was after, Checks Value.

This simply gives me the options that I’m after. Now I want to run different steps depending on the options selected. A plain switch would not work, however we are inside the Apply to Each. With a switch inside the Apply to each we can get the flow to run something for each option that could be selected in my choice field.

 

 

 

Share
Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

View Comments

  • The Apply to each input and the Compose output both need to be the SP List item Value, which isn't shown or clearly explained here.

    • Hi Freddie,

      The apply to each will be automatically added when you select your multi select field. So Power Automate will do that all for you.

Recent Posts

Calculate the Sum for a SharePoint column in Power Automate

Last week Shane Young asked me about calculating the Sum for a SharePoint column in…

2 days ago

Object must implement IConvertible in Power Apps

In Power Apps when you do a Patch to create a new item or to…

6 days ago

Get started with adaptive cards in Power Automate

Getting started with adaptive cards can be difficult. In this post i have written some…

2 weeks ago

Create PDF documents from data in Power Automate

In this post I will look at how to create PDF documents from data. Use…

2 weeks ago

Unnest nested arrays in Power Automate

We all know this problem, you have a nested array in Power Automate but how…

3 weeks ago

Advanced settings not loading in Power Platform

Yesterday one of my clients showed me an issues where the Advanced settings didn't load.…

4 weeks ago
%%footer%%