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'.

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 21:25:27 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 105 on 15 Jan 2025 at 03:15:43
    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 9,954 on 14 Jan 2025 at 21:49:02
    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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,654

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,440

Leaderboard
Loading started
Loading complete