Unable to include expression or dynamic data in Filter Query

(0) Share

Report

Posted on by AbhishekTogaru

Hi Everyone,

We are trying to frame filter query with expression to include dynamic data but its not working and we are forced to use filter array insted which resulted in reaching the transaction limit at times and the flow just stops.

Is there a way to include expressions with if conditions in filter query.

We are comparing 2 lists and had to iterate one of them and find the matching item in other list and there are 3-4 conditions we need to check as well. There are almost 15 places we have to repeat this scenario. Do help us.

All responses (1)

Answers (0)

v-litu-msft on at

Like (0)

Report

Re: Unable to include expression or dynamic data in Filter Query

Hi @AbhishekTogaru,

Please remove the String() function from the left box of Filter array action, on the left box, you just need to append the item()?['ColumnName'], please refer to this document:

https://docs.microsoft.com/en-us/power-automate/data-operations#use-the-filter-array-action

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.