Unanswered

Get File (Properties Only) not working consistently

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I'm having a weird situation in which many of my flows have stopped working since Monday...

I have built some flows to process data from SharePoint. One of them it triggers every day at night to process the data from the day before. For whatever reason, the Get File (Properties Only) always returned Status Code 200, and retrieved 0 files to process when it is not the case.

I have tried to do a test only having the Get File (Properties Only) piece, and two scenarios:

Get File (Properties Only) with filter files created between two dates

Get file Properties between dates

Get File (Properties Only) files greater than a day.

Get file Properties bigger than a date

As you can see the first one didn't work, while the second one did work and retrieved some data.

While adding the screenshots, noticed that the dates where not correct as the one it was working was for files created today or later.

So I did another test, selecting files created as of yesterday, leaving with the Status Code 200 and no files retrieved.

Power Automate - Not working 2.png

Can someone help me out? Am I doing something wrong that I'm not seeing?

Thank you.

All responses (3)

Answers (0)

Pstork1 67,039 Most Valuable Professional on at

Like (0)

Report

Re: Get File (Properties Only) not working consistently

In this case I suspect what is happening is the result of timezone shift. Can you check the time and date for some files that were created on 7/22? Are the times of creation spread evenly throughout the day? Or are they all clustered at the beginning or end of the day? Depending on where you are located the shift from UTC, the way its stored, and the time you are inputting based on local time could shift the date to a different day.
Community Power Pla... on at

Like (0)

Report

Re: Get File (Properties Only) not working consistently

It is working for all the days, but for the 22nd of July. The attachments is one flow for two days.
22nd to 23rd July (Not working)

23rd to 24th July (Working)

When checking on the Sharepoint the files for 22nd of July they do exist.
Pstork1 67,039 Most Valuable Professional on at

Like (0)

Report

Re: Get File (Properties Only) not working consistently

In general Dates are always evaluated as Dates and Times. If its a date only it tends to default to that date at midnight. So to get all the files for today you actually need to test for yesterday at midnight and today at midnight. Time zones can also cause a problem since the dates are stored in UTC (Greenwich Meant Time) But you are probably checking against a date in your current time zone. Try using a filter that is greater than UTCNow() minus two days and less than UTCNow(). I think that will give you the files for Today.