Answered

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

(0) Share

Report

Posted on by PDAlvarez

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!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

efialttes 14,756 on at

Like (1)

Report
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

Was this reply helpful? Yes No
PDAlvarez 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
PDAlvarez 26 on at

Like (0)

Report

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

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

PDAlvarez 26 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

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!

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

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!

Was this reply helpful? Yes No