Hello all,
I am trying to set up a onedrive folder watch where a new file getting added to a folder triggers my scenario. I have had some issues with onedrive triggering with old files so am trying to set up a filter where the scenario only goes ahead if the file creation date matches the current date, but to no avail. I have even tried converting both dates into string as I would only like the scenario to continue if the file creation output contains todays date. Can anyone see what I am doing wrong?
Current Flow and filter
Onedrive Output
Date Output
One thing I did notice is that the date output string seems to appear empty in the filter for some reason
Any help would be greatly appreciated!
Best.
Joao
Hi @Joao_Marques1,
Be mindful that âcurrent dateâ or {{now}} has to exactly match if you use it as an unformatted date filter. And as there is always a lag of some sorts between systems, it is impossible to match the created date from OneDrive to the {{now}} date in Make.
The lag could be milliseconds, seconds, or if there is a lot of traffic and digestion even minutes. One thing you can do is try to filter on created date within the last minute:
The other thing is to be mindful of timezones. The created date from OneDrive could be formatted in a different timezone than your Make account. If you use the {{now}} function and you hover over the date notation, you will see the raw date value. This should be ending with a Z, for Zulu time (UTC+0).
Some external sources donât pass dates in UTC+0, but in their current timezone. Altough with OneDrive, that does not seem be the case.
Please, follow these steps when asking a question, and youâll be more likely to get a helpful answer:
Give us a detailed explanation of what youâre trying to achieve
Tell us about any steps youâve tried so far
Include screenshots of:
-
your scenario flow and setup (functions, mappings, variables, etc.)
-
module configurations and outputs
-
any error messages you are getting
Share the blueprint of the scenario you are asking a question about. (this does not contain the connection or personal information)
Henk
Certified Make Expert and Partner
Book a consult with me
1 Like
