Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by
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
  • Suggested answer
    NickWarner Profile Picture
    NickWarner 113 on at
    path 'emailMessage/To' with type/format 'Object' is not convertible to type/format 'String/email'.
    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.
     
  • creativeopinion Profile Picture
    creativeopinion 10,103 on at
    path 'emailMessage/To' with type/format 'Object' is not convertible to type/format 'String/email'.
    @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:

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard