Filter in two columns

(Juan Galindo) #1

Hi everyone,

I would like to present my case, I ask in a bot for a name of a street and the number, with this two data I have to find in a google sheet in google drive where I have this data in columns, I have to find the match between this two data, but I can only set one of this values and I set the other data in the filters but it don’t work.

FLOWXO3.jpg1360×591 74.8 KB

How can I do this?

Thanks in advance.

(Karen Barker) #2

Hi @galpe

Unfortunately using the standard Google Sheets search function integrated into Flow XO it isn’t possible to search on multiple columns. It would be possible however to use the code service to run through the results from 1 search term to just return the ones which include the 2nd search term as well.

There’s a post here that shows further details of how to do this. :thumbsup: