Google sheets filtering

Questions
1

Hi, I am having trouble with filtering in a Google sheets module. I want to filter based on first name, last name and date of birth in case there are multiple names that are the same. Currently I can filter first and last name together with success, or I can filter with date of birth with success. If I combine all three I get no results.

Google Sheet update scenario
Google Sheet update scenario1285×358 34.3 KB

iterator
iterator451×546 21.3 KB
Google sheets filter
Google sheets filter455×627 29 KB

Google Sheet update row.blueprint.json (48.9 KB)

The end goal of the scenario is to update a row in google sheets using the unique row number.

image
image838×198 6.54 KB

3

Hi @John_Mckinven and welcome to the Make Community!

Your scenario works. However, when you search for Samantha Mayhem 1968,. that person is not in your spreadsheet so it returns no data. Put a filter between your sheets to check that the number of bundles returned is greater than 0 and the error will go away.

L

4

Thank you so much, really appreciate it

1 Like