path 'emailMessage/To' with type/format 'Object' is not convertible to type/format 'String/email'.

(0) Share

Report

Posted on by AK-14012118-0

Hi All,

I am new to Power Automate. I am trying to read "Manager" (Type: Person or Group) field from the SharePoint list in 'emailMessage/To' but getting below error.

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'emailMessage' validation failed in workflow operation 'Send_Email': The parameter with value '"@triggerOutputs()?['body/Manager']"' in path 'emailMessage/To' with type/format 'Object' is not convertible to type/format 'String/email'.'.

Any way to convert the Object to String/email

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

NickWarner 113 on at

Like (0)

Report
Copy link

Link copied!

Look for "Manager Email" in the dynamic content. I have a people column in my list called Employee for this example. Manager for you and Employee for me contains an object of the name, email address, department etc.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@AK-14012118-0 It's hard to offer any recommendations without seeing the logic behind your flow. In edit mode, click on each action to expand it. Upload a screenshot of your full flow.

The error you are getting indicates that the Manager dynamic content is an Object and not a string/email.

If the Manger column in your SP list is a person column, you need to ensure you are selecting the Manager Email dynamic content which will output the email address.

You might also be interested in this YT Tutorial:

How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.

First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.

IN THIS VIDEO:
✓ How to send multiple list items in a single email with a Power Automate Flow
✓ How to create a dynamic date range
✓ How to use the Convert Time Zone action
✓ How to use a Filter Query in the Get Items action
✓ How to count number of items in an array
✓ How to use the Select action to extract a users display name and email address
✓ How to create a unique list of email addresses
✓ How to use the Create HTML Table action
✓ How to customize the HTML Table with CSS styles
✓ How to use the Send an email (V2) action
✓ How to use the Append to String Variable action
✓ How to create a custom list of items for an email
✓ How to use the Send an email (V2) action
✓ How to display singular or plural text based on the number of items returned

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No