Table having records matching the date range in the Find Records action I am trying the Find Records based on email and date from the table above.The image below illustrates how I have set up the filter action.Three lookup values have been defined:email is exactly the email from the previous step created_on is on or after current time minus 7 days created_on is on or before current timeNo data is returned when testing the zap :( Thank you in advance for your help.

Question

Find Table Records by Date Range does not return results despite having records matching the date range

I am trying the Find Records based on email and date from the table above.

The image below illustrates how I have set up the filter action.

Three lookup values have been defined:

No data is returned when testing the zap :(

Thank you in advance for your help.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

SOLVED: The problem was with the lookup value for email. I was using the email from the incorrect action. I should have used the one from the loop.

CF

+14

Hi @cfarrugia

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor