Share via

No files returned from Get files (properties only) when folder contains parentheses

Tollefson, Kevin 20 Reputation points
2023-09-25T14:24:47.8866667+00:00

I have a Logic App created that is meant to collect data on files that have been uploaded to SharePoint. I have a "Get files (properties only)" which only returns folders. Then the process loops through all the folders, again calling the "Get files (properties only)" to get information on all of the files in those folders.

My issue is with folders that have a parentheses in the folder name. I know that there are files within these folders, but the "Get files (properties only)" returns nothing:
User's image

How do I get the properties of files within this folder?

Azure Logic Apps
Azure Logic Apps

An Azure service that automates the access and use of data across clouds without writing code.

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jomon Abraham 40 Reputation points
    2025-08-26T01:59:39.2366667+00:00

    Below workaround (suggested by AI) worked for me.

    • Enable and Adjust Pagination:
      • Navigate to the settings of the "Get files (properties only)" action.
      • Enable the "Pagination" option.
      • Set a higher "Threshold" value (e.g., 5000, 10000, or even higher, depending on the number of files). This is a common solution for libraries with many items.

    8 people found this answer helpful.
  2. Nuno Nogueira 76 Reputation points
    2025-02-06T12:27:27.2733333+00:00

    This is a bug. It's also not working for me.

    2 people found this answer helpful.
  3. Tietze, Oliver 5 Reputation points
    2026-01-07T07:12:09.53+00:00

    @Tollefson, Kevin & @MayankBargali-MSFT A bit late to the discussion, but I recently encountered a very similar issue and wanted to share a possible explanation and workaround.

    I have a Power Automate flow that uploads files to a SharePoint document library on a daily basis. The upload itself continued to work as expected. However, another part of the solution relied on “Get files (properties only)” with “Limit entries to folder” enabled.

    From one day to the next, this action started returning no results, even though the target folder clearly contained files and no changes had been made to the flow. When I enabled pagination, the action began returning partial results, but still not the complete set of files.

    This behavior led me to suspect a limitation related to the size of the document library. After further investigation, it turned out that the library had crossed the 5,000-item threshold, which can cause inconsistent results when listing files using the SharePoint connector.

    As a workaround, I replaced the connector action with “Send an HTTP request to SharePoint” and queried the folder contents directly using the SharePoint REST API:

    Method: GET
_api/web/GetFolderByServerRelativeUrl(
  '/sites/<SITE_NAME>/<DOCUMENT_LIBRARY>/<FOLDER_PATH>'
)/Files?$select=Name,ServerRelativeUrl,TimeLastModified,Length

    This approach reliably returns the complete list of files in the specified folder and avoids the issues observed with Get files (properties only) in large document libraries.

    Hopefully this helps anyone running into similar behavior when working with SharePoint and Power Automate.

    1 person found this answer helpful.
    0 comments
  4. MayankBargali-MSFT 71,001 Reputation points Moderator
    2023-09-26T14:36:05.81+00:00

    @Tollefson, Kevin Thanks for reaching out. Make sure that you have Include Nested Items property to Yes and not as No so the nested element is returned. By default, the value will be Yes (true). Can you also confirm if you have set any other property in your action? I will also suggest you to navigate to your folder that you have specify and validate if there are any files in the nested folder. I had the tested same at my end and didn't observe any issue.

    You can see with the below configuration it returns the nested folder files i.e. New Text Document.txt as below.

    User's image

    Let me know if you need any assistance in validating.

    Please "Accept Answer" if the answer is helpful so that it can help others in the community.

    1 person found this answer helpful.
    0 comments
  5. Sonny Gillissen 4,077 Reputation points
    2026-03-20T14:15:36.75+00:00

    Hi Tollefson, Kevin

    Thanks for reaching out on Microsoft Q&A!

    If the folder name contains special characters (like parentheses), you must supply the server‑relative path with those characters URL‑encoded, otherwise the SharePoint connector often returns an empty array:

    1. ( → %28
    2. ) → %29

    You could do this automagically by wrapping the inputs of the 'Limit Entries to Folder' in the encodeUriComponent() function.

    Please click ‘Accept answer’ if you think my answer is helpful. Feel free to drop additional queries in the comments below!

    Kind regards,

    Sonny

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.