Filter Array

(0) Share

Report

Posted on by MB35

Hi,

I have built the following flow:

Run Script (this completes a vlookup in my xls)

Create table

List Rows present in a table

Then I have a filter array with the following expression:

The result I'm after is for any items which have a blank value in 'phone 1' AND has an #N/A result in the new column from the vlookup I will send an email to.

However although the vlookup has worked correctly in the xls, it doesn't seem to be pulling through into the filter array.

Any advice here as I've been going round in circles with applying this filter.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

lbendlin 8,716 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

that's not a blank value, that's an empty string.

Was this reply helpful? Yes No
MB35 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you explain this further please?

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
any items which have a blank value in 'phone 1'

translates to

empty(item()?['Phone 1'])

Was this reply helpful? Yes No
MB35 91 on at

Like
a
(0)

Report
Copy link

Link copied!

The 'phone 1' section of the array is working and this is also how automate converted it from basic mode.
It is the 2nd part around the n/a value which is not working correctly. I was thinking I may need to add a copy & paste special values step into my script after the vlookup has completed for it to recognise the value(?)

Was this reply helpful? Yes No
lbendlin 8,716 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

does the value come over as "#N/A" or does it result in an error (as it should)?

Was this reply helpful? Yes No
MB35 91 on at

Like
a
(0)

Report
Copy link

Link copied!

In excel, the result from the lookup is #N/A where the value is not in the comparable list

Was this reply helpful? Yes No
MB35 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah, perhaps an IFERROR(VLOOKUP....
is what I need to put in place and then I can specify the value in place of the #N/A

Was this reply helpful? Yes No