cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
germskiller2
Regular Visitor

Mailto: function with PowerBIIntergration data

Hi All,

 

I am new to PowerApps but I am trying to create a mailto button within PowerBI which will open Outlook and auto populate email addresses from the connected PowerBI data I have linked.

 

Please tell me what is wrong with this function:

Launch("Mailto:" &[@PowerBIIntegration].Data.'Email Address')

 

 

4 REPLIES 4
StalinPonnusamy
Super User
Super User

Hi @germskiller2 

Below is my assumption on your requirement

  • Powerapps has a button to open outlook
  •  You embedding Powerapps within Power BI

with this assumption, 2 things need to fix it

1. [@PowerBIIntegration].Data could be a table. You have to parse the table to get the email address

2. Syntax - Launch("mailto:emailaddress")

 

 

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

For more context, yes I am attempting to create a powerapps button that sits within my Power BI dashboard so when slicer information is filtered I can email specific email addresses.

 

I have attempted both options here.

1. [@PowerBIIntegration].Data - still produces an error

2. Launch("mailto:emailaddress") - launches Outlook with emailaddress as the recipient.

StalinPonnusamy
Super User
Super User

In my case, I'm binding PowerBIIntegration data to Gallary since getting as table

Gallery1 - Items property = PowerBIIntegration.Data

 

Onselect Property I'm getting the data like

 

Set(SelectedId, Gallery1.Selected.Email_Address)

 

StalinPonnusamy
Super User
Super User

Hi @germskiller2 

 

As I mentioned PowerBIIntegration.Data is a table, so we need to get one item. We can use First

 

First([@PowerBIIntegration].Data).FieldName

 

 

I tested and works fine.

 

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (2,412)