Filter array returning empty []

[egornua1]

Hello All,

i have an excel sheet where i am using list rows present in table and then filter array for multiple values.

Filter array is returning blank even when the condition is one value.

Name of field in excel table is Delivery Terms

any ideas?

Thanks for your time.

[tom_riha · Accepted solution]

Hello @egornua1 ,

you must use dynamic contents in the condition, as you have it now you're just comparing two strings, checking whether 'Delivery Terms' string is equal to 'DDP' string.

Instead of the 'Delivery Terms' string use the related dynamic content or an expression that could look like:

item()?['Delivery Terms']

[egornua1]

@tom_riha - Thank you, that worked, much appreciated.