Power Platform Community Forum Thread Details

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:

Building flows