Skip to main content

I have an automation which looks for a specific log file to match with the present date and then use it to populate extra stuff in it.

File naming convention: “call_log_01.07.2025”, “call_log_02.07.2025”.

The problem is, whenever I look for anything other than “call_log_01.07.2025”, like “03.07.2025”, Zapier still points at the “call_log_01.07.2025”.

I tried everything to make it work:

  • Re-connect my OneDrive account
  • Delete - Redo the specific step from scratch
  • Feed the name correctly at a previous step (without a concat)

What is really confusing is that I have a different automation setup exactly the same and it works perfectly. I compared each step of it and there are no differences.

Anybody in the same situation?

Hi ​@Andrei I. and welcome to the Community! 🎉

That’s really strange, especially as you’ve got the same setup in another Zap that’s working correctly.

Can you share some screenshots showing the current setup of that OneDrive action, as well as the Data In and Data Out from a recent test where it found the wrong file? That will help us to get a better idea of what could be causing this issue. 

Look forward to hearing from you, keen to get to the bottom of this!


Hi ​@SamB, thanks for looking into this.

Okay, so here are my examples:

Working automation

Data In

 

Data Out

Buggy automation

Data In

 

Data Out

 

As I said I tried many “hacks” to make it work but nothing worked. Just to mention, if I removed the “call_log_01.07.2025.xlsx” file completely from the folder, that seems to make it work with any other date…

 

I hope I provided enough information so far. Thanks!


Hi ​@Andrei I. ,

 

This seems to be the “TEST” not the “RUN”. The time on top says this was 1 hour ago. 

 

Can you check it in the run ? 


Both automations are offline at the moment and when I did the screenshots I was testing them step by step. The outcome is exactly the same on run, I just checked now.


From what I see, the only reason this would happen is that you are mapping the wrong value in the search. In the buggy automation you arent showing the Data In for the same Data Out. Data in is showing 6 mins ago while the Data Out is showing 1 hour ago. Check you are mapping the correct values


Is this more helpful? 

Data In
Data Out (part 1)
Data Out (part 2)

 


Yes, that is definitely more helpful. Another thing to check, you are sure that the 03.07.2025 file is in the same folder (call logs) you are trying to search in? I think the issue is the file 01.07.2025 is modified on that date, and therefore it is returning in the search. You might wanna try to return all the files and then loop through them as line items with a filter where the file name is exactly what you’re looking for


Sorry for the late reply...

I tried everything and still doesn’t work. What’s more strange is the fact that I found a similar issue on a different project.

There are 2 steps which are using OneDrive → Find File:

  • One of them is looking for a call log (similar to the one on top that I mentioned) and gets it right without an issue, no matter the name of it.
  • The 2nd one is looking for an image in a completely different folder structure, and is always tagging a random call_log file instead

I tried to delete the step, re-create it, re-connected my OneDrive acccount, change the name of the folder, change the place of the file in a different folder - nothing works.

It feels like it has a history or something similar behind the scenes and doesn’t want to ignore the old inputs/outputs.