Answered

Flow condition for SharePoint list based on multiple value choice field

(0) Share

Report

Posted on by NatashaRae

I feel like this should be easy, but I am failing to find out how to get this to work.

Basically I have list on SharePoint, and it has a choice column that is Checkboxes (to allow multiple selections, right).

Without getting into too many specifics, I want to make a Flow that will send an email notification to myself if one of the choices is not selected.

So the list item could have between 0-5 choices selected, but I only want to get an email if say Choice #1 is not checked.

How would I build the flow to do this?

EDIT: I am an extream flow novice, so please explain how to even do with like step by step and pictures are a huge plus.

Categories:

Building flows

All responses (8)

Answers (1)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NatashaRae

So check the choice value #1 is true then under the yes part don't do anthing. For the no part you can add a flow step for sending email.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@NatashaRae

Since it ids a multi choice field the resulting object in flow for that field will be an array

So the easiset thing to do would be to use expressions

just add a condition and check the length of that column

example:

length(dynamiccontentcolumnname) is equal to 0

so if length is 0 - that means no chocie selected

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
NatashaRae 39 on at

Like
a
(0)

Report
Copy link

Link copied!

@abm

ok how do I check if just the choice value #1 is true?

So far my efforts, it will check each and send me an email for every other checked box that is not Choice #1.
NatashaRae 39 on at

Like
a
(0)

Report
Copy link

Link copied!

@RezaDorrani

I'm not sure that will help me, the item could be updated to have choice #2 and #5 checked, so I would still want to know that #1 is still unchecked.

I only want to know when an item is updated if one specific choice is still unchecked.

And I have no idea what you mean by array or the impact that has...
abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @NatashaRae

Here is it.
First declare a variable called IsFound boolean type. Here Sports is my multi-choice column. Pass this to the apply each loop and set the varaible value to true or false. Finally outside the apply each loop you can check the value whether it's found or not.

There might be another way doing this.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks
NatashaRae 39 on at

Like
a
(0)

Report
Copy link

Link copied!

@abm

I'm sorry, I think that image got compressed to a point that I can not read it or I just don't know how to view images... I'm feeling super dumb and defeated today

Here is what I got so far from what I can read;
Verified answer

RezaDorrani 12,145 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @NatashaRae

Ok so make it even easy then

Use Filter data operations action

For the from property - select you dynamic value of choice field

Then for the condition use followign expression
item()?['value'] is equal to Choice 1

where Choice 1 is the value which you want to check exists or not

next just check length of filter output
if length(filteroutput) is 0 that means it was not selected
If length(filteroutput) is 1 then selected

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
NatashaRae 39 on at

Like
a
(2)

Report
Copy link

Link copied!

@RezaDorrani and @abm

Thank you both for dealing with my ineptitude. I don't know all the tools in Flow's tool kit, let alone how to use them.
And I know it's not your fault the GUI is so inefficient with space making it so hard to read in screenshots after compression.

I did get it to work after adding the Filter Data step as described.