cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Condition based on a Y/N column value - not working as expected

This approach has worked fine in the past, now it does not:

Simple Y/N column in SharePoint list. When an item is created and this Y/N column is set to Yes, Send an Email. That's all I'm after here. 

 

Have verified that the data is correct, but the Email is not sent. Has something changed with the Condition control? Is there a better way to do this?

 

Thanks in advance!

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Condition based on a Y/N column value - not working as expected

Well, I ended up recreating the Flow from scratch, as there wasn't much to it. Also used "true" as the value in the condition, rather than "Yes".

 

Works perfectly now. Wish I knew what was causing it because rebuilding should not be the solution. 

 

In any case, I'll take it - thanks for the suggestions and replies!

View solution in original post

7 REPLIES 7
Highlighted
Dual Super User III
Dual Super User III

Re: Condition based on a Y/N column value - not working as expected

Hi!

Can you please confirm how is your column configured in Sharepoint? Yes/No, choice, single line of text...

Assuming Yes/No, my suggestion is to add the following expression on the right side of your condition replacing current value

 

true

 

In order to add it as a expression, please follow this instructions

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Condition based on a Y/N column value - not working as expected

Hello Efialttes, and thank you for the reply.

It is a Y/N field in a SharePoint list. I tried the "true" value as an alternate to "Yes" but it is still not working. 

 

 

Highlighted
Dual Super User III
Dual Super User III

Re: Condition based on a Y/N column value - not working as expected

Hi!

Just for troubleshooting purposes, can you add a dummy Compose action block before the Condition, assign as its input the 'Yes No' column, reexecute the flow, inspect Compose output, and share it?

Thanx!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Condition based on a Y/N column value - not working as expected

Here is the result of added the compose action.

It's just not seeing the Yes/True value at all, assumes NO, then terminates.

Not sure why the Condition comes back with Cancelled either

Capture2.PNG

 

Highlighted
Dual Super User III
Dual Super User III

Re: Condition based on a Y/N column value - not working as expected

Almost!
Please expand the Compose action block by doublicking it, and share a screenshot of its content
Thanx!


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Condition based on a Y/N column value - not working as expected

Well, I ended up recreating the Flow from scratch, as there wasn't much to it. Also used "true" as the value in the condition, rather than "Yes".

 

Works perfectly now. Wish I knew what was causing it because rebuilding should not be the solution. 

 

In any case, I'll take it - thanks for the suggestions and replies!

View solution in original post

Highlighted
Dual Super User III
Dual Super User III

Re: Condition based on a Y/N column value - not working as expected

HURRAY!

IT WORKS!

 

My humble suggestion:

1.-Mark this topic as "Solved" by clicking "Accept as a solution". This way other community members facing this same problem in the future have the chance to find a solution faster. Please note you can even select several replies as as 'Solution', even from different community members!

Flow_AcceptSolution.png

 

2.- (OPTIONAL) Click on 'Thumbs up' in any answer you found valuable, or even in all of them 😉.

Flow_thumbsUp.png

Even though this 2nd step is OPTIONAL, please remember it is the cheapest, easiest way to say thanks to somebody that simply tried to help. And just between you and me, everytime an inspiring answer receive a kudo, an ewok escapes from The Emperor menace  😉

 

Thanx for your contribution to keep this community great!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,623)