Search Google Sheets across multiple column criteria?

[bal]

Looking to update a specific Google Sheet row, which I can only determine by narrowing search by values across column A and B.

I must not be understanding how filters work, since neither the Get a Row or Search a Row function with a filter for column B data give me the correct row ID: it’s either nothing (via equal to column B value) or all (via contains column B value).

Attempting to filter my next Update Row action as advised below does not work either, since I’m still doing the same thing of searching for one column value and filtering against another column value.

Silly question, but is there simply a way to filter off results of the last action?

Search google sheets using multilpe columns

Hi, While searching from google sheets, usual scenario is to provide "column" and "value". All the rows where "column" matches the "value" will be selected. What if I want to add another column to search criteria? i.e. give me all the rows where "column1" contains "value1" and "column2" contains "value2". Is this possible? Thx,

[DanielBeckett]

Hi @bal

Can I see an example of what you’ve tried so far? You can share your flow by clicking on the ‘private’ button in the top right corner when editing your flow. You can email the share URL to support@flowxo.com so we can take a look

What may also help is to take a look over the following tutorials:

Using Filters in Flow XO – Flow XO – Medium

Using Google Sheets in Flow XO – Flow XO – Medium

[bal]

Thanks Daniel,

Here’s the flow:

Availability Set - Flow XO

Since I’ve tried a few different attempts at updating the row that included a search-delete-re-add approach you can ignore the Google delete and add actions.

[DanielBeckett]

It looks like a lot of your actions & filters are using {{which_day.parsed_answer}} as an output but the question is actually set to the question type of ‘Choice’. This means that the actual value you should use is {{which_day.choice}}.

If you swap over any outputs to use the choice value rather than parsed.answer does that fix it for you?

[bal]

Thanks for clarifying that Daniel, but no, unfortunately to that does not fix it. I’m attaching a few screenshots of what I see in the interaction logs, which suggest that I’m still not able to filter the output of 3 separate row’s values (Monday Tuesday Sunday) down to just the row for Tuesday.

< 1 week into learning Flow so perhaps I’m approaching this wrong, but I thought I could extract the Row ID for a specific gSheet row by simply applying multiple filters to an array of values returned as output in the action, but perhaps that is not the case?

Flow Filter

Filter #1 Results

Filter #2 Results

[DanielBeckett]

Any filter for ‘Equals’ is looking for an exact match so if your values equal: “Monday Tuesday Wednesday” and “Tuesday” then it’s not going to match up. You could change over the filter to use ‘Contains’ instead which should detect a match there.