cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fgarc002
Level: Power Up

Flow not working with Sharpoint List dropdown

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
5 REPLIES 5
Super User
Super User

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
fgarc002
Level: Power Up

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.

Super User
Super User

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.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Community Support Team
Community Support Team

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.

fgarc002
Level: Power Up

Re: Flow not working with Sharpoint List dropdown

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


 


 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 185 members 3,979 guests
Please welcome our newest community members: