The "To" field in approval email rejection and approval not populating

[Glen71]

I have a flow that finds a person's manager and they then receive an email with details from a SharePoint list.

The Manager then approves or rejects the content of the email.

All of a sudden the "Approved"/"Rejected" email back to the person who kicked off the approval process doesn't work.

The email that is being generated is not populating the "To" field and i have no idea why.

This is how it picks up the email address of the Requestor

This is the error and what is being picked up.

Any help or suggestions would be greatly appreciated!

Cheers

Glen

[sss · Accepted solution]

Hi Glen,

I found a similar issue: https://powerusers.microsoft.com/t5/Building-Flows/Error-message-The-to-array-is-required-for-all-pe...

Brad_Groux has provided one possible explaination:

Your error is SendGrid API related, and not Power Automate related. Please refer to the SendGrid Web API V3 documentation which is being referred to in the POST output. Please also refer to the SendGrid connector documentation, and notice that the Email parameters are of type String. What is likely happening, is the dynamic email address you are passing through, is not of the type string. See how to use the Compose or Join data operations to convert to a string.

Hope it helps.

[Glen71]

Hi 

Thanks for the response but i'm not using Send Grid. The only connectors in this are Approvals, O365 Users and Mail.

The email address is being pulled from the SharePoint list and the variable "ProjectManagerEmail" has it (i believe). This has worked many many times before but just stopped working.

Cheers

Glen

[sss]

Hi Glen,

Got it. Would you like to raise a support case to MS via Power Platform? The error message is general that cannot provide a clear RCA for your special issue.   

Support Engineer may need more information in detail for investigation, for example, your Power Automate URL

[Glen71]

HI @sss 

Yep that would be great if you could raise a support case.

Cheers

Glen