Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power Flow - Send an email BUT ASK THE USER FOR THEIR EMAIL

We have a report that is embedded in our website that customers can enter their email and get a copy of the report emailed to them.  However, that widget is not actually on the Power BI report so any changes they make to the Power BI report isn't connected to the Power Flow.

 

The ask is to make it part of the Power BI report so they can customize the data before getting it emails.

 

The problem is, because it's embedded, Power BI does not know who the user is.  So the typical videos of emailing using Power Flow all suggest using the "user email" in the to line.  I need it to ask them their email.

 

For the disconnected widget the developer used "When a HTTP request is received" as the first step.

 

How do I get that flow on my report or recreate it?

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Anonymous ,Based on what I got

    Create a measure using userprincipalname(), this should give the email of the logged user

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      No. Because it's an embedded report on an externally facing website, the report does not know the UPN.  It's using a servicekey for logging in.  It needs to prompt the user for their email address.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    They're not logged into the report.  It's embedded in a website.  They're not even employees with our company. These are customers.