How to send a TABLE via EMAIL using Power Automate // Beginners Guide to Power BI in 2021

Get Demo Files here
ko-fi.com/s/6b7ebac252
In this video were going to go through how you can use Power Automate to easily send Power BI tables via Email
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - [e-mail]
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of KZbin.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

[@sudhansumishra2895]

Ohhh boy...this is Amazing man. So nice of you to do these videos and helping all of us. Keep up the good work.loads of love

[@SolutionsAbroad]

Thanks a ton!

[@RaviKumar-gz9my]

Great Work. Simple.

[@purbashabhanja8172]

Big Big Big Thanks to you 😍that is what I was looking for you saved me, even chat gpt failed to provide the solution.... Thanks for your support 👍

[@markusoestreich8695]

You really make very great and educational videos!

[@SolutionsAbroad]

Thanks for the compliment and thanks for watching!

[@avinashmali3693]

Hi, I am getting an error while running flow at SELECT level "The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array. Please give some solution

[@matiastaurizano299]

Many Thanks Buddy! Regards from Argentina!

[@SolutionsAbroad]

Thanks for watching, regards from the UK!

[@damienfernando36]

Great work bro

[@vrajeshbhavsar2748]

This was exactly what I was looking for and really useful, so thank you for this. However, I am receiving an email per line in the table created with, all with the same output. Do you know how I can deal with this issue of bombarding emails?

[@amitjain-kx7bm]

Thanks for the useful video

[@abhijeetshetye3764]

Very useful video. Tysm.

[@michellemi9074]

Amazing instructions! Thank you for sharing

[@SolutionsAbroad]

You are so welcome!

[@akhileshthusu207]

@@SolutionsAbroad hey Thankyou for the solution but my data is not getting formatted to table format

[@Bartman2006]

Hi this is great. Does this still work if you have filters applied to the table?

[@DraregGray83]

Bro you saved me. Nice tutorial!

[@SolutionsAbroad]

Glad I could help!

[@kartikwat]

Very useful video. Curious to know if we can upload and append data from PowerBI table to an existing SharePoint list using power Automate...? If yes, that would be very useful to know how it's done.

[@VikasSingh-bi4ot]

Hi, Thanks for sharing this most valuable information on the easy way.

[@SolutionsAbroad]

Glad it was helpful!

[@moeshameheux8509]

Perfect 😊.....Thank you

[@temesgennissrane7582]

Thank you

[@mariamelendez3854]

Hi! I was wondering how you can display the total value(row) that is underneath the table in an email. It shows everything like you mentioned, but I would like to add this feature

[@tejaschandan8970]

Hi, thanks for the video. I just had a small issue. I am not able to export the table because it says there are too many rows.

[@divya7555]

Thanks for this 👍💯.. I have one more requirement along with this , I would need Grant total "total "also in the content of the mail body... Can you please help me...

[@nivi5476]

It's very useful to me.. please upload that how to send report via email using power automate in power bi desktop

[@lukedonovan3586]

Hey! Great job with the video. I ran into the same problem that you did as it pertains to the email summarizing the data. But when I go back into power automate, I do not have the ability to uncheck the "sum" option, does it matter that the columns are all quick measures in my table? Also, after creating the "Select" step, is there another way to export other than creating the HTML table?

[@poojamathapati7673]

Great Video! Is it possible to achieve the same task using automated Flow ?

[@saifali4107]

Really helpful. Can you do a video on exporting paginated reports as pdf/ppt and saving the file on a SharePoint folder using power automate.

[@Cappurnikus]

Any idea how to get the row count of the power bi dataset so that you can conditionally send the email?

[@raudathulfathirah3800]

Hi, Can you assist how to send this tabular report to multiple unique users? appreciate your help.

[@cookiet4513]

this is very useful learning, however, instead of an html embed in the email, how can I export the data as an excel file attachment in the email?

[@devyanianimalsjadhav8313]

Can you please show us how to read an excel and creating a table of those value and including that table in emails

[@nowfalriswan]

Hi can u guide me to perform below task I need to use VPA to retrieve item from a table in power bi and display result . Thanks in advance

[@maati5517]

Great, now the last thing is formatting the mail it self, how can we send the data in a table (like a real table with layers and borders) ? i was looking for this answer and i found your video, i like it so much --- but still looking for this answer.

[@RavinderKaur-px6ek]

hi you got solution about formatting of table ?

[@shouviksarkar5130]

Can we also add a trigger for data to be refreshed automatically at a scheduled time and then send an email. If you have a video for that plz share the link over here. As here we have a click that the trigger right is it possible automatically will refresh and then trigger a mail. Thanks

[@kavanakundapur]

Can we do this on the power BI desktop. I do not have a power BI service account

[@amadorcamacho]

Hi, Thanks for sharing. I receive an email for each date on the report, insted of receive just one with a table of all dates what am i doing worng?

[@vasudevpatil2309]

This is nice...Can I trigger that flow automatically on some scheduled time? lets say after every refresh with default slicers?

[@SolutionsAbroad]

Hi Vasudev, you can trigger it with a button, or a scheduled time, but I don't think you can trigger it with slicers

[@cindyo6298]

@@SolutionsAbroad how do you trigger it at a scheduled time? I don't mind if the slicing is not applied.

[@rajuthumpala5436]

Thanks for the video, can you please suggest to me for below scenario, "I would like to send a table via email for multiple document owners" , here if I choose the document owner name for that particular person, those details of the table send to his email id. how can I achieve this?

[@SolutionsAbroad]

Hi Raju, it sounds like we need to create a loop within Power Automate, which I havent learned to do just yet, so I will get back to you when I find out!

[@bobbynaik5613]

If we apply conditional formatting in the table like one column will be in green and send the same to email. Is it possible?

[@bibinthomas9561]

Hi there, I am getting an error in the select step. When I choose Power BI data, it doesn't run and shows that "The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array." Do you have any idea, how to solve this?

[@aktharhussain6527]

how can I create a table from columns of a share point table? when user submits a power App,I want to send an email with table which has columns from the submitted item.

[@supreetkaur6268]

Can we schedule this flow?

[@LVenkat645]

Hi Fernan, I have question my client wants to export the report in excel, my report has 6 pages, all to gather they want to export in single excel of csv, is it possible , please let me know - thank you.

[@jamesmoran3573]

Nice video, my data set has multiple records for single user with same email address. I want to send email to him saying he has list of items pending, instead of sending multiple emails with the flow?

[@SolutionsAbroad]

Hi James, I'm not sure how this could work with Power Automate, I've not done it before, but sounds like an interesting challenge, 'll put it in my list!

[@monikasingh000]

@@SolutionsAbroad hi. Did you try above question? I also have same query but just little different. If data has less than 10 items then paste in mail body else add data in excel and send as attachment. We have like 50+ rows for pending incomplete

[@gleahdulay]

Hi, Question, I don't know how to attached a certain chart from powerbi to email. What i mean is, i want a certain chart in my email body and then automatically send it via email. Hope you can help

[@Pjvm550]

Thanks for the video! May I know if this is possible via excel instead of PowerBI. I'd like to send a group of items per specific email address. I'm only familiar sending per row instead of a group of rows.

[@SolutionsAbroad]

Hi Pearl, thanks for watching! I'm not too sure to be honest, I dont see a connector that can do this in Power Automate but maybe I'm wrong!

[@mengekyosyaringanKamui]

Python

[@taimoorrasheed561]

Can i take input as input as well?

[@landoftechbuzz3189]

Hello..How to add grand total to the table and how to sort the table .. please help on this..

[@deepususeel3157]

Great Video. I have one doubt, I am stuck on a problem. I have to run this flow automatically everyday. how do I do it , pls help needed?

[@SolutionsAbroad]

Hiya, have you tried changing the trigger to be an scheduled flow instead?

[@deepususeel3157]

@@SolutionsAbroad Yes but I couldn't, there wasn't an option to make it a scheduled flow

[@JoelNove]

Hi @@SolutionsAbroad can you show us what steps to select for “Recurrence” instead of “On Power Bi button clicked”? I’m stuck on what BI step to select after “Recurrence”. This would be for a scheduled email. Thanks!!

[@AndresLopez-ee5su]

Thanks much for this, question, can I make this conditional to send or not send based on values of the table? For example, I want to email a list items that have low inventory, however, I don't want to send if the table is empty (due to filter conditions) and would like to avoid having to send an empty table.

[@SolutionsAbroad]

Hi Andres, Power Automate supports if statements so you could potentially add an action below the "Create HTML" table to do if... when... but you might have to test out how it works since I've never done it before Sorry I couldn't help much!

[@143arunkj]

How can we apply borders for the Table data in the mail body?

[@adityaalok9122]

Got an error... The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.' Do you have a Solution?

[@cognosanalytics733]

Can we automate this, I mean schedule it without clicking on button? Thanks

[@naveenkumarguniputi477]

Is there a way to send the table in an email attachment thru Power Automate.

[@decentmendreams]

Hi bro. Great info . I need some help with a small project regarding this topic. How can I reach you ?

[@payeldas4146]

Can we do the set up for power bi reports or is it only for power bi dashboards

[@SolutionsAbroad]

Hi there, the demo uses Power BI report, so it should work!

[@payeldas4146]

@@SolutionsAbroad actually sir requirement is at any how we should not create any dashboard.... Only report should work...

[@connordaly2882]

Does anyone have any idea on how I would do this and make multiple independent HTML tables on one email?

[@udayshankarnellore]

@ 4:17 Power BI Data is not available in my list of parameters, what would be the reason, please let me know

[@dcraf14]

what if i want the table into a xlsx and pdf format?

[@HemanthKumar-lb4xt]

Hi Am getting the below error, Pls help to fix it... ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is of type 'Null'. The result must be a valid array.

[@maheshshandilya8215]

How do I send specific rows to specific emails? Like if one of the columns has email addresses of many people, how can I send the data corresponding to that row to the corresponding email addresses? Pls help thanks.

[@SolutionsAbroad]

Hi there, not sure Power Automate is that sophisticated yet, if I find the solution I will let you know!

[@sumitsehgal8805]

Hi Mahesh - did you find the solution to your problem? I have a similar requirement where I want to send emails to customers who have their payments pending. I have the email address as one of the fields in the table. I want to automate it completely, but even if it is through a click of a button, I am okay with that for now.

[@tonykuiper9127]

Hi Fernan... I have followed a similar process but instead collect the data using csv and emailing that. I cannot find a method however to export as a formatted excel sheet or file and so the csv data is unformatted and looks poor. Do you have a suggestion for this? I could export to onedrive, but that then creates another series of operations to send it from there... Ideally formatting in the flow is needed. I have tried using the power automate parameter options, however csv still doesn't utilise % and $ etc...

[@SolutionsAbroad]

Hey Tony, unfortunately I've not found a solution that can do that yet, at least not with just Power Automate, but if I find something I'll let you know!

[@tonykuiper9127]

@@SolutionsAbroad thanks Fernan. It's something that should be there given that you can create a formatted HTML table and a csv...

[@Negi_From_Pauri]

i am very confused with triggers and actions there are so many how to understand them?

[@arvindchauhan5241]

I want to know how can send excel sheet as email attachment

[@junhuipak3195]

Does this require a powerbi premium licensing?

[@SolutionsAbroad]

Hi there, no it doesnt!

[@user-xz7ym9ou5q]

Hi. Is it possible to add created measure through this process. Or if any other flow is there then kindly share me the details.

[@user-xz7ym9ou5q]

I tried with this steps but it's not working for my measures

[@user-xz7ym9ou5q]

Error details - The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.

[@MRR838]

Hii ho do I send table visul from power bi to excel with colour coding

[@SolutionsAbroad]

Hi there, not sure how to do that just yet, maybe its an idea for a new video!

[@retirementvideos8016]

How to send same table as excel attachment over email

[@vijaykumarbajjuri8220]

How to fix the flow a timing?

[@alialsharqi9920]

It sends the Email for each row data instead of 1 full email containing all the data in the table. for example by having 4 rows of data containing an email adres, it will send 4 emails instead of 1 email. Is there a solution to only send 1 email containing all the data inside the tabel for the same person?

[@franciscosappia8935]

i know that is with the union sentence, but not sure how to apply it. Did you find a solution for this?

[@Wzxxx]

I do not have Power Bi Data in Dynamic content? Why?

[@remenence]

how to schedule send without a button?

[@dezhenghuang6945]

Hey! Can it send as an excel instead?

[@dezhenghuang6945]

and possible for it to auto-send?

[@saadnageeb4633]

Everything is fine ,but why data is not inside a shaped Table like grid OR how to do that.

[@monday2sundayentertainment90]

I need multiple output in single file

[@gayatrilshinde1560]

Am getting manual of type request did not match it's schema defination

[@karthikDegati]

SAME ERROR IM FACING