cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Functionality to Concatenate filtered list of emails and load into Outlook?

Hey folks!

 

I have a unique situation (at least I think it's unique) that I'd love some insight on. Basically, when I was building dashboards in Excel, I figured out a way to use Concatenate and VBA to compile a list of emails (separated by ; ) and load the concatenated list into Outlook's BCC field through a VBA button.

 

My question is simply whether or not there's anything doable in PowerBI along the same lines? I'm still very new to PBI, and I know the two programs are totally different animals, but I've seen just enough overlap in a few areas to make me think this may be possible. 

 

For context (in case anyone has alternative ideas that may be helpful), I'm just trying to help Managers within my company send emails to employees who need to take action based on report data (compliance trainings, etc). The users that need to take action more often than not won't have access to the dashboards, and I'd like to save the Managers the hassle of having to type out email addresses in instances where the user list may be in the multiple dozens.

 

If it's not possible that's ok, just hoping someone may know of a viable solution. 

 

Thanks to all of you for the great support this community offers 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Functionality to Concatenate filtered list of emails and load into Outlook?

HI @Anonymous ,

AFAIK, current power bi does not support to pass data view slicer/filter selections to query tables side.
I'd like to suggest you try to use power query to invoke outlook API to send emails based on concatenated query table field values.

Outlook Mail REST API reference (version 2.0) 

Pull data from a REST API Authentication 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Anonymous
Not applicable

Re: Functionality to Concatenate filtered list of emails and load into Outlook?

Bumping this only because it never got posted properly.

Highlighted
Super User IV
Super User IV

Re: Functionality to Concatenate filtered list of emails and load into Outlook?

@Anonymous you can surely create (semi color) ; seperated concatenated list if that is what you are asking for, but you cannot send Power BI to send emails, not sure if this helps.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Community Support
Community Support

Re: Functionality to Concatenate filtered list of emails and load into Outlook?

HI @Anonymous ,

AFAIK, current power bi does not support to pass data view slicer/filter selections to query tables side.
I'd like to suggest you try to use power query to invoke outlook API to send emails based on concatenated query table field values.

Outlook Mail REST API reference (version 2.0) 

Pull data from a REST API Authentication 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors