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
3 жыл бұрын
Worked great. Thank you!
@SaddamKhan-jd2sj
3 жыл бұрын
Just tried this. Thanks
@mik9221
2 жыл бұрын
You are simply the best. Wanted to come ask this question only to see my response already pinned.
@The7Immortals
3 жыл бұрын
Could you please do a series of Power Automate Desktop videos. Thanks a lot!
@LeilaGharani
3 жыл бұрын
Sure. Will do. Great thing is Power Automate Desktop doesn't need premium access anymore so more people can use it :)
@igortorrealba
3 жыл бұрын
Also I recommend you Jon Levesque, Microsoft guy with a number of Power Automate videos for inspiration and learning
@danjarupath
3 жыл бұрын
+1
@InsideMyWall
3 жыл бұрын
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
3 жыл бұрын
@@InsideMyWall yes
@IvanCortinas_ES
3 жыл бұрын
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
3 жыл бұрын
Fantastic!
@geraldbauer5702
3 жыл бұрын
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
3 жыл бұрын
Oh wow! Thank you, Gerald!
@SavageGothamChess
3 жыл бұрын
Leila is just the best. There is nothing she can't do. She's the best.
@LeilaGharani
3 жыл бұрын
Thank you! 😊
@shadrackawunyo7786
3 жыл бұрын
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
@kaprisonept
3 жыл бұрын
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
2 жыл бұрын
Excellent automation, i am also an accountant, automating my process using power automate.
@woutboog6949
3 жыл бұрын
I really like everything you do and show Leila, with so much joy, profesionallity and ease. You are one of a kind !
@LeilaGharani
3 жыл бұрын
Thank you!
@josecarlosconejo5724
3 жыл бұрын
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
3 жыл бұрын
Thanks for sharing, José!
@georgiabarros1697
3 жыл бұрын
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
3 жыл бұрын
Great to hear, Georgia!
@igortorrealba
3 жыл бұрын
You explain things so pleasantly. Thank you for that
@luciozanarotto1974
2 жыл бұрын
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
3 жыл бұрын
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! 👍
@CeliaAlvesSolveExcel
3 жыл бұрын
There's a whole new automation world waiting to be explored.
@shadrackawunyo7786
3 жыл бұрын
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
@TheBlindBoy1990
3 жыл бұрын
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.
@jamesa6720
3 жыл бұрын
Just got this setup for my business. Absolutely brilliant time saver, thank you
@kuuuyajim
3 жыл бұрын
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
3 жыл бұрын
Thank you for your support, Jimmy!
@BuddhaAfterDark
Жыл бұрын
it is interesting how you make the actual errors in Power Automate sound so simple to fix :D
@santoshpv321
3 жыл бұрын
Sooooo easy to understand with all your videos...Thx a lot.
@evedgard
3 жыл бұрын
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
3 жыл бұрын
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...🙂
@balajis495
3 жыл бұрын
Very happy to say that Leila is my inspiration
@Han-dle598
3 жыл бұрын
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
3 жыл бұрын
I was wondering for what I would use power automate, now, im clear, thanks!!
@LeilaGharani
3 жыл бұрын
Glad it helps. I'll have more examples in the coming weeks.
@jorgelara3116
3 жыл бұрын
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
@Yatish1307
3 жыл бұрын
Thanks , you always upload videos i need to know more for my work👍🏻
@jobie3015
3 жыл бұрын
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.
@DougHExcel
3 жыл бұрын
Great examples! Using IFTTT, and can't wait for MSFT to add more to this
@LeilaGharani
3 жыл бұрын
Glad you like it!
@enocharthur1955
3 жыл бұрын
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
3 жыл бұрын
You're most welcome 😊
@EricHartwigExcelConsulting
3 жыл бұрын
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
3 жыл бұрын
Glad you like it, Eric! More to come :)
@nemirajgathani
3 жыл бұрын
I’m in love with excel coz of u!!! Thank u...
@LeilaGharani
3 жыл бұрын
You're welcome 😊
@andrewmoss6449
3 жыл бұрын
Wow! Power Automate looks really useful.
@GinoNigro
3 жыл бұрын
Amazing! I am just jumping into PowerAutomate and this is very helpful! Thank you so much
@LeilaGharani
3 жыл бұрын
You're very welcome, Gino!
@ragavakrishna1617
3 жыл бұрын
Nice update!.. please do a series of power automated
@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.
@RPAChampion
3 жыл бұрын
Great video made for everybody , all kinds of skills well done
@17aig
3 жыл бұрын
As usual another great tutorial thank you so much
@LeilaGharani
3 жыл бұрын
Thank you! Cheers!
@ChandooD
3 жыл бұрын
This is great Leila... I am going to play with Power Automate now :)
@LeilaGharani
3 жыл бұрын
Have fun :)
@mostafa4321
3 жыл бұрын
Thank you Leila can you do more lectures about power automate to explore other scenarios.
@LeilaGharani
3 жыл бұрын
Sure. More to come :)
@wayneedmondson1065
3 жыл бұрын
Thanks Leila. Power Automate looks interesting. Thanks for sharing :)) Thumbs up!!
@LeilaGharani
3 жыл бұрын
It really is! And much more to learn :)
@maysupan7
3 жыл бұрын
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?
@kavirshop
Жыл бұрын
Great video, very informative
@johnd4717
3 жыл бұрын
Perfect replacement for Zapier I guess, and ofcourse we wanna see you more often Leila ;-)
@anferben
3 жыл бұрын
Great news about Power Automate and of course I came to see what Leila has about the tool... et voila!! Thanks!!
@darrylbaker5271
3 жыл бұрын
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.
@lahotipushkar
3 жыл бұрын
Thank You so much. It is very useful. Only I need to change time zone format. Can you please help me with the same?
@PemboDave
3 жыл бұрын
Great ideas thanks for sharing
@rossjohnson1199
2 жыл бұрын
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?
@armandovillalba242
Жыл бұрын
Omggggg 😅😅😅😅 looks soooo easy!!! 👏🏻👏🏻👏🏻👏🏻
@danielholanda7673
3 жыл бұрын
Amazing content. Thanks Leila!
@LeilaGharani
3 жыл бұрын
My pleasure, Daniel!
@johngoumas6675
3 жыл бұрын
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?
@craigbrown3419
3 жыл бұрын
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
@t2p5g4
3 жыл бұрын
You pronounce Z the correct way!
@RahulJauhari
3 жыл бұрын
Thanks for useful video 🙏🏼🙏🏼
@bulbulkotecha5446
3 жыл бұрын
Hi.. your videos are very useful..can u please make videos about AI builder in power automate ?.. Thanks in advance..
@denisesakai8205
3 жыл бұрын
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
2 жыл бұрын
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 : )
@eniddeltacross4410
3 жыл бұрын
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?
@adityapatnaik6079
3 жыл бұрын
SHE IS THE BEST !
@rayhanhossain7999
3 жыл бұрын
We expect a full course on power automate specially covered business and finance task
@techdelasabana
3 жыл бұрын
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
3 жыл бұрын
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.
@NaviMumbikerPrakash
3 жыл бұрын
First to comment 🙈🤘. Thankyou so much your videos have thought me alot wrt all the ms softwares
@ashokkumar-qy3ph
3 жыл бұрын
Can you please start Power Automate tutorial
@antoniobrito4358
3 жыл бұрын
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
@miransh
3 жыл бұрын
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
3 жыл бұрын
I don't think Google is the answer if you find Microsoft intrusive!
@raziajeena9861
3 жыл бұрын
really good. thanks
@veronicaterra6256
3 жыл бұрын
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!!!
@malubianchi9926
3 жыл бұрын
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?
@vida1719
3 жыл бұрын
Great series
@Rainquiller
3 жыл бұрын
Thanks for this! Quick question, how do I integrate this flow on recording different tasks? Thanks in advance!
@jamesa6720
3 жыл бұрын
Incredible thank you
@nevado.
3 жыл бұрын
That's amazing!!, can we use Power Automate to post some photos to Instagram?
@PotatoStudioTV
2 жыл бұрын
Great Content. Just a Question, what is the minimum O365 License needed to get these features? Is the $5/Mo. Microsoft 365 Business Basic include these tools?
@LaxmanKumar-rj5ky
3 жыл бұрын
pls make series on power automate desktop
@yulinliu850
3 жыл бұрын
So cool 👍
@justinspencer-young3935
3 жыл бұрын
Unfortunately this only works with a Microsoft business account not a personal account :(
@lisaeppel4743
3 жыл бұрын
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
3 жыл бұрын
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.
@danjarupath
3 жыл бұрын
I love your vdo I love you ❤️❤️❤️😗
@szisziszilvi
3 жыл бұрын
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?
@franzstreule333
3 жыл бұрын
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
3 жыл бұрын
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
3 жыл бұрын
@@LeilaGharani the conversion worked just fine, thanks
@valerieevans4417
3 жыл бұрын
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
3 жыл бұрын
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.
@gautamsharma-pn9qy
2 жыл бұрын
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 ..
@houcineb4139
2 жыл бұрын
thank you
@chrism9037
3 жыл бұрын
That was great Leila!
@LeilaGharani
3 жыл бұрын
Thanks Chris 😊
@RIPUZI
3 жыл бұрын
Can you do this with a personal office 365 subscription?
@RIPUZI
3 жыл бұрын
I've managed to get it to work. Yay!
@thamilanban
3 жыл бұрын
Hi Leila Expecting a Power Apps course in Udemy. Thank you.
@ricardowong1813
3 жыл бұрын
Thanks Leila 💪
@ddp2049
3 жыл бұрын
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?
@prashantrai5911
3 жыл бұрын
Can u make a video on expression use in power automate
@JoeyCbr
Жыл бұрын
One thing to note, Timestamp in PA doesn't adjust to accommodate daylight saving time
@NamHaVblog
3 жыл бұрын
Thanks
@Krzysztof_Topolewski
3 жыл бұрын
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?
@krishnabairi1581
3 жыл бұрын
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?
@jamietan8002
2 жыл бұрын
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)
@geshoow1288
3 жыл бұрын
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.
@sharusg
3 жыл бұрын
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.
@mif1965
9 ай бұрын
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
@cybertears1994
Жыл бұрын
Sad that i can't use this if i don't have Office 365 for business. But i will try it on my job computer bcuz we have Business licens there.
@minhlehuy3055
3 жыл бұрын
Can you make a video showing an app that can capture the duration of some activity that we can predefine in this app?
Пікірлер: 196