Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

Like (0) Share

Report

Posted on 3 May 2024 14:33:13 by SD29

132

Hi,

I am trying send an email. But its throwing an error for To field.

Requestor is the SP list column name ,data type single line of text . Its text input in SharePoint integrated custom form with default property as - If(SharePointform1.mode=Formmode.New,User().Fullname,Parent.Default)

Please help and suggest.

All responses (11)

Answers (0)

creativeopinion 10,396 Super User 2025 Season 1 on 03 May 2024 at 17:38:59

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

@SD29 If you flow is using the When a New Item is added or modified trigger. Could you not use the Modified By Email dynamic content instead? Assuming you want to get the email address of the user who modified the item.
SD29 132 on 03 May 2024 at 15:41:30

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

hi, I just tried by changing default property setting of custom form Requestor, and Its working -
Old Value- If(SharePointform1.mode=Formmode.New,User().Fullname,Parent.Default)
New Value- If(SharePointform1.mode=Formmode.New,User().Email,Parent.Default)

But this is displaying current logged in user email address in requestor field .

Flow is triggered when when a new item is added or modified to a SP List
creativeopinion 10,396 Super User 2025 Season 1 on 03 May 2024 at 15:28:23

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

@SD29 Can you show a screenshot of your full flow? It's hard to help without seeing your full flow. What is your flow trigger? Are you triggering the flow when a new MS form response is submitted? Or when a new item is added to a SP List? Your current flow logic is unclear.
SD29 132 on 03 May 2024 at 15:24:00

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

ok @creativeopinion .
Currently, Requestor is the SharePoint list column name ,data type single line of text . It is a text input in SharePoint integrated custom form with default property as - If(SharePointform1.mode=Formmode.New,User().Fullname,Parent.Default)

During new form -> Request control picks current logged in user and sends and email. This current logged in user value is saved in Single line text column in SharePoint list.

How to send email to Requestor?
creativeopinion 10,396 Super User 2025 Season 1 on 03 May 2024 at 15:17:49

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

@SD29 If the Compose action is outputting the Requestor's display name and not an email address—this is the reason you were getting the error in the Send an Email (V2) action. This action requires an email address to be entered into the To field.

You need to ensure you are selecting the correct dynamic content—one that outputs an email address.
SD29 132 on 03 May 2024 at 15:13:23

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

Test run is successful with Compose Inputs & Outputs displaying same & correct Requestor display name.
How to send an email now with subject and email body attaching to it?
creativeopinion 10,396 Super User 2025 Season 1 on 03 May 2024 at 15:03:01

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

@SD29 Can you delete your send an email action and insert the Requestor dynamic content into a Compose action and run a test?

For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
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
SD29 132 on 03 May 2024 at 14:54:24

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

Hi,
creativeopinion 10,396 Super User 2025 Season 1 on 03 May 2024 at 14:45:27

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

@SD29 Sorry this still doesn't help. Please share a screenshot of your full flow with all actions expanded in EDIT mode.
SD29 132 on 03 May 2024 at 14:43:44

Like (0)

Report

Re: Send email V2- Error- The runtime value ________ to be converted doesn't have the expected format 'string/email'.

Hi,
yeah its simple flow when condition is true its triggers mail.