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

All responses (7)

Answers (0)

MB35 91 on at

Like (0)

Report

Re: Filter Array

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
MB35 91 on at

Like (0)

Report

Re: Filter Array

In excel, the result from the lookup is #N/A where the value is not in the comparable list
lbendlin 7,943 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Array

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

Like (0)

Report

Re: Filter Array

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(?)
lbendlin 7,943 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter Array

any items which have a blank value in 'phone 1'

translates to

empty(item()?['Phone 1'])
MB35 91 on at

Like (0)

Report

Re: Filter Array

Can you explain this further please?
lbendlin 7,943 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Array

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