DATA TABLE FILTERING

(0) Share

Report

Posted on by TN-20081510-0

I HAVE A DATATABLE WITH MULTIPLE ROWS AND COLUMNS. THE VALUES ARE AS FOLLOWS IN SCREENSHOT.

WHEN I APPLY FILTER DATA TABLE TO KEEP ONLY VALUES GREATER THAN 10000 IN COLUMN "OPEN" IT IS RETURNING VALUES LESS THAN 10000 ALSO.

WHAT IS THE ISSUE ?

Categories:

Power Automate Desktop

Screenshot 2025-0...

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Your Filter data table -action is filtering column that is in index 2

And since Power Automate Desktop regular flow starts indexing from 0 that means you are filtering "high" column instead of "open"

So change the Filters to apply to be either 1 or the column name 'open'

Then remember to check the FilteredDataTable -variable and not the DataFromWebPage

Was this reply helpful? Yes No
TN-20081510-0 52 on at

Like (0)

Report

No, it is not working still.

You can try it out yourself and see the issue.

Go to here and extract the same table and try to filter . Equity Market Watch, Live Nifty & Sensex Charts & News - NSE India

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Thank you for sharing the site for easier troubleshooting.

I think the problem is that PAD flow reads the 'open' -column values as text and not as numbers. That's why your filtering does not work.

My first suggestion would have been changing the "Extract data from web page" -actions output to be ExcelInstance rather than variable. But I noticed that then if you try to filter the excel it will give error about the some columns having string and decimal types.

I also tried to do a loop which would update all the "open" columns values to numbers (simple but not efficient way since it would require looping the whole data table). That did not work since when I used "Update data table item" -action and used number type value to "open" column it changed it back to text. I think thats because you can't have multiple data types in one column and so it doesn't let you to update the value to number since other values in that column are text type.

You filter the values with a loop. Like so:

This is not efficient since you need to loop the whole table and check each row one by one but this is what I was able to come up with

One thing you could also try is to use the "Download csv" and open that in Excel and filter with Excel actions

Was this reply helpful? Yes No
TN-20081510-0 52 on at

Like (0)

Report

Even for simple filtering ,it is not working.

Lets assume the data is

Col1 Col2

10000 20000

5000 300000

13000 200000

Now if you do filtering with the condition in screenshot, it does not work

Screenshot 2025-0...

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

As I said the reason why your filtering most likely wont work is because those values are most likely text type and not numeric type.
So even though it looks like you have table with numbers they are actually text type.

You can check it by pausing the flow (not stopping it but having it paused so you could still continue the flow run) and opening the datatable and double clicking on the cell value to see if its text or numbers.

For example: Here I have a dummy flow stopped where I have created a data table with
-Column1 which stores Numeric type values.
-Column2 which stores Text type values.

They look the same when I open the data table when the flow is paused.

But when I double click any cell in Column1 it shows that they are numeric values and I can increase and decrease the value for debugging / testing the flow:

But when I double click the Column2 any cell it shows that its text and I can write anything on it

You can also test it by taking first row on both columns and opening the variable to see what type they are:*
Column1Row1:

Column2Row1

There for if I filter from the Column1 it works as expected:

Result:

But if I filter from the Column2 it will not work:

Result:

And another test with filtering column2 values that are less than 1 000 000:

Result 0 rows:

This is because if you filter text like that it will compare individual characters. So with "200" < 1 000 000 it checks if 2 is bigger than 1 and then if it is then the value (in this case "200") is bigger. (Called lexicograpgical or alphabetical comparison).

So the issue is that you are comparing two different types (text vs numerical) and thats why you get confusing results.

Was this reply helpful? Yes No