Email Excel Reports with Power Automate & Office Scrips - One Click Automation

Hello, hello @Chandoo! Hope you're doing well! In the step where we create the send button, does it no longer work? I have the error:
{
"error": {
"code": "DirectApiAuthorizationRequired",
"message": "The OAuth authorization scheme is required. Please add authentication scheme and try again."
}
}

Nice

Hi Chandoo - to run the flow for other users, do you have to share the power automate flow also? And will it send the outlook email using the author's account or the other user's outlook?

Probably the Power Automate the Desktop version may be easy

userful and helpful video thank you @Chandoo

hi Chandoo, i have excel version 2302, build 16130 and i have automate tab and scripts, but i don't have the record actions button. which version are you using? im on desktop excel

Hi sir, do's can we automate Data cleansing process in Power Automate?

Thank you for sharing your knowledge.

Hi chandoo, this is sandeep here, I have a task to automate reports in power bi through azure devops, how can I automate this so that charts gets automatically updated every month. I have the data in excel csv file which contains different types of invoices, can you please respond to my comment.

It's an excellent video with a clear explanation!!!! I have a question, Is it possible to execute all scripts with the same button? Thanks for your answer.

This is amazing but I need to get Record action button and after that I would have to use that only.

How to automate this
Is it possible ??
created a mail merge connected to an excel sheet to print labels. However, a single label is reproduced for each record. I would like each label to be repeated X number of times indicated in column G of the excel file

so to explain myself better, in the word file I sent you, 15 labels of the first type will appear, then 10 of the second, 0 of the third, etc..

in the word file I sent you a label is shown for each line of the excel sheet, one for the code A30452LRD-16, one for A30452LRD-28 etc.., instead I would like 15 labels to be shown for the code A30452LRD-16, 10 for code A30452LRD-28, the number must vary based on what I reported in column G. If I change the numbers in the column, the number of labels also change.

awesome boss

Hey Chandoo nice video but it would be better if you have used power bi in place of excel.

How significant is Power Automate for web scraping?? Is it a substitute for programming languages like python to scrape data??

Make a video on Microsoft copilot.
It will replace data analysts?

available for office 365?

Sir Maths concept for data analyst ?
Then power BI or tableau ?

Skill

Whew over my head

Can you show me a way to move rows from one sheet to a couple sheets based on a cells value in office scripts? This was supposed to be a simple task. I have a sharepoint web-based excel workbook and VBA's are disabled from excel online. I'm still new to coding and filtering, so I was disappointed that VBA's don't function on office 365. I cannot get the admin to enable them

I learn VBA from online but not in use. Also, watch this video but it seems too complicated.

Love your Video examples. We have a CLUB attendance sheet which is used dynamically when the members arrive on the day. When completed I have a 'Menu' sheet which has an ''email to" button. My system uses VBA. This button initially generates a copy of the attendance sheet, makes a PDF, saves that to a 'historic information' folder, then attaches to a 'New email, window. There we add the recipient/s and send. We could automate the recipients and send auto as well but they sometimes change. Don't want to send a dynamic sheet, just a static sheet that can be discarded. Do this also with the Club Membership, Committee and historical attendance reconciliation. Love automation and really appreciate the tips I get from yourself and some other presenters.

Thank you so much for your tutorials Chandoo!👌

Please tell me how to merge two cells in the same row in power query

Iam a beginner excel user and i see your videos is very good and i want to learn from you to be advanced user but you have too many videos so i dont know from where i have to start to build my excel knowlage to be efficient as much as i can
If you read my commemt pls help me and guide me for the best option, and thank you

Thanks and great work

I haven't use this anna.. somewhat confusing for me as I am new to Office Script and Power Automate.. Nice informative vid though... Please do much more vids on PA so that we all can learn from new things as you always do..

Happy Ugadi Anna

Hi chandu, I need your Help. Iam doing a manual task over 6 months. I need to make it Automate. I have an excel files which has Queries connection to different Excel files. Every day I need to open the excel files and click on refresh all and Refresh the power Bi data set manually. Please tell a way to RefreahAll the queries in Excel File without Opening the File. The File is Located in SharePoint folder. Please Help me with this Buddy. Thank You in Advance.

I've used VBA to send an email and copy parts of the cells, charts and etc. as an image in the body. I use a range of cells for the "mailto:" and a cell for the subject and body text before inserting the image. I think I prefer that way over what you just went through. I'm not sure that I'd like to use a "link" created to do the job, along with all of the coding which as you said is quite intense. I wouldn't know if the link would be good forever or not, though I'm sure it would. I think I'd prefer everything to run from my PC.

Very interesting though. Thanks.

Didn't understand much but its awesome

Hey chandoo sir could you please help me with my career I am a BCom graduate and I want to learn data analytics but the problem is that with my skill I don't know how to use Excel I want to start using Excel from basic could you please suggest me anything

Hi chandoo will this going to work on excel 2016

Agreed, VBA works much better, but this ones interesting too. What if I want to simply copy the cell range instead of making it to an image does it make the process less complex?

Please please please create more videos on Power automate 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

I tried to use office scripts but it is a bit complicated. I want other user to run flow which is using my script but it fails. I shared, saved on sp folder still some issue. Hope will be familiar with it soon

I faced similar problem. I need to send aroud 20 reports every week. Mail should have some visuals and an excel file as attachment to email. The problematic part was, in mail body I don't want to send visuals as image. I want to send it as html so that recipients can copy data if required.
My solution is using Power Automate and paginated reports from power BI.
It is working as expected but there is also a problem that u can only trigger 1 report at a time and have to wait for 5 minutes to trigger another report.
But my mail require 2 reports one on mail body another as attachment
I solved it using 2 connection
1 that usage to create attachment and 2nd for body of mail report
Power Automate is changing the way of reporting. It is a wonderful tool

Does the office script kill VBA coding....?

Is power automate a free tool? What is the difference between power automate and power automate destop? Kindly answer

Nice T-shirt ! 👍 and thanks for the useful video as always 😊

Hi Chandoo! Is it possible for you to do some videos on using zoho sheets?

Very cool stuff, thanks Chandoo!

This was splendid...Bro pls do more videos on Power Automate

Definitely agree that the steps to doing this is not at all intuitive compared to VBA and the scripting language again is difficult to read for a Joe Average coder like me. That said our organisation is blocking macros soon for good reason as a policy in 365 so it will be the only solution that wider groups can adopt. Microsoft could do so much better with the scripting language though if they want it to be as ubiquitous as VBA.

Hi Chandoo, i cannot find demo file... Possible to get link?

Interesting video, Chandoo! I'm curious if the solution could be created in Power Automate only. Maybe a consult / collab with Anders Jensen?

Hi Sir How can I Find data For data Analysis with task todo For practices pls

Thanks a lot Chandoo. This is awsome

Much awaited video..waiting for a series. Thanks Chandoo!