Unanswered

Filter cells in Excel Worksheet

(0) Share

Report

Posted on by CU-19081609-0

Hello,

I am trying to apply the filtering on cells after reading the worksheet in Power Automate Desktop. When the data is loaded into the DataTable, it contains all the rows without filtering. is there any way?

Categories:

Power Automate Desktop

I have the same question (1)

All responses (7)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @billysavior

Use find and replace datatable activity and you can filter the value in the datatable.

The result is datatable of row index and column index and you can proceed with the for each to retrieve the data for the particular row and column

Find and replace

Hope this helps

Usha

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @billysavior ,

After applying the filter you need to copy the filtered Data into Different sheet of the excel and then you can read the data from the excel.Then you will get only the filtered data into the DataTable.

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

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
CU-19081609-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!

I could not create another sheet. As further, I have to edit same sheet fill it after filtering.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @billysavior

That means you need to append to the existing data or you want to erase the previous and write the filtered dat?

If you want to append then

Use get free row or free column and using the freerowindex write the data table

Or if you want to write the filtered data you better write that into another sheet or new file.

Then it will be safe the loos of data does not happen.

If you still want to write the data by erasing previous then take the row count and delete the rows in excel sheet

Then write the filtered data in the same sheet.

Hope this helps

Usha

Was this reply helpful? Yes No
CU-19081609-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, After applying the filter on a column to exclude rows that are already filled. I want to add the data into the rows that are empty into the same excel sheet. @UshaJyothi20

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@billysavior

If possible, could you please elaborate your use case with some examples and screenshot. So that we can assist with more appropriate solution for your issue?

Was this reply helpful? Yes No
CU-19081609-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!

From line 12 i read the excel sheet in datatable. That contains all the rows from worksheet even after filtering. In For Loop from line 13, i will have to go one by one row in specific column "results", get the data from column "C" if condition is verify and run vbscript for SAP. Write results into worksheet in last step.

Was this reply helpful? Yes No