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
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?
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,
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?
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!
@@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
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.
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!!
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.
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?
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!
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.
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.
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
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.
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.
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?
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...
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!
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
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...
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.
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
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.
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
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?
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.
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?
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.
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!
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?
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
Great video! Easy to follow and apply. Thanks 🙏
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?
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
Thanks a ton!
Many Thanks Buddy! Regards from Argentina!
Thanks for watching, regards from the UK!
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,
Any help in this steps ... to avoid repeated emails
Bro you saved me. Nice tutorial!
Glad I could help!
Saved me!
thanks a lot!
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?
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!
@@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
Great Work. Simple.
You really make very great and educational videos!
Thanks for the compliment and thanks for watching!
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.
This is nice...Can I trigger that flow automatically on some scheduled time? lets say after every refresh with default slicers?
Hi Vasudev, you can trigger it with a button, or a scheduled time, but I don't think you can trigger it with slicers
@@SolutionsAbroad how do you trigger it at a scheduled time? I don't mind if the slicing is not applied.
Hi,
Thanks for sharing this most valuable information on the easy way.
Glad it was helpful!
Amazing instructions! Thank you for sharing
You are so welcome!
@@SolutionsAbroad hey Thankyou for the solution but my data is not getting formatted to table format
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?
Hiya, have you tried changing the trigger to be an scheduled flow instead?
@@SolutionsAbroad Yes but I couldn't, there wasn't an option to make it a scheduled flow
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!!
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.
hi you got solution about formatting of table ?
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 👍
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?
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!
Great work bro
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.
Can we do the set up for power bi reports or is it only for power bi dashboards
Hi there, the demo uses Power BI report, so it should work!
@@SolutionsAbroad actually sir requirement is at any how we should not create any dashboard.... Only report should work...
Perfect 😊.....Thank you
It's very useful to me.. please upload that how to send report via email using power automate in power bi desktop
Very useful video. Tysm.
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.
Hi there, not sure Power Automate is that sophisticated yet, if I find the solution I will let you know!
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.
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
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.
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!
Python
Great Video! Is it possible to achieve the same task using automated Flow ?
Can we schedule this flow?
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.
Thanks for the useful video
Hi this is great. Does this still work if you have filters applied to the table?
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.
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?
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?
Does this require a powerbi premium licensing?
Hi there, no it doesnt!
Can we do this on the power BI desktop. I do not have a power BI service account
If we apply conditional formatting in the table like one column will be in green and send the same to email. Is it possible?
Hi,
Can you assist how to send this tabular report to multiple unique users? appreciate your help.
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...
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!
@@SolutionsAbroad thanks Fernan. It's something that should be there given that you can create a formatted HTML table and a csv...
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
Is there a way to send the table in an email attachment thru Power Automate.
@ 4:17
Power BI Data is not available in my list of parameters, what would be the reason, please let me know
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...
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
Any idea how to get the row count of the power bi dataset so that you can conditionally send the email?
How can we apply borders for the Table data in the mail body?
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?
Thank you
Can you please show us how to read an excel and creating a table of those value and including that table in emails
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.
Hii ho do I send table visul from power bi to excel with colour coding
Hi there, not sure how to do that just yet, maybe its an idea for a new video!
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
Hello..How to add grand total to the table and how to sort the table .. please help on this..
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.
Hi. Is it possible to add created measure through this process. Or if any other flow is there then kindly share me the details.
I tried with this steps but it's not working for my measures
Error details - The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.
Can we automate this, I mean schedule it without clicking on button? Thanks
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
How to send same table as excel attachment over email
what if i want the table into a xlsx and pdf format?
How to fix the flow a timing?
i am very confused with triggers and actions there are so many how to understand them?
Hi bro. Great info . I need some help with a small project regarding this topic. How can I reach you ?
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?
Hey! Can it send as an excel instead?
and possible for it to auto-send?
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.
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?
I need multiple output in single file
I want to know how can send excel sheet as email attachment
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.
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!
Am getting manual of type request did not match it's schema defination
SAME ERROR IM FACING
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?
i know that is with the union sentence, but not sure how to apply it. Did you find a solution for this?
Does anyone have any idea on how I would do this and make multiple independent HTML tables on one email?
Everything is fine ,but why data is not inside a shaped Table like grid OR how to do that.
I do not have Power Bi Data in Dynamic content? Why?
Can i take input as input as well?
how to schedule send without a button?