cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PDAlvarez
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
PDAlvarez
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
Dual Super User
Dual Super User

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!



PDAlvarez
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. 

 

 

Dual Super User
Dual Super User

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!



PDAlvarez
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

 

Dual Super User
Dual Super User

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
PDAlvarez
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

Dual Super User
Dual Super User

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,840)