Have you seen the Facebook group, Microsoft Power Automate Professionals, where we network and solve PA problems together: facebook.com/groups/754059285247921/ 🔥🙌

A heartfelt thank you from Morocco.

@andersjensenorg

6 ай бұрын

My pleasure 😊 Kind regards, Anders

Thanks so much for this video! Everything is explained clearly and the pace is perfect for a beginner.

@andersjensenorg

7 ай бұрын

Hey sbrutcher, I'm so happy to hear - thanks a lot 🙂🙌

god bless you man! WE have been learning a lot from u !

@andersjensenorg

Жыл бұрын

Thanks a lot for all the supportive comments 🙏😊

Hi Andres! Love your videos! Thank you for all the work you put into them! I ran into an issue where I want to change calculation mode in excel from auto to manual in the beginning of the flow and then back to auto once the flow is complete. No matter how much I tried, I can’t get it working. I have updated scripts as you have shown here, I have recorded scripts. I tried in same and different browsers windows. It is just not working. Can you please suggest something? Thank you!

This is just awsome!!! Thank you so much! Create job! My applauds

@andersjensenorg

5 ай бұрын

I'm so happy to hear, thanks a lot 🤩🙏

Great tutorial, at 14:44 I couldn´t see dynamic content and looking why that happened, sounds funny, it was because of the resolution was to close and didn´t appeared in the screen for that reason. Thank you, Anders, another time giving value with your knowledge. Thank you, a lot!

@andersjensenorg

Жыл бұрын

Hey pablo, thanks a lot 😀 My next shopping is a bigger screen (16:9 resolution), so I can record in 4k 🔥

Can you make a video on VBA code run using power Automate desktop 1.run main macro function simple 2. Single or multiple parameter macro run

Kudos great content sir 👍

@andersjensenorg

Жыл бұрын

Thanks a ton, Suraj 🙏🙌

Great video! It’s posible to fill a cell, if there is no an ID columns? Perhaps looping up in w columns

@andersjensenorg

Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Thanks for this video! So helpful as always! one thing I note, for Run Scripts I don't have a field for Active Sheet. Does anyone know if that is a change that was implemented since this video came out?

@andersjensenorg

Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Hii Anders sir make a video on data scraping of Amazon or Flipkart website while scraping the Hyperlinks data getting scraped in an unstructured format make a video on this as soon as possible

Thanks for your wonderful video, but what if there is no table in the excel, if it is possible to generate a dynamic table? The count of the row and column are unknown.

@andersjensenorg

Жыл бұрын

Hey Penny. No, not with the Excel activities, but then you can generate an Office Script instead and invoke it from Power Automate. Kind regards, Anders

Great video! Looks like the course material is gone now though - I only see a file about Pepsi employees. 😞

@andersjensenorg

Ай бұрын

I'm so sorry, Oliver. Thanks for letting me know, it's now fixed 😊 Kind regards, Anders

Excel VBA Series videos of Excel from basic advance like comparing 2 datatable using Macro Power automate desktop 2022 👍

@andersjensenorg

Жыл бұрын

Have you seen the last part of this video, Suraj? Office Scripts are the new VBA 😊

Hello there, is there a way to extract data from a pivot chart with power automate? In my case, power automate just finds "normal charts" in my sheets but I can't fetch data from pivot charts. Thank you in advance!

@andersjensenorg

Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Hii Anders sir can you make a video on Dynamic row count in PAD

@andersjensenorg

Жыл бұрын

Hey Suraj, thanks a lot for all your support. A video on that is not on the to-do, and I'm not 100% sure, what you mean? Can you post your query on the Discord (with an elaboration)? Then we solve it. The Discord link is in the Description. Kind regards, Anders

@suraj_singh321

Жыл бұрын

@@andersjensenorg sir I mean to say in an excel file the rows are continuously changes as per data that dynamic count only that's it 👍

#andersjensenorg we are converting the Excel data to a table, then only Power Automate is able to read... but when we get a file from an email, we will save that to the Onedrive folder and I want the Power Automate should convert it to a table to process further steps within that flow is there any possibility for that? Your suggestion is a great help, Thanks in advance.

@andersjensenorg

10 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Thanks for the video, but in the minute "44:20" you mentioned in the concat there are three things and you didnt put anything after ' "ID": " ', also you didnt put in the third one after variables('RowLookup'), ' "" ', i didn't get it why we made three if we concate only ID with variables

@andersjensenorg

4 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Is it possible to remove conditional formatting in excel using automation flow

@andersjensenorg

11 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

So, I can't get past the step of copy/paste into the expression bar.. add(float(item/TotalSales": "@items('Apply_to_each')?['SalesStore1']),float(item/TotalSales": "@items('Apply_to_each')?['SalesStore2'])) .... It keeps telling me the expression is invalid.. I try to click Ok multiple times like you said, but it won't let me proceed the same as you in the video.. Any tips?

@andersjensenorg

Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

@abinashjena7275

4 ай бұрын

Hy, getting same issues. Is there any solution?

How do I paste clipboard contents into a designated cell in Excel?

@andersjensenorg

Жыл бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Could please explain how to do the same thing using an automated cloud flow😢

@andersjensenorg

18 күн бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

@andersjensenorg

18 күн бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Is there anyone that can help me build a cumulative excel report based on data coming in from an email every day?

@andersjensenorg

6 ай бұрын

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

Unable to follow with 2024 Power automate :(

@andersjensenorg

Ай бұрын

Untick the "New designer" toggle 😊

Hi it showing me error while loading the excel

@andersjensenorg

Жыл бұрын

Hey Blue sky blogs Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzread.info/dash/bejne/kYWGq4-Sn5XOaLg.html Have a great day. Kind regards, Anders

Edit: Why are you starting off doing something and then talk about what you will do with office scripts (last tab) "on steriods"... what is the objective and what is it that you will do for this session... It seems you just dove and provided zero context...

@andersjensenorg

Ай бұрын

Thanks for the feedback 🙌

Hi Andres! Love your videos! Thank you for all the work you put into them! I ran into an issue where I want to change calculation mode in excel from auto to manual in the beginning of the flow and then back to auto once the flow is complete. No matter how much I tried, I can’t get it working. I have updated scripts as you have shown here, I have recorded scripts. I tried in same and different browsers windows. It is just not working. Can you please suggest something? Thank you!