Automate Filter Excel table and Copy/Paste to New Excel - Power Automate Desktop

[@adamtariq8137]

Thank you so much. I wish there more like I can give :)

[@PowerAutomator]

Haha you are welcome! Happy new year to you and family!

[@JackieChung-eo3il]

Hi, Thank you for the video, I loved it. In this lesson, my test in step 9, send keys {Alt}({Down})E couldn't work. Why and how could i fix it? Thanks for your time.

[@haozhonglee7436]

Thanks for your kind words! Recently some users reported send keys not working. Can you have a look at this video and put the step before step 9? Hopefully will fix your problem. Let me know if you still have problem. Give the other video a like too. Haha

[@JackieChung-eo3il]

@@haozhonglee7436 I found that it should add one more step before step 9 as send keys {Control}({Shift}(L)) to get into filter mode, then it works. Just sharing my finding. Thank you for your help.

[@PowerAutomator]

Thank you man!

[@joseluna9013]

Same error but it worked, thanks to both of you.

[@aniketsingh3364]

Hey please help.. In your shared screen of power automate.. On the right side.. Under flow variable there are data visible like Sydney and all of that.. But in my case nothing is being visible based on the data.. What to do

[@deepikadc0263]

Hi can you please post more videos on excel automation I would like to learn that and there is no KZbin to teach excel automation and I followed your video for my learning which is very useful ✨

[@PowerAutomator]

Thank you for enjoying the videos. The trick with excel automation is use the send keys. Just learn the excel shortcut keys and then you can use " send keys" from power automate for you.

[@ngocnguyen4616]

thanks for sharing. For the 1st Send Key : {Control}({Shift}{Down}) , it not working. Why and how could i fix it? Thanks for your time. For %CurrentItem%{Return} : which {Return} mean by?

[@mohammedbasha2546]

Hi, I have a master excel data. I need to filter clients from columns and then copy paste their individual data in a new work book and save it with a name in a folder. I wouldn’t be deleting any duplicates. Kindly assist.

[@AskArchana]

good job ..keeep it posting

[@PowerAutomator]

Thank you for the encouragement!

[@kuzog5737]

Thank you!

[@PowerAutomator]

Thank you for your comment. Glad it helped! :)

[@shubhammahajan8010]

Hi, can we insert an image or screenshot inside the email body from the clipboard or file stored in a local folder? Also, is there a way to copy and paste a data table from excel into the email body with its formatting undisturbed?

[@aniketsingh3364]

You are so awesome man.. That exactly what i was looking for.. A small doubt.. Please solve... Can i save this automation flow after using it one time and again use that by using some other excel sheet ?? Or I have to make this whole flow again n again ?? Please clarify🙏

[@PowerAutomator]

You can definitely save it and reuse again

[@PowerAutomator]

Thank you for the sub! :)

[@aniketsingh3364]

@@PowerAutomator I have also one problem related to that. Is there any way that i can share you that problem and you can help me in getting that power automate flow build up? Because that's actually a tricky problem

[@L霖-v2z]

Hi do you have a webpage power automate version of this?

[@PowerAutomator]

I don't have but I think you need to create a script then run it using Webpage power automate. See link learn.microsoft.com/en-us/power-automate/flows-excel

[@aniketsingh3364]

I have done all the things correctly but still my flow is not working.. Is it possible because I don't have a premium Power automate desktop?????...

[@PowerAutomator]

My videos all use free version. 🤣 You need to break it by parts and see which part of your program fails. Takes time to learn man. You need patience. learn.microsoft.com/en-us/power-automate/desktop-flows/debugging-flow

[@aniketsingh3364]

A small help i need.. I have added ctrl shift down step before 9th step to apply the filter.. But when the flow is running this step is adding the filter in first time but then it removing in second time.. Any solution for it?

[@PowerAutomator]

Copy that step and put in after step 12 (copy) so that it unfilters after copy.

[@aniketsingh3364]

@@PowerAutomator ohh maan... I have done the flow correctly and all data is getting saved correctly... 14000+ data of 35+ companies. All 100% correct.. Thanks man❤

[@PowerAutomator]

Well done!! ❤️

[@aniketsingh3364]

@@PowerAutomator hey sir.. I will be happy.. If u cover this problem in your video.. I have one filtered data in a excel sheet.. And I want to copy paste that data into other sheet which already having the data but the data to be pasted should be based on the column heading.. Please if it's possible

[@PowerAutomator]

Sorry mate, got no time these days. You can use the excel function to find use next empty row in excel. You can find and ask a lot of specific questions here in this website powerusers.microsoft.com/t5/Building-Power-Apps/Writing-to-first-empty-row-in-excel-selecting-an-excel-row-to/td-p/940100

[@kirannaidu75]

how do we convert my data into a datatable?.. it keeps throwing error at retrieve data table.. am new to this process. please help guide

[@PowerAutomator]

Have you seen this kzbin.info/www/bejne/rZmYeqKCYqysb9U

[@kirannaidu75]

ok my Control shift down step did not work./..{LControlKey}({LShiftKey}({Down}))..this worked

[@PowerAutomator]

Well done mate

[@shubhammahajan8010]

Hi, I am using the exact same way you entered %CurrentItem%{Return} in Send Keys but PAD takes spaces before and after typing CurrentItem in the filter. Is there any way to resolve this issue?

[@PowerAutomator]

What do you mean take spaces?

[@shubhammahajan8010]

@@PowerAutomator A space gets entered during execution of the flow in the beginning and end of the variable input. For example, "Power" is a text inside the variable... so while giving %CurrentItem%, it comes out as " Power " instead of "Power"

[@PowerAutomator]

I think your %currentitem% has spaces in front and at the end. Use "trim text" function for your currentitem. No. 4 on this website mspowerautomate.com/microsoft-power-automate-desktop-text-manipulation/

[@PowerAutomator]

Please remember to like the video and subscribe :)

[@lawrence5304]

hello, if it's an excel super table, is it impossible for PAD to edit(copy/paste/delete,etc.)?

[@PowerAutomator]

What's super table?

[@sofiakartika237]

can we do filter excel in background process?

[@PowerAutomator]

I don't think so unfortunately

[@ariefbros]

how if there are two sheets?

[@PowerAutomator]

You need to create a list with the two sheet names, then use "for each". Inside the "for each", use "set active work sheet" then you put all the steps from no. 2.

[@ariefbros]

@@PowerAutomator thankyou sir

[@mmbcampus]

Is it possible in power Automate web? Any tutorial link please?

[@PowerAutomator]

Unfortunately not possible. :(

[@mmbcampus]

@@PowerAutomator lots of limitations in power Automate web 😭

[@PowerAutomator]

What's stopping you from power automate desktop? You can set it up then ask power automate cloud to run the power automate desktop if your company willing to pay premium and your IT willing to set it up

[@mmbcampus]

@@PowerAutomator I need to ask my company to pay.... Thanks for sharing this good tricks.

[@mmbcampus]

Power automate desktop doesn't work when the desktop is off. I need a license for an unattended desktop. Right now, the company doesn't have any plans to buy this. Is there any tricky way i can run desktop flow but the desktop is totally off??

[@ayushbaranwal9705]

Foreground windows is not working in send keys why??

[@PowerAutomator]

Try to add another step "focus window" before send keys. I think it's a new bug and this is a workaround. Please remember to subscribe :)

[@ayushbaranwal9705]

@@PowerAutomator yes it worked ...thank you

[@aniketsingh3364]

@@PowerAutomator hey in focus window option.. What should I add in find window mode, window title and window class.. Please help

[@PowerAutomator]

kzbin.info/www/bejne/iZa7iWevZ8iGj6c try this

[@aniketsingh3364]

​@@PowerAutomator if we have 4 send keys total in our flow so we have to put focus window method 4 times each before the send keys???