Skip to main content

Notifications

Community site session details

Community site session details

Session Id : G6uRPmFSLy7PPskSk/pLhH
Power Automate - Building Flows
Answered

Flow not working with Sharpoint List dropdown

Like (0) ShareShare
ReportReport
Posted on 14 Sep 2019 00:55:31 by 7

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:

Flow image.png

  • fgarc002 Profile Picture
    7 on 17 Sep 2019 at 06:03:27
    Re: Flow not working with Sharpoint List dropdown

    @ScottShearer Thank you, this worked! Really appreciate your help!


     


     

  • v-alzhan-msft Profile Picture
    on 16 Sep 2019 at 06:44:59
    Re: Flow not working with Sharpoint List dropdown

    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.

  • Verified answer
    ScottShearer Profile Picture
    25,223 Most Valuable Professional on 14 Sep 2019 at 21:19:10
    Re: Flow not working with Sharpoint List dropdown

    @fgarc002 

    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.

     

     

  • fgarc002 Profile Picture
    7 on 14 Sep 2019 at 20:16:15
    Re: Flow not working with Sharpoint List dropdown

    @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 notificationFlow2.png

     

    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.

  • ScottShearer Profile Picture
    25,223 Most Valuable Professional on 14 Sep 2019 at 02:14:50
    Re: Flow not working with Sharpoint List dropdown

    @fgarc002 

    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.

     

    YesNo.jpg

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

Overall leaderboard
Loading started