Send a email when value in choice column is selected in dataverse table

[KT61]

Hi ,

How do I created a flow that will send a email when a certain value in selected in a dataverse table.

I have a Column called "Service Required" with a drop down with choices "yes" and "no".

When "yes" is selected from the drop down, I would like the flow to send and email

[trice602]

Hi @KT61 ,

I think you can do this with a conditional action where:

'Service Required' eq 1  // true and send email

Please mark as a solution if this gets you up and running.  Always glad to help! Tom

[KT61]

Thanks, do I put it in the conditional triggers ?

[trice602]

You can so the flow only fires when Yes is selected.  If you put in the trigger condition, you don't necessarily need the conditional step because it is always going to be true when fired.  It really depends on the flow, volume, and demand whether you need a trigger condition or just use a conditional step.

Sometimes i will use the conditional step first and get the flow working and then migrate to a trigger condition.  Always glad to help! Tom

[KT61]

ah, so in the condition , I can select the dynamic content of "serviced required" is equal to 'yes'. Is that correct?

[trice602]

@KT61 ,

A yes/no field is equal to 1 or 0 in an OData query but yeah maybe in a condition set to YES and try please.  Always glad to help! Tom

[KT61]

returning a Expression Result as False, so not triggering the email

[trice602]

Can you share the conditional step please?  I want to duplicate on my machine please.  Always glad to help! Tom

[trice602]

HI @KT61 ,

Got it figured out.  I used the contact table and changed one of the Yes/No columns and it worked.  The value comes over as "true" or "false" so in a conditional setup, you would use true as in this successful example.  Please mark as a solution if this gets you up and running! Always glad to help! Tom

[trice602]

[KT61]

Thanks, still no joy, could this work if you change the labels in the choices eg. "up" "down" or "left" "right"

[trice602]

For the Yes/No value you are trying to capture, what does it show when you look at the Dataverse action output on a failed run or run that didn't send an email?  I think that's step one to see what it looks like in it's current state.  In this example, from the contact table, the Do Not Phone Yes/No (toggle button) comes back to Automate as true when I turn it on.  Always glad to help! Tom

[KT61]

Hi , thanks for all the help, 

I deleted and started again

Should the expression result not be TRUE??

[trice602]

Please enter crb97_servicerequired ; that's the root cause.  Always glad to help! Tom

[KT61]

Is this correct?

[trice602 · Accepted solution]

Looks good but change the "True" to true, lower case and run a test.  Always glad to help! Tom

[KT61]

Excellent, that worked. thanks a million!

I would like to try to get it to work with different choices in the labels in the choices eg. "up" "down" or "left" "right". 

I'll give it a try now.

[trice602]

Nice!  Have a great day over there!  A great way to start the weekend.  Feel free to tag me in future posts, always glad to help! Tom