Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

When an item is modified in SQL - Update and email

I'm running into an issue when I want to kick off an email when I've changed a value in my gallery for a particular item. It's connected to a SQL server, showing the items in the gallery. What I want this automated flow to do is, when someone changes the NICS Status, it updates SQL for that item and then kicks off an email to that customer, based on their email address for that particular record. 



I have my automated flow configured like so. However, I'm not getting any emails. I did noticed when I first set the trigger, the Table names didn't populate. To fix this, I went into my SQL Created Items - Send an Email flow, and found out, when peeking at the code, it looks for the table in SQL format. 


I know I'm missing something simple here. As it is looking at the email field, for the email address that is in that column in order to kick off an email. 


Any suggestions?



@Pstork1 , @Sid_Jafri 

Okay the good news first! The connection is fixed and it's seeing the DB (thank goodness!)

If I set the flow to just send an email after modifying an item, that does work!

So it's something in the Control Trigger


 Here's the output you were looking for. Does that mean, should it be 
triggerOutputs()?['body/_NICS_x0020_Status_Label'] ?




@Sid_Jafri , @Pstork1 

SUCCESS! Okay here's what the solution was

1. @Pstork1 - Yes the turning on the RowVersions, was an absolute. 

2. @Sid_Jafri You were right about the output. So what it was looking for was this, triggerOutputs()?['body/NICS_x0020_Status']


It didn't dawn on me, until I went to Using triggerBody() / triggerOutput() to read CDS trigger metadata attributes in a Flow | Power Auto... and looked it up and looked out how it was formatted.


I ran my rest and the YES part kicked off! 😀



View solution in original post

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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