filter datatable not working for numbers in power automate desktop

Like (0) Share

Report

Posted on 25 Oct 2024 05:48:08 by saikrishnask1

Filter data table is not working for numbers. I need to filter the datatable based on Payment Amount column where value is 0. After executing I am getting 0 rows in output datatable.

Categories:

Process Advisor

All responses (2)

Answers (0)

Suggested answer

eetuRobo 3,282 Super User 2025 Season 1 on 25 Oct 2024 at 06:14:26

Like (0)

Report

filter datatable not working for numbers in power automate desktop

I think that might be because the 0 in your data table is text value. So in your Filter data table check if Payment Amount column value is %'0'%

Result:
Suggested answer

VishnuReddy1997 2,324 Super User 2025 Season 1 on 25 Oct 2024 at 06:09:51

Like (0)

Report

filter datatable not working for numbers in power automate desktop

Hey Hi,

Can your share the screenshot of your flow.

And one morething try with column index like this once before sharing the screenshot.

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

Thanks & Regards
Vishnu Reddy