cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LyonsBI_BRL
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. 

LyonsBI_BRL_0-1619925458352.png

 

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. 

LyonsBI_BRL_1-1619925554379.png

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?

 

21 REPLIES 21

@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

@Sid_Jafri 

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

LyonsBI_BRL_1-1619991171135.png

 

 

@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! 😀

LyonsBI_BRL_2-1619995521930.png

 

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,107)