Send an email if an item is created with a condition in Dataverse

[calerof]

Hello,

I'd like to have a Flow to send an email when a new record is created in a Dataverse table if the field "Downtime Cause" code is = 1.

I start with this:

Then in the Condition I have:

And finally I use:

The flow runs but with no positive condition:

This is my Fact table where I'm checking if an item was created:

And this is the Dimension table with the Codes that I'm checking to compare if it was "1":

I appreciate your help a lot.

Best regards,

Fernando

[abm]

Hi @calerof 

What data type is 'Downtime Cause' field? Try use expression int() to convert and compare under IF condition.

Thanks

[calerof]

@abm Thank you for your response. 

As you can see in the image above, and I repeat it here, Downtime Cause is text type. 

But the Condition is not returning a positive result before the If branch. I made the change you suggested but doesn't work.

I appreciate any help on this to make it work.

Thanks,

Fernando

[abm · Accepted solution]

Hi @calerof 

What I meant is convert the Dataverse mapping field using int() expression. In your IF condition the left side mapping field. The right side numeric value 1 is fine. Or you could try the right hand side change to string() expression or '1'. 

Thanks

[calerof]

Hi @abm ,
I did and still is not recognizing the condition as true:

There is something in my logic that's not working.

Fernando

[abm]

Hi @calerof 

Check the run history and see what values are returned before its hitting the IF condition. Also try the int() expression or string() conversion.

Thanks

[calerof]

Hi @abm ,

Here I go again, no good results:

[abm]

Hi @calerof 

Like I mentioned earlier you could try int() to convert the left hand side  IF condition DowntimeCause property dynamic mapping or try string() expression either one should work.

Thanks

[calerof]

Hello @abm ,

Here I go again, base on what try to understand. I can't use int(Donwntime cause) on the left side of Condition.

I still think the whole Flow doen't have good logic to work, and I can't figure out how to check for this conditon and send an email.

Thanks for any help.

Fernando

[calerof]

@abm ,

Thank you very much for your help Ajith! 

Your support, patience and knowledge are invaluable here. You were so kind to send me a message and take the time to make a Teams meeting to walk me through my Flow to debug and clean it and make it work.

Really appreciate it!

Cheers!

Fernando