Hi all,
I am trying to create a flow wherein PowerAutomate monitors a Sharepoint folder every 15 minutes and then send a list of all new files within that 15 minutes window. The condition should go something like this:
- TRUE: If new files are created in the folder within 15minutes then it will create a table of the new files and then post it in a channel
- FALSE: If no new files are created in the folder within 15minutes then it will post a warning in the channel saying no new files have been created in the last 15minutes
I pieced together the flow from reading various articles and posts here but I am hitting a snag as my Flow always return a FALSE even though I have added some files into the folder during my testing (in my tests i used a 2 minutes interval but once I put the flow to production it should run every 15minutes).
I checked the logs of the runs and I have a feeling that it has something to do with my Filter Query:
Created ge '@{addMinutes(utcNow(),-2,'yyyy-MM-ddT00:00:00Z')}' and Created lt '@{addMinutes(utcNow(),0,'yyyy-MM-ddT00:00:00Z')}'
it always return the below value:
Created ge '2023-10-24T00:00:00Z' and Created lt '2023-10-24T00:00:00Z'
I have attached a screenshot of my flow for reference. Thanks in advance for the help! 🙂
