web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to send an HTML TA...
Power Automate
Unanswered

How to send an HTML TABLE by mail with a dynamic content (User Email - Get e-mail of user who triggered flow).

(0) ShareShare
ReportReport
Posted on by 12

Hi everyone.

 

In one of my step in POWER AUTOMATE : I get this error message when i try to send a message TO an "User Email" and I don’t undersand how to resolve it …

 

" OpenApiOperationParameterTypeConversionFailed. 

The "inputs.parameters" of work flow operation "Send an e-mail_(V2)" of type "OpenApiConnection" is not valid. Error details : Input parameter item "emailMessage/To" is required to be of type "String/email". The runtime value  "amthQG1lcnktYm9pcy5jb20=" » to be converted doesn’t have the expected format : "string/email".

 

Here are the details of my steps :

 

Joka_0-1643109631856.png

 

1) Power BI Button Clicked

Joka_1-1643109752850.png

 

2) Select (data operation)

I selected Powerbi Source : @{triggerBody()?['entity']?['Power BI values']}

Joka_1-1643110278380.png

 

Joka_2-1643109801864.png

 

3) Create HTML Table

 

Joka_3-1643109829508.png

 

 

4) Send an email

  • "TO" :  I select the dynamic content "User Email" (Get e-mail of user who triggered flow) : @{triggerOutputs()['headers']['x-ms-user-email-encoded']}

Joka_0-1643110223272.png

 

Joka_4-1643109870794.png

 

And at this step, it doesn't recognize the dynamic content "user email". As the error message says : "The "TO" field haven't the expected format ?" What does it means ? How can I fix it ?

 

Thanks in advance

 

Have a nice day.

 

Joka

 

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @Joka ,

     

    Your 'To' value is a base64 value.

    You should use base64ToString() function outside the value.

    vxiaochenmsft_0-1643335535635.png

    vxiaochenmsft_1-1643335690836.png

    base64ToString('...')
    vxiaochenmsft_2-1643335720635.png

     

    Best Regards,

    Wearsky

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard