I am currently building a Flow for new hires which is basically a checklist using a Sharepoint List. I initially had it set up with the Yes/No checkboxes and it was working fine, except that I have multiple columns and whenever I would update any column, it would re-send the emails (I'm using When an Item is Created or Modifiied) that had already been triggered. I though I could solve this by switching the checkboxes to Yes, No, Email sent dropdown list to where the flow would kick off when the list item was switched to 'Yes' and the Flow itself would then update the list to 'Email Sent' to prevent emails being re-sent. I keep seeing that my flow is successful but the emails don't get triggered when the value is changed to 'yes' on my list.
I feel like this should be something easy to get around but after a lot of research, I still can't find what I'm doing wrong.
Here's my current Flow configuration:
Hi @fgarc002 ,
From your screenshot I could see your flow run failed at action "Entered_Into_ADP_-Yes" action , is it an action in another branch of the flow? Please check from your side and let me know if your problem could be solved.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry - I should have read closer.
If you are using a choice column, you should select the item in Dynamic properties that is the column name with Value after it. I believe that your column name is Entered_into_ADP so you should select "Entered_into_ADP Value" from Dynamic properties. If you do so, then just enter the value you are looking for as plain text and not in the expression window.
It is a little more complicated if you allow for more than one value to be selected (check boxes). Here is a link that discusses this issue.
Try selecting the column name "Value" from Dynamic properties and test again.
@ScottShearer thanks for the suggestion! That definitely worked when I had the yes/no checkbox but what I'm using now is a dropdown list with Yes, No, Email Sent. When I tried just now with the expression as 'True' I still received a Failed notification
I switched from using the checkbox (where my conditions were working) to this because I have three different email notifications that get sent out when the list is updated and if one get's sent out when switched to 'yes', it will get re-sent when I update the other column to 'yes' as well, which I don't want to happen. I thought that if I could use a dropdown list to send the email when switched to 'yes' and then update the column to 'email sent' it wouuld then not re-send the email when I updated the other colums to yes.
I believe that your issue is that you should be using true or false rather than yes or no in your condition. In your case, remove the word Yes from your condition and replace it with true - true MUST BE entered in the expression window. After you enter the word true in the expression window, click on Update. Save and test your Flow after making that change.