I have a list with a multi select choice field, depending on which option has been selected I want to run some steps in a Power Automate flow.
Multi Select Choice Fields in SharePoint
Table of Contents
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 Multi select choice field 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.
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. You can contact me using contact@sharepains.com
Thanks, always good stuff. Keep up the good work!
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.