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

[@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!

[@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

[@jenozenB]

Great video! Easy to follow and apply. Thanks 🙏

[@matiastaurizano299]

Many Thanks Buddy! Regards from Argentina!

[@SolutionsAbroad]

Thanks for watching, regards from the UK!

[@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?

[@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 👍

[@DraregGray83]

Bro you saved me. Nice tutorial!

[@SolutionsAbroad]

Glad I could help!

[@VikasSingh-bi4ot]

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

[@SolutionsAbroad]

Glad it was helpful!

[@charotarguy1]

Great... thats what I required. I followed your steps as in VDO ( easy explanation ) but I am getting repeat emails as per number of rows in the table,

[@charotarguy1]

Any help in this steps ... to avoid repeated emails

[@udayshankarnellore]

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

[@91221srikar]

Saved me! thanks a lot!

[@RaviKumar-gz9my]

Great Work. Simple.

[@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.

[@nivi5476]

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

[@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

[@markusoestreich8695]

You really make very great and educational videos!

[@SolutionsAbroad]

Thanks for the compliment and thanks for watching!

[@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.

[@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

[@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!

[@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...

[@damienfernando36]

Great work bro

[@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

[@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.

[@raudathulfathirah3800]

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

[@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 ?

[@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!!

[@poojamathapati7673]

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

[@moeshameheux8509]

Perfect 😊.....Thank you

[@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

[@abhijeetshetye3764]

Very useful video. Tysm.

[@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?

[@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?

[@Giraffe-j3h]

how can we schedule this flow to run every friday and send email without the button being clicked? Can we create a automated cloud flow instead of instant cloud flow

[@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.

[@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?

[@rakeshchaudhary1386]

Hi Fernan, Its nice video but i want to share the data by gmail and because some company are using gmail platform to share the report i want to share the report to each region and person with RLs where they can see the corrent date report on mail body including power BI report also is it possible ....

[@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.

[@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.

[@amitjain-kx7bm]

Thanks for the useful video

[@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

[@supreetkaur6268]

Can we schedule this flow?

[@Bartman2006]

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

[@91221srikar]

yes. for that, you need to make a copy of your table visual, and then change the table visual copy to 'Power Automate visual'. and then you can do you PA work on top of it. this will make sure all filters that gets applied on table visual will be applied on your PA visual as well.

[@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...

[@143arunkj]

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

[@decentmendreams]

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

[@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?

[@naveenkumarguniputi477]

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

[@Cappurnikus]

Any idea how to get the row count of the power bi dataset so that you can conditionally send 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

[@landoftechbuzz3189]

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

[@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

[@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...

[@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.

[@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.

[@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

[@Negi_From_Pauri]

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

[@dcraf14]

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

[@ShitalN-l9o]

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

[@ShitalN-l9o]

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

[@ShitalN-l9o]

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

[@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?

[@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?

[@cognosanalytics733]

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

[@junhuipak3195]

Does this require a powerbi premium licensing?

[@SolutionsAbroad]

Hi there, no it doesnt!

[@arvindchauhan5241]

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

[@vijaykumarbajjuri8220]

How to fix the flow a timing?

[@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!

[@retirementvideos8016]

How to send same table as excel attachment over email

[@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!

[@temesgennissrane7582]

Thank you

[@connordaly2882]

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

[@dezhenghuang6945]

Hey! Can it send as an excel instead?

[@dezhenghuang6945]

and possible for it to auto-send?

[@gayatrilshinde1560]

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

[@karthikDegati]

SAME ERROR IM FACING

[@monday2sundayentertainment90]

I need multiple output in single file

[@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?

[@saadnageeb4633]

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

[@Wzxxx]

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

[@taimoorrasheed561]

Can i take input as input as well?

[@remenence]

how to schedule send without a button?