SMTP Connector - Send Email (V3) - Catch response of email delivery status in next action

[PankajKatariya]

We have created a button flow where we send email's to thousands of users, using SMTP Connector. Now there is additional requirement to log email delivery status in table of Common Data Service (CDS) or Microsoft Dataverse.

I am able to capture connector output with following expression.

output('action_name')['statusCode']

This gives 200 as response, even when email delivery is failed.

Could you please help us to find way to track email delivery status? So we can log same in CDS.

[Paulie78]

The 200 response is just telling you that the request to send the email was accepted. To do what you want to do you need to use something a little more sophisticated.

The Send Email (V3) action uses SendGrid to send the email. You can sign up to SendGrid directly and create a webhook which will inform you when the email has been delivered (and also when read). This will require a separate flow to catch that incoming request.

You will need a Flow premium plan and I would suggest that you use a paid SendGrid plan. I use them to send thousands of emails per month and it works well.