Streamline Excel: Power Automate Tricks You Need to Know!

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter In case you need to adjust the timestamp for your time zone for the recording of working hours - Update the FormatDateTime expression to this: formatDateTime(converttimezone(triggerOutputs()['headers']['x-ms-user-timestamp'],'UTC','Central Europe Standard Time'),'hh:mm tt') - Replace 'Central Europe Standard Time' with the text for your time zone here: docs.microsoft.com/en-us/previous-versions/windows/embedded/gg154758(v=winembedded.80)

[@lisaeppel4743]

Worked great. Thank you!

[@SaddamKhan-jd2sj]

Just tried this. Thanks

[@mik9221]

You are simply the best. Wanted to come ask this question only to see my response already pinned.

[@geraldbauer5702]

Nobody beats you, Leila! Not by content, not by charme and certainly no one even close with both... My company has been using many of your ideas directly or as great inspirations for the last couple of years and its getting better and better... Thanks a lot!

[@LeilaGharani]

Oh wow! Thank you, Gerald!

[@GavinConnor-ih7gd]

Hi Leila - thank you very much for this video. I’m brand new to Power Automat and very keen to learn more. Please continue with these videos and anything to help people understand / learn the expressions.

[@IvanCortinas_ES]

I have tested the tool to send bulk mails and to send emails with dynamic content (mailto, body...) . It is highly recommended. Thank you for the example with an "expression" section. That's very powerful Leila! A very professional tutorial!

[@LeilaGharani]

Fantastic!

[@The7Immortals]

Could you please do a series of Power Automate Desktop videos. Thanks a lot!

[@LeilaGharani]

Sure. Will do. Great thing is Power Automate Desktop doesn't need premium access anymore so more people can use it :)

[@igortorrealba]

Also I recommend you Jon Levesque, Microsoft guy with a number of Power Automate videos for inspiration and learning

[@danjarupath]

+1

[@InsideMyWall]

Can we make a workflow by attaching a document and get it signed by my approver with a digital signature and export the signed document to pdf after final approval??

[@SaddamKhan-jd2sj]

@@InsideMyWall yes

[@woutboog6949]

I really like everything you do and show Leila, with so much joy, profesionallity and ease. You are one of a kind !

[@LeilaGharani]

Thank you!

[@SavageGothamChess]

Leila is just the best. There is nothing she can't do. She's the best.

[@LeilaGharani]

Thank you! 😊

[@kaprisonept]

Thank you Leila for another great video! I'm using PowerAutomate myself in my daily work as an Accountant/Controller but not yet with many implementations due to lack of time to search and implement more complex flows. Currently I'm using two flows: 1. A simple flow that sends an email every Monday at 9h00 AM to the same Customer asking for an Open Item list so I can check if they have all invoices from last week booked or if they are missing anything 2. We receive 90% of all invoices from our vendors by email and we have a software for invoice recognition (Readsoft) that interprets all PDF's inside an email thrown at a certain Outlook Folder. The thing is, some vendors send us all invoices inside a ZIP file, so instead of unziping everything manually, I've created a more complex flow that unzips these files and then sends a new email for each PDF inside the ZIP so it can be processed in the right way I've been seeking some Connectors for PowerAutomate that can deal with PDF files (combine, split, convert) but none is free, so I guess a lot of other automations to the invoices we receive by email will have to wait. Another cool thing that it's still missing is the ability to automatically create a new Form (Microsoft Forms) based on a pool of questions in some Excel file. For now Power Automate can only work with Forms by collecting answers, not generating the actual Quiz. Maybe someone here has some knowledge/ideas on how to work around this...

[@NandagopalB]

Excellent automation, i am also an accountant, automating my process using power automate.

[@georgiabarros1697]

I am from Brazil and you are the best, besides inspiring me to learn more and more, not only Excel, but the other Office tools. Tks!

[@LeilaGharani]

Great to hear, Georgia!

[@josecarlosconejo5724]

It’s an awesome tool! Just started with it a few weeks ago and it is just amazing. I recommend to join the Power Automate community. There are lots of people willing to help you on your questions. For those with coding skills, JSON does not seems to be very hard (I am not an advanced coder so it will take some time for me 😊). And one cool thing is that you can add your flows to your widgets (at least in iOS..). You don’t even need to open the app!!

[@LeilaGharani]

Thanks for sharing, José!

[@luciozanarotto1974]

Hi Leila, I'm a new follower. I work as consultant in management control. Congratulations for your tecnical skills and for your english. For me is a good opportunity also to train my language. You are great!

[@vijayarjunwadkar]

Wow, this is so cool! Power Automate is going to open so many possibilities and with Leila we are going to conquer it easily! Thank you! 👍

[@shadrackawunyo7786]

That's a lot consume. Productivity apps just keep getting better and requires a lot of effort to keep up. Thanks for being there for us Leila

[@CeliaAlvesSolveExcel]

There's a whole new automation world waiting to be explored.

[@shadrackawunyo7786]

Celia I agree. And it requires a lot of effort to keep up. It just keeps getting better. A huge sea of knowledge out there

[@jamesa6720]

Just got this setup for my business. Absolutely brilliant time saver, thank you

[@igortorrealba]

You explain things so pleasantly. Thank you for that

[@santoshpv321]

Sooooo easy to understand with all your videos...Thx a lot.

[@balajis495]

Very happy to say that Leila is my inspiration

[@TheBlindBoy1990]

Thank you so much for your video's. I recently started to use Power Automate after your first video. I have flows to automatically make received emails into tasks and also ones which run daily to take information from an excel table and email it to an external user.

[@kuuuyajim]

I'm not able to use some of the things I learned from your channel because it's either my work doesn't demand it or simply not applicable, but I'll keep on watching anyway. 😅 Thank you Leila for all your videos. 😘

[@LeilaGharani]

Thank you for your support, Jimmy!

[@EricHartwigExcelConsulting]

This is amazing! Thank you so much for sharing this! I can not wait to see more and what else Power Automate can do!

[@LeilaGharani]

Glad you like it, Eric! More to come :)

[@nemirajgathani]

I’m in love with excel coz of u!!! Thank u...

[@LeilaGharani]

You're welcome 😊

[@jorgelara3116]

Thanks ! That respond my question I did In your previous video!! Maybe just causality or you are the faster teacher in you tube jeje thanks a lot

[@GinoNigro]

Amazing! I am just jumping into PowerAutomate and this is very helpful! Thank you so much

[@LeilaGharani]

You're very welcome, Gino!

[@ChandooD]

This is great Leila... I am going to play with Power Automate now :)

[@LeilaGharani]

Have fun :)

[@andrewmoss6449]

Wow! Power Automate looks really useful.

[@Han-dle598]

This is pretty awesome. I've been into automating things for a long time but only learned about Power Automate in the last few days from your videos. For a few years I've had "learn IFTTT" on my to do list but never got around to it. This (Power Automate) seems better and cleaner. I work with PDF files the most so I'll have to look Into what Power Automate can do with them.

[@lopher70]

I was wondering for what I would use power automate, now, im clear, thanks!!

[@LeilaGharani]

Glad it helps. I'll have more examples in the coming weeks.

[@DougHExcel]

Great examples! Using IFTTT, and can't wait for MSFT to add more to this

[@LeilaGharani]

Glad you like it!

[@wayneedmondson1065]

Thanks Leila. Power Automate looks interesting. Thanks for sharing :)) Thumbs up!!

[@LeilaGharani]

It really is! And much more to learn :)

[@BuddhaAfterDark]

it is interesting how you make the actual errors in Power Automate sound so simple to fix :D

[@Yatish1307]

Thanks , you always upload videos i need to know more for my work👍🏻

[@17aig]

As usual another great tutorial thank you so much

[@LeilaGharani]

Thank you! Cheers!

[@anferben]

Great news about Power Automate and of course I came to see what Leila has about the tool... et voila!! Thanks!!

[@jobie3015]

I'd love to see a power automate video about filtering a Forms Table to the last week of entries and emailing it as a PDF.

[@johnd4717]

Perfect replacement for Zapier I guess, and ofcourse we wanna see you more often Leila ;-)

[@armandovillalba242]

Omggggg 😅😅😅😅 looks soooo easy!!! 👏🏻👏🏻👏🏻👏🏻

[@evedgard]

How do I change the timezone of the time stamp? There is an expression to convert time zones, but I don't know how to nest (if possible) with the formatdatetime expression.

[@shantanupaul4801]

That was really awesome... explained in a very lucid manner.Can we have some more videos with examples where we can also learn to integrate power automate with power BI... Thank you once again for the tutorial...🙂

[@ronspi]

Thank you very much, Leila, for another great video. I haven't tried this feature of automating the post to LinkedIn. Still, I was wondering if I could create a table, like the one you created, with a URL and a text column, but instead of activating Flow every time I want to post, I'll time it via date and time or better yet, every Tuesday at 8:00 in the morning, for example. This way, I will continue adding rows to the same table, but Flow will automatically push the next row every week.

[@danielholanda7673]

Amazing content. Thanks Leila!

[@LeilaGharani]

My pleasure, Daniel!

[@mostafa4321]

Thank you Leila can you do more lectures about power automate to explore other scenarios.

[@LeilaGharani]

Sure. More to come :)

[@enocharthur1955]

Leila you're simply amazing. Thanks for this but I think some of us who do more data analysis would like to know who Ms Power Automate can help us automate data collections or analysis in anyway. Thanks.

[@LeilaGharani]

You're most welcome 😊

[@adityapatnaik6079]

SHE IS THE BEST !

[@maysupan7]

Leila your tutorials are very useful and helping alot our day to day task. If there anyway to send email with power automate whenever excel data is modified or update with the modified data?

[@NaviMumbikerPrakash]

First to comment 🙈🤘. Thankyou so much your videos have thought me alot wrt all the ms softwares

[@RPAChampion]

Great video made for everybody , all kinds of skills well done

[@techdelasabana]

I use Power Automate and Excel everyday. I try to Automate all that repeats, seeking accuracy, consistency, responsiveness and productivity. For example, my potential students answer a quiz with 15 questions. The answers are recorded in excel, an analysis of the results and a set of recommendations are sent within seconds via email, all entirely automated. Another use. I track payment dates, if it is close sends a heads up, if it is outdated sends a reminder and after x days, blocks access to O365 account. Another one is lectures completed by every student with date and time. And so on. I use PA + Excel in everything. I have so many interrelated tables that I'm afraid of the limits of Excel. That is my question for you. What limits excel? I haven't experienced limitations so far, with 10 or 20 tables for one single automaton or thousands of rows in a single Excel file with multiple tables and tens (40-50) PA flows hitting the same file. Where is the firewall? Thank you very much for your videos. I have learned so much. Salute from Colombia.

[@LeilaGharani]

Thank you so much for sharing these examples and use cases. Very inspiring! I haven't tested the limitations yet. If I find out more, I'll post about it.

[@ragavakrishna1617]

Nice update!.. please do a series of power automated

[@franzstreule333]

Very useful! But with the time recording, I have a problem with standard- / wintertime. :-( I would guess, since the records are one hour earlier, then they should. how can i handle this problem in power automate?

[@LeilaGharani]

Try this - for the time formatting add a time zone conversion: formatDateTime(converttimezone(triggerOutputs()['headers']['x-ms-user-timestamp'],'UTC','Central Europe Standard Time'),'hh:mm tt') - Replace 'Central Europe Standard Time' with the text for your time zone here: docs.microsoft.com/en-us/previous-versions/windows/embedded/gg154758(v=winembedded.80)

[@franzstreule333]

@@LeilaGharani the conversion worked just fine, thanks

[@RahulJauhari]

Thanks for useful video 🙏🏼🙏🏼

[@rossjohnson1199]

Hi, love your tutorials. Is there any way I can print out your tutorial as I get lost going back and forth on youtube trying to remember what to do?

[@chrism9037]

That was great Leila!

[@LeilaGharani]

Thanks Chris 😊

[@eniddeltacross4410]

Thank's Leila!!! Power automate can be used to track my productivity. How about if we want to add a free text column for "Activity" so we would know what particular activity we are working on?

[@ricardowong1813]

Thanks Leila 💪

[@lahotipushkar]

Thank You so much. It is very useful. Only I need to change time zone format. Can you please help me with the same?

[@mif1965]

Maybe this question has been answered before: can the workflow append records to an excel macro based file (.xslm)? the dropdown does not show those file

[@PemboDave]

Great ideas thanks for sharing

[@vida1719]

Great series

[@jamesa6720]

Incredible thank you

[@ingewll]

I am in Thailand. Can you plz explain why I get a timestamp 15:03 when the real time here is 22:50

[@LeilaGharani]

Please see pinned comment above.

[@darrylbaker5271]

Very limited use for users without access to OneDrive for Business. How to get a list of files in OneDrive directory and sub directories is not possible.

[@johngoumas6675]

thank you for the videos with power automate, is it possible to have a video with power automate and file server for instance to save email attachments to a folder and create a list in excel with the filenames and date of creation?

[@denisesakai8205]

Leila, I love your video, they are so helpful! ! I replicated the Working Hours, my time is working properly but my end date advances to the next day, My start date works properly. If I start on March 20th at 7:45 am and end March 20th at 4:pm my end date and time is March 21st at 4:00 pm. I am using the app on my mobile phone for my start and end time. How do I fix this?

[@kuldipsinhchavda7259]

Hey leila, You are amazing! Thanks for the amazing learning contect it's always informative. Please could you help me to break this out. what if i need to add More button like Pause/Resume button (Start, Pause/Resume and End) , I want that flow calculate my working hours only. Not the break time so whenever i go for break i have button to pause my hours and resume when i'm back. also 1 more column where showing total hours. (Like i worked for 5hrs then it shows 5hrs) Thank you : )

[@szisziszilvi]

again, wonderful! :) now I was wondering if there is a way to add a "project name" column to the table, so time can be assigned to a specific project. In this case the list of the currently active projects should be selected from another table from the same workbook. As a dropdown (like data validation) or simply listed. Is this possible?

[@valerieevans4417]

I really enjoy your tutorials and find them very useful but maybe I'm missing something here... Regarding the LinkedIn post flow, how is this more efficient than just sharing a post directly? Maybe I'm missing something super obvious, but social media posts aren't really actions planned with a lot of lead time. How is this better than just using LinkedIn scheduled posts?

[@FutureCommentary1]

The example is very specific indeed. I used to manage several social media accounts professionally. I'd create the whole communication plan, then topics, etc. Schedule blog articles to be written, and possibly schedule social media posts. So if you have one social media account yes use the in app scheduled. I can see this coming in handy of you have several social media accounts. But then again I used some other free tools for that. I think this is just to get you thinking about the possibilities.

[@rosesmary]

I like example number 1. However, it is still not fully automate as nobody will remember to push the button everyday and at least twice a day. I wonder if there is a way to record the time I log in/log out of my PC automatically?

[@craigbrown3419]

Good evening Leila, thank you for the videos, I am loving learning the power within Excel and Power Automate. Do you have to have the Power Automate mobile app to collect information to drop into Excel, I'm trying to collect vehicle use data from drivers who may not have the app on their devices. Thanks in advance for your advice

[@geshoow1288]

Leila, do you know if there's any way to refresh Excel workbooks using Power Automate? I have Power Automate set up to automatically download Excel workbooks and then Power Query / Power Pivot to create a dashboard from those workbooks. The last step in the automation chain is setting up an automatic daily refresh after the Power Automate download, but I haven't found a way to automate the workbook refresh. Currently after the Power Automate download is done, I still have to manually open the dashboard to refresh, save, and then close.

[@ExcelWithChris]

I want to do something very simple. I need to copy the same 3 files once a day from my laptop to the same 13 Sharepoint Document folders (there are 13 different document folders for all our regions) What I currently have to do is open each of the 13 Document folders in Sharepoint, then upload the 3 files each on it's own. This surely can be automated?

[@LeilaGharani]

I haven't tried from local to sharepoint but I think this should be possible with PA for Desktop using a schedule as trigger. When I get a chance to try it out I'll let you know. In the meanwhile if you succeed, let me know.

[@ExcelWithChris]

@@LeilaGharani I downloaded the Desktop one. Could not find anything, tried Desktop Recording, but not working. Maybe you can find something. Thanks for replying.

[@veronicaterra6256]

Hi Leila, great video!!! Thank you so much ❤❤❤ I was wondering if you can help me with one flow that i'm stuck? So in my Company we use Forms for people to sign up in our events and I've already create a flow so they receive one e-mail after submit the info, saying that they were signed up to the event. But now I want to: 1) schedule one e-mail for 1h before the event to the participants and 2) create a certificate from a word template (we use mailing lists now). If we could create individual pdfs and send these pdfs automatically to the person would be great but not necessary. Thank you for your help!!!

[@Rainquiller]

Thanks for this! Quick question, how do I integrate this flow on recording different tasks? Thanks in advance!

[@kavirshop]

Great video, very informative

[@t2p5g4]

You pronounce Z the correct way!

[@miransh]

Your explanation is awesome, really like the video and ideas,....thanks so much! Can you please make videos on how to do that using Google as many people like me don't have 365. I find Microsoft products very intrusive when it comes to dealing with privacy, Thanks Leila

[@ricos1497]

I don't think Google is the answer if you find Microsoft intrusive!

[@jamietan8002]

Can u do a video for a chain of stakeholders approval process with handphone app approval. Once a approved goes to b and after b approve goes to c. Finally at c, can straight send as email to d for further action each approval process requires to attach file (one pdf and the other word)

[@malubianchi9926]

Amazing Leila! What if I track the Teams Status instead of using the app manually? Then I would know when I ended my shift automatically. Is it possible?

[@lisaeppel4743]

So cool! Question- I followed along with you exactly but when I initiated it from my phone the time stamp was 5 hours ahead and when I initiated from my computer it was 18 hours behind my current time. Any idea what setting I need to adjust on my computer?

[@jasonwoods5326]

5 hours ahead makes sense if you are in North America, since the stamp is UTC. This is corrected by modifying the format time minus 5 hours. The 18 hours ahead is a mystery.

[@ddp2049]

Great video. Question when I run my automate for the time the time stamp is 3hrs ahead of my time. How can I fix that issue l?

[@gautamsharma-pn9qy]

Could you please make a video on how to copy & paste selected rows and columns only to a new excel sheet ysing power automate.. i need to learn this ..

[@EmilPaje]

Hi is it possible to automate the “refresh connection in excel”?

[@sharusg]

Hello @leila... Thank you for this video.. I faced one issue while testing this flow. The time is showing wrong in the excel. Now its 12.09 PM here in India, but in Excel its showing 6.40 AM. Can you please help me to solve this.

[@RIPUZI]

Can you do this with a personal office 365 subscription?

[@RIPUZI]

I've managed to get it to work. Yay!

[@antoniobrito4358]

Thanks you for the vídeo , Leila! Do you have a vidro, with tips to use slicers with pivot tablets that have diferentes data sources? Thanks you

[@sherifgad3322]

You are super 👌 ❤

[@LeilaGharani]

Thank you so much 😀

[@Slaphs7021]

Leila, Can you show how Use excel to automate expire date and notify in outlook the expired date

[@fortznite8150]

so you want an email sent to outlook every time you hit an expiration date?

[@damaristorres5802]

I watched a LOT of videos and I can't find the answer to my question. I have one Worksheet with multiple identical tabs. I named the tabs T1 to T50. Then I have a master tab at the end. I want to do a formula so it copys the same cell in different tabs. Example ='T1'!D14 then ="T2'!D14 but any time I drag down, it will increase to D15 and so forth, or I can copy the exact same formula. Is there an easy way to do this?

[@SaddamKhan-jd2sj]

I want to update excel rows upon receiving the new excel by email. How do i do this in power automate?

[@Krzysztof_Topolewski]

Hello, just quick question, I'm new with PA so, please,correct me if I'm wrong... I wanted to work on Power Automate Desktop but I saw that there is some limitation... is it possible that PAD is for Flow on your computer but PA web version is for thing related to teams, Sharepoint etc?

[@danjarupath]

I love your vdo I love you ❤️❤️❤️😗

[@dhootsachin]

I have encountered error says The power flow's logic app flow template was invalid. The template actions 'Apply_to_each_10, Apply_to_each_11' are nested at level '9' which exceeds the maximum nesting limit of '8'. Is there a way to exceed maximum nesting limit of 8??? I have 5 layers of approvals. But when I saved my flow with 4 levels, I encountered this error. i am using Microsoft form and trying to build approval of 5 level. how i can do this. Thanks in advance

[@JoeyCbr]

One thing to note, Timestamp in PA doesn't adjust to accommodate daylight saving time

[@rayhanhossain7999]

We expect a full course on power automate specially covered business and finance task

[@yulinliu850]

So cool 👍

[@choyoy4658]

how do you prevent data duplication in excel using excel and power automate?

[@andongnee]

Can we do a sales order upload using excel to Business Central via power automate?

[@amrithrs6636]

Mam... please can you let us know how from power automate a application is launched and provide access to other users

[@aryansworld8163]

Hello Ma'am, Can you please help me with formula of calculating SLA by excluding non working hrs only.

[@bairikrishna0808]

Hi Leila, thanks for the video. I have a use case that I need create an html table for each row in the excel sheet, a separate table for each row and send an email to the owner. Could you please help?