Hi @Mixy,
Could you please share a bit more about your scenario?
Do you want to trigger a flow when the user inserts a record into your SQL table or updates an existing record within your SQL table?
Do you mean that your flow is not fired continuously?
If you want to triger a flow when the user inserts a record into your SQL table, I think your flow's configuration is proper.
If you want to triger a flow when the user updates an existing record within your SQL table, I think there is something wrong with your flow's configuration. You should modify the "When an item is created" trigger into the "When an item is modified" trigger within your flow.
In addition, I think it is not necessary to use a flow to send an email, you could consider send an email within your app directly.
Please check and see if the following blog would help in your scenario:
https://powerapps.microsoft.com/en-us/blog/html-email-reporting-with-tabular-data/
I have made a test on my side, please take a try with the following workarond:
Add the following formula within the OnSuccess property of the Edit form control:
Office365.SendEmail( /* <-- Add formula start */
"Test1@xxxxx.xxmicrosoft.com", /* <-- Here type your own specific email */
"New Record is created in your SQL table",
"<h3>Asset Checkout Notification</h3>" &
"<strong> Items: </strong>" &
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
"<tr style='background-color:#efefef'>
<th>X_REF_FNAME</th> <th> X_REF_LNAME </th> <th> X_REF_PHONE </th><th> X_REF_EMAIL </th>
</tr>
<tr>" &
"<td>" & EditForm1.LastSubmit.X_REF_FNAME & " </td>
<td>" & EditForm1.LastSubmit.X_REF_LNAME & " </td>
<td>" & EditForm1.LastSubmit.X_REF_PHONE & " </td>
<td>" & EditForm1.LastSubmit.X_REF_EMAIL & " </td>
</tr><tr>" &"</table>",
{IsHtml:true}
); /* <-- Add formula end */
Back()
Best regards,
Kris
