Filter Query one column lt another

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@MarconettiMarco if you used it before, kindly share the query screenshot and the result after running the flow.
at my end it show error.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

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.

Was this reply helpful? Yes No