Issue in copy-paste action while Filtering in Excel in PAD

(0) Share

Report

Posted on by SA_VOH

231

Hi,

I am trying to filter some data in Excel and then copy the filtered data and paste it to another workbook. As filtering is now available in PAD, i am able to filter and then select the data using keyboard actions as shown in Image.

However, the moment action "Copy" using Ctrl & C at S. NO. 13 (in below image) is performed in PAD, it shows an error which says - "This action won't work on multiple selections" and as a result i am not able to copy the filtered data and paste into desired workbook.

Please help.

Any other workaround in achieving the desired result, please let me know.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Riyaz_riz11 4,191 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @SA_VOH ,

You can directly use filter using new excel action and read data and that variable you can pass over new excel using write action.

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

Regards,
Riyaz

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @SA_VOH ,

Instead of send keys you can use the below shown action for copy and paste in excel.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
AK88 453 on at

Like (0)

Report
Copy link

Link copied!

Hi @SA_VOH ,

You can see new more number of actions mainly to perform filter activities in Excel can bee seen in 'Excel Automation' under 'Advanced' in PAD. Along with Filter the cells, copy and paste the cells/column etc.

Kindly check, also if you're not updated to latest version of PAD, kindly update it.

thanks,
if my response resolved your query kindly mark it as solution and give Thumps UP!

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Read and write is not leading to desired action. Its reading entire column rather than selecting the filtered rows contents only.

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishnu,
Copy and paste is leading to desired action. Thanks. However, copy & paste doesn't preserve the formatting of destination cells in Excel. And read & write is not looking as viable option as explained by me to @Ahammad_Riyaz above.

Was this reply helpful? Yes No
SA_VOH 231 on at

Like (0)

Report
Copy link

Link copied!

HI AK88,
MY reply is same as i gave to @VishnuReddy1997

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @SA_VOH ,

Can ellabrote what you want to do.

Regards,
Vishnu Reddy

Was this reply helpful? Yes No