Sending an EMail with details when SQL Server record is updated

[Sachintha]

I have a PowerApps canvas app that uses a SQL Server Azure database as the data source. In there I have a table TICKETS like this:

TICKETS (TicketId, Title, Status, CreatedBy)

CreatedBy is an Email address.

I want to create a flow where, when the TICKETS table is updated (say, status is changed), it should send an email to the CreatedBy, with the TicketId, Title, and the new Status in the email body. I see that there's a SQL Server 'When an item is modified (V2)' option that is triggered when a record is updated, but I don't understand how to retrieve the updated record in order to pull the relevant information.

[ChristianAbata · Accepted solution]

hi @Sachintha  to get data when a record is updated you need to add to your SQL server an column type Timestamp..

See

https://powerusers.microsoft.com/t5/Connecting-To-Data/When-an-Item-is-Modified-in-SQL-flow-is-not-w...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Timestamp-and-User-Id-record-upon-submit/td-...

[askondo]

@ChristianAbata 

Thank you for your responses to the forum. Your answers keep the forum active. Thank you for your continued support.

[ChristianAbata]

my pleasure @askondo  😉