can we use multiple filter query on list rows present in a table in power automate desktop

(0) Share

Report

Posted on by kiran_g

150

when I'm trying to use multiple queries it's showing that " Cloud connect call failed with status code 'Bad Request'. "

If possible how to use it in PAD

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share a screenshot of what you tried to do?

Was this reply helpful? Yes No
kiran_g 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

I think it is probably because of the date. You're formatting it as a "long date" which means it's sending it as a string with the full name of the month. You probably need to provide a different format. Try using the action without the date filter to see what format the dates are returned in. Then use that in your Convert datetime to text action.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
kiran_g 150 on at

Like
a
(0)

Report
Copy link

Link copied!

i have tried with different columns, still not working. If it works can you show me how to do it.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The syntax seems to be correct. Are those actually correct column names in your table?

Does it work if you only use a single column filter?

Was this reply helpful? Yes No
kiran_g 150 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it works if i use single columns

Was this reply helpful? Yes No
kiran_g 150 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried this way instead of using a filter query. It works well, but it takes time to read more than 2000 rows. could you please check that this is the correct method or give me a simple solution?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

It is possibly correct, but I agree that this method will be quite slow. You could also try to use Find or replace in data table to find the rows where, for example, "Placement Completed" is in the "Placement_Status" column. This would reduce the number of rows you need to loop through.

I am not sure why the multiple filters in the List rows present in a table action do not work. It might be a bug. You could try to report it to MS support and maybe they'll come back with a solution.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @kiran_g

From below article, it is said that power automate cloud flow list rows in table action OData filter query does not support the usage of and operators ,

https://www.enjoysharepoint.com/power-automate-list-rows-present-in-a-table-filter-query/

So same thing would be happening with list rows present in table here 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No