web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Unable to get file pro...
Power Automate
Unanswered

Unable to get file properties from Sharepoint using Power Automate

(0) ShareShare
ReportReport
Posted on by 25
Hi there, 
 
I have a Power Automate flow that runs a process monthly which pulls files out of an SFTP fileshare and writes the files into a Sharepoint folder. Once it is in the Sharepoint folder, I get the files' properties so that I can read each file (2 on maximum) to tally the values and write it to a Sharepoint List. 
 
I have not had an issue for the last few months, but when I ran it today, I could see that while the files are being written to Sharepoint, I am unable to get the files from Sharepoint, let alone read the data. Here is the setup of the flow: 

 
However, I get this with status 200: 
{
  /*ignore all other header details - all the same*/
    "Date": "Fri, 27 Dec 2024 23:00:07 GMT",
    "Content-Type": "application/json; charset=utf-8",
    "Content-Length": "641",
    "Expires": "Thu, 12 Dec 2024 23:00:08 GMT",
    "Last-Modified": "Fri, 27 Dec 2024 23:00:08 GMT"
  },
  "body": {
    "@odata.nextLink": "https://default-3e021cc6-3906-4b50-a0b7-a491ee007230.06.common.australia.azure-apihub.net/apim/sharepointonline/shared-sharepointonl-618f2ac9-dd79-4ca9-bfde-7516fce3ac7c/datasets/https%253A%252F%252Fmelbournecdf.sharepoint.com%252Fsites%252FIntegrations/tables/6d13a6a6-3e70-43eb-b4b5-5f81955d7ad1/getfileitems?$filter=substringof(%27Dec%27%2c+FileLeafRef)&folderPath=%2fShared+Documents%2fCC+EREA%2fEREA_IN&$skiptoken=Paged%3dTRUE%26RootFolder%3d%252fsites%252fIntegrations%252fShared%2520Documents%252fCC%2520EREA%252fEREA%255fIN%26ix_Paged%3dTRUE%26ix_ID%3d6120%26ix_Key%3d00000000000000000000000000000000",
    "value": []
  }
}
I am at a loss, because when I ran the same job where "CurrentMonth" was set to "Nov," it worked normally. Is Sharepoint allergic to "Dec" by any chance? Thank you all. 
Categories:
I have the same question (0)
  • collinnunis Profile Picture
    25 on at
    Just to add, I removed the filter but I also did not get any luck with that. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard