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

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
efialttes
Super User
Super User

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!



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. 

 

 

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!



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

 

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!



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

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,321)