Share
ReportHi,
I have one a list which has two number columns A and B.
I want to get items by filter A < B.
How can I generate the filter query sentence?
Thanks!
Jack
You’re offline. This is a read only version of the page.
Announcements
Hi,
I have one a list which has two number columns A and B.
I want to get items by filter A < B.
How can I generate the filter query sentence?
Thanks!
Jack
Hi @Anonymous,
Do you mean that you want to compare a number column with another number column without Filter Array?
I think there is no way to achieve this but the Filter Array in Power Automate.
Since you want to compare one column with another column, it is necessary for you to loop through all the items, which is how Power Automate processes data.
@MarconettiMarco if you used it before, kindly share the query screenshot and the result after running the flow.
at my end it show error.
Hello @Anonymous ,
directly in the “Get items” action you can use the filter query. If you already know di columns unique names, please use the filter query in advanced mode and type: <your_column1> lt <your_column2>.
BR,
Marco
Hi @Shuvam-rpa ,
Yes, that's what I've done. But for the performance, I don't want to let it go through all items and waste the searching time.
Is there another way to achieve this?
Thanks!
Jack
@Anonymous As per my knowledge is it only be possible by first you get all items and then try to use filter array action to compare A and B column from the list.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
All responses (
Answers (
