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.
Solved! Go to Solution.
hi @Sachintha to get data when a record is updated you need to add to your SQL server an column type Timestamp..
See
Proud to be a Flownaut!
hi @Sachintha to get data when a record is updated you need to add to your SQL server an column type Timestamp..
See
Proud to be a Flownaut!
Thank you for your responses to the forum. Your answers keep the forum active. Thank you for your continued support.
my pleasure @askondo 😉
Proud to be a Flownaut!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
35 | |
34 | |
26 |
User | Count |
---|---|
39 | |
38 | |
33 | |
31 | |
24 |