Answered

Power Automate : We are seeing error while trying to send an Excel format report by email to user.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

We are facing below error(please find the attached screen snippet) while trying to send an email with Report in Excel format to User who ever click the Power Automate button, we are able to get this flow successful when we type the static email id in the "To" list, But our requirement is when the user clicks the Run Flow button in Report layout it should generate the report in Excel format to One Drive and share it by email to user.

Error: The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'emailMessage/To' is required to be of type 'String/email'. The runtime value '"'a2F2eWEucGludXBvbHVAc3diYy5jb20='"' to be converted doesn't have the expected format 'string/email'.

For this issue is related to Power Automate flow couldn’t convert the user mail in Send to

Email step errorPower BI Username

Categories:

General topics

All responses (4)

Answers (1)

Sort by

Adam-Symplifier 51 on at

Like
a
(0)

Report
Copy link

Link copied!

That looks like a user ID. I can't say I'm overly familiar, but if you add a 'Get User Profile' step, use that PowerBI dynamic content of the 'user email', it should retrieve the user. You can then use the 'mail' dynamic content from the 'Get User Profile' in the 'To' slot.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

We added the "Get User Profile" step before email step and inserted Power BI User in it, then we have an email step where we are getting user profile email from above step but we are getting the errors at Get User profile step it self. Can you please help, do we need to update anything else?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

We added the "Get User Profile" step before email step and inserted Power BI User in it, then we have an email step where we are getting user profile email from above step but we are getting the errors at Get User profile step it self. Can you please help, do we need to update anything else?
Verified answer

Adam-Symplifier 51 on at

Like
a
(1)

Report
Copy link

Link copied!

So I've had success with the below:
Use the user ID in your get profile.