Power Automate

Answered

Get files (properties only) - Sharepoint - failing

(1) Share

Report

Posted on by NC-19080650-0

Hi all,

**Updated with more info**

I’m battling to troubleshoot why the “Get files (properties only)” step in my power automate flow is failing to detect files in “[Company Site]\Account Processing\Nicks Test Folder\P00EM-131150\Ready for signing”.

The flow doesn’t fail on that step – it fails later, but the later failure is because it’s not detecting files in this earlier step.

The Inputs to "Get_files_(properties_only)" are

{
  "host": {
    "connectionReferenceName": "shared_sharepointonline",
    "operationId": "GetFileItems"
  },
  "parameters": {
    "dataset": "https://<tenant>.sharepoint.com/sites/<site>",
    "table": "[REDACTED]",
    "folderPath": "/<library>/<section>/<folder>/Ready for signing"
  }
}

And the outputs from "Get_files_(properties_only)" are

{

"statusCode": 200,

"headers": {

"Cache-Control": "max-age=0, private",

"Transfer-Encoding": "chunked",

"Vary": "Origin,Accept-Encoding",

"X-NetworkStatistics": "0,4194720,0,0,49,24442,24442,14594",

"X-SharePointHealthScore": "1",

"X-MS-SPConnector": "1",

"X-SP-SERVERSTATE": "ReadOnly=0",

"DATASERVICEVERSION": "3.0",

"SPClientServiceRequestDuration": "813",

"IsOCDI": "0",

"X-DataBoundary": "NONE",

"X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",

"X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",

"SPRequestGuid": "[REDACTED]",

"request-id": "[REDACTED]",

"MS-CV": "[REDACTED]",

"SPLogId": "[REDACTED]",

"Alt-Svc": "h3=\":443\"",

"Strict-Transport-Security": "max-age=31536000",

"X-Frame-Options": "SAMEORIGIN",

"Content-Security-Policy": "[TRUNCATED FOR BREVITY]",

"MicrosoftSharePointTeamServices": "16.0.0.26330",

"X-Content-Type-Options": "nosniff",

"X-MS-InvokeApp": "1; RequireReadOnly",

"P3P": "[TRUNCATED]",

"X-AspNet-Version": "4.0.30319",

"X-Powered-By": "ASP.NET",

"x-ms-environment-id": "[REDACTED]",

"x-ms-tenant-id": "[REDACTED]",

"x-ms-subscription-id": "[REDACTED]",

"x-ms-dlp-re": "-|-",

"x-ms-dlp-gu": "-|-",

"x-ms-dlp-ef": "-|-/-|-|-",

"x-ms-mip-sl": "-|-|-|-",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "false",

"x-ms-apihub-obo": "false",

"Date": "Wed, 20 Aug 2025 01:50:59 GMT",

"Content-Type": "application/json; charset=utf-8",

"Expires": "Tue, 05 Aug 2025 01:50:59 GMT",

"Last-Modified": "Wed, 20 Aug 2025 01:50:59 GMT",

"Content-Length": "770"

"body": {

"@odata.nextLink": "https://

"value": []

}

From what I understand, the line in the body: "value": [] indicate nothing was found, but there are files in the folder I specified. There are spaces in the folder path, and I have also tried pasting the path with the %20 for spaces but that didn't help.

Below screenshot shows the advanced parameters currently set:

and this is the Code View:

{

"type": "OpenApiConnection",

"inputs": {

"parameters": {

"dataset": "https://[REDACTED].sharepoint.com/sites/Parts",

"table": "[REDACTED_GUID]",

"folderPath": "/Parts Documents Library/Parts Inventory/Account Processing/Nicks Test Folder/P00EM-131150/Ready for signing"

"host": {

"apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",

"connection": "shared_sharepointonline",

"operationId": "GetFileItems"

}

"runAfter": {

"Initialize_variable": [

"Succeeded"

]

}

Are there any tricks to getting this to work?

Thanks

Nick

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Ellis Karim 11,725 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

We need more details to help you! Please share a screenshot of your flow, showing the configured actions. If there’s an error, tell us which action failed and include the error message. This will help us understand the issue and provide a solution faster. Thank you!

I think you are saying that the Gile Files (properties only) action is not returning or finding files you were expecting?

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
eromerof 54 on at

Like (1)

Report
Copy link

Link copied!

Hello,

We need more details to try to help you. If you can capture the details in the output of get files and the input of the step Add documents to an envelope I think that's perfect. Remember hide sensible information

Thank you!

Was this reply helpful? Yes No
NC-19080650-0 13 on at

Like (0)

Report
Copy link

Link copied!

Thanks @eromerof & @Ellis Karim, I have added some of the raw input and raw output to the original post, for the critical step that isn't working. Appreciate any tips you can provide in helping getting this step to output the files saved in the folder.

Was this reply helpful? Yes No
Ellis Karim 11,725 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Did you use a filter query in the "Get_files_(properties_only)"?

Please show how this action is configured:

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
NC-19080650-0 13 on at

Like (0)

Report
Copy link

Link copied!

@Ellis Karim thanks for your ongoing interest in helping me, I have added that info to the original post. I am not using that field to filter the query. Any assistance you can give me would be most appreciated. Nick

Was this reply helpful? Yes No
Ellis Karim 11,725 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I created a test document library called Parts Document Library and re-created the same folder path. My test flow ran as expected, finding all the files in the document library.

I suspect that the path specified in the Get Files action is incorrect, or that the wrong document library (e.g. Test or UAT library) was selected.

Please confirm the Document library and Path and content:

Another test: Shorten the path to something like

/Parts Documents Library/Parts Inventory/Account Processing/

does this return any content? The Included Nested Items option when set to true (by default it is set to True) will return content from the sub folders under /Parts Documents Library/Parts Inventory/Account Processing/

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Verified answer

NC-19080650-0 13 on at

Like (0)

Report
Copy link

Link copied!

In the end, the fix was made in the Settings tab, under Networking, I switched on Pagination and set the threshold to 5000.

3 people found this reply helpful.

Was this reply helpful? Yes No