Send an E-Mail from the account that triggered the flow clicking on a button on Power BI

(0) Share

Report

Posted on by RPowerAutomated

Hello Everybody,

it is probably a very easy thing but I can't manage it by myself.

From a Report on Power BI my Users need to send an pre-formulated E-Mail with some Data from the selection made on Power BI.

I choose the Option "Send mail from a shared mailbox" and without anything is works.

As soon as I try to add some Power BI values the flow-step is being inserted in a "for each" construct. As far as I understand it expects an array. The point is, there is no array, I only need four different values from the tuple and there is never more than one tuple to be used.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

abowen 222 on at

Like (1)

Report
Copy link

Link copied!

Could you present an example of what you're trying to send in the email? As far as I can tell it's a BI table, so Automate may be wanting to send one email for each row or something silly like that. You may have to index the table or convert it to JSON perhaps. I'm not sure.

Was this reply helpful? Yes No
RPowerAutomated 42 on at

Like (0)

Report
Copy link

Link copied!

Sure!

The button is on a drill-through page in power bi, so it is already filtered. The power automate visual- fields are lets say: projectID, projectName, projectOwner. In the E-Mail the Subject has the dynamic fields projectID and projectName and in the body theres something like "Dear Sir or Madam, please contact projectOwner and so on.

I actual only need each value once in one mail.

Was this reply helpful? Yes No
abowen 222 on at

Like (1)

Report
Copy link

Link copied!
You'll likely have to write an expression to pull the data you want from the table to put in the email. That data is stored as JSON so you may need to figure out what the table looks like in that format. For instance, the projectOwner expression might be
outputs('Power_BI_table')['body/value'][0]['projectOwner']
I haven't worked with BI in Automate before so this is likely not the exact structure, just something that you might end up doing.

Let me know if I can help with anything else! I'll do my best.

Was this reply helpful? Yes No
RPowerAutomated 42 on at

Like (1)

Report
Copy link

Link copied!

Hey @abowen

Somehow the very same worked, without adding any data operation. I had to set the flow for the trigger and nothing more

Thank you for your help though!

Was this reply helpful? Yes No
abowen 222 on at

Like (0)

Report
Copy link

Link copied!

Glad to hear it!

Was this reply helpful? Yes No