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?


Responsive Resident
Responsive Resident

Hi @LyonsBI_BRL ,


Would be possible for you to share the triggers outputs? You can hide the data and show the fields name. Please see the screenshot I shared earlier. I know I am using dataverse however behavior of showing raw data would be same for SQL.


Please Thumbs up if my post helped you solve your issue.


Yep I can, in order for the YES to display the OutPuts I had to remove the TriggerOutPut expression you had given me




Otherwise it does this



Hi @LyonsBI_BRL ,


sorry, I am looking the raw output for SQL trigger not the email or condition


Got it!

Had to set in Run a SQL Query to get the output here




Did you drop the trigger and add a new connection and trigger after changing the table schema?  Otherwise it wouldn't update to use the new schema.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hi @LyonsBI_BRL ,


Your condition was correct from the start but data that is coming from SQL says "NON-STARTED". You have to find a record that contains "LEO" and update to validate that Yes condition trigger.


Also make sure that record contains your email id otherwise email will go to the person who own the record


Please Thumbs up if my post helped you solve your issue.


@Pstork1 Okay so I removed the connector from Flow, which of course broke everything. Now when trying to re-add it back I'm getting this.




@LyonsBI_BRL ,


There was no need to drop the trigger, you could just switch the table to something else and back to the table you need. I think it is better to create a new flow instead of trouble shooting this. It will be quick as there are only few items in your flow

@Sid_Jafri @Pstork1 

Well now I can't even select the correct DB now. After adding back the connection. My app is reconnected but now I can't select the correct DB which is 2A-Industries



If you create a new flow can you see the database and table?  If not, then there is something wrong with the connection.  That will need to be fixed first.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,554)