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.
Solved! Go to Solution.
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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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.
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.
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...
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials
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;
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
@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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
44 | |
38 | |
33 | |
24 |
User | Count |
---|---|
48 | |
34 | |
32 | |
32 | |
29 |