Filter Data Table Action Challenge

(1) Share

Report

Posted on by Vishnu Maddala

Hi Everyone,

When we are trying to use the Filter Data table action to filter the values, it's not giving accurate results, ex: when giving value greater than 5, if the list containing numeric beyond 10, then it is not showing those results.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

could you please clarify your query- that would be helpful to understand the problem

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Have you made sure that all those values are numeric type? I think the numbers might actually be string values. Use Set variable action and take the one of those values from your data table and see if the type is Text or Numerical.

I had a similar problem where I tried to sort table which had rows that had row numbers in tens so row 1 had value 10, row 2 had value 20 ... row 10 had value 100, row 11 had value 110 etc.
And when I tried to sort that it sorted it in this order: 10, 100, 110, 20 When I would have wanted to sort it from smallest number to largest so 10, 20, 30 ... 100, 110 etc.
I had to change the values to be number types.

Was this reply helpful? Yes No