Filtering an array on contains "X" or "Y"

(0) Share

Report

Posted on by MBates237

103

Hello,

I'm wanting to filter an array of values based on whether a field in the array contains either "HPO" or "GPO"

This is my flow and the error I get when just trying to filter on contains HPO

I'm taking the body of the previous step as my data to filter and then attempting to add another filter, but I get this error

Action 'Filter_PO_Number_Exists' failed: The execution of template action 'Filter_PO_Number_Exists' failed: The evaluation of 'query' action 'where' expression '@contains(item()?['Pending Supplier Invoices[PO Number]'],'HPO')' failed: 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

Any help would be appreciated.

Thanks,

Michael

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Tomac 4,048 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @MBates237

Looks like your issue is with the value in item()?['Pending Supplier Invoices[PO Number]'] not existing. It really looks like this is a malformed array pointer.

Did you perhaps mean item()?['Pending Supplier Invoices']?['PO Number']

What expression are you using in the previous Filter Array action, which is looking for a similar field?

Was this reply helpful? Yes No
MBates237 103 on at

Like (0)

Report
Copy link

Link copied!

@Tomac The previous step is this

And this gives me 38 records, which is what I'm expecting

Was this reply helpful? Yes No
Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Perhaps check for a null value first, before using the contains() function. contains() will error if it receives a null value.

Something like:

@and(
   not(equals(item()?['Pending Supplier Invoices']?['PO Number'], null)),
   contains(item()?['Pending Supplier Invoices']?['PO Number'], 'HPO')
   )

Use "advanced mode" to enter the expression:

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Verified answer

MBates237 103 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the input both, I had success using the following expression

empty(item()?['Pending Supplier Invoices[PO Number]']) and evaluating that as is equal to false

Was this reply helpful? Yes No