GetFiles(Properties Only) - Wierd Behavior - Not Working

(1) Share

Report

Posted on by CU08042159-0

Hello, Extremely frustrating but here you.

Sharepoint Library: Time Sheets

Time Sheets has 2 Sub Folders: Archive, Processing. Archieve Has Many Subfolders.

Library/All Folders only has Excel Files - xlsm.

I created a Power Automate Flow. & Step that is Failing is GetFiles(Properties Only) -- Its not returning any data. Configured as Follows:

Site Address: Sharepoint URL

Library: Time Sheets

Limit Entries To Folder: /TimeSheets/Processing

Include Nested Items: No

Filter Query: Blank

Order By: Blank

Top Count: 1

Limit Column by Views: Blank

There are files in /TimeSheets/Processing. I can physically see them. It should return one file from /TimeSheets/Processing folder but it returns NULL

However; if I make the following two parameters Nulll

Limit Entries To Folder: Blank

Include Nested Items: Blank

It returns data from Archive Folder which is the 1st folder listed in Time Sheets library, sub-folder 2018 which is also the first folder listed within Archive folder and returns a file whose name is starts with A. So it seems like for whatever reason it is going by sort order. The probelm is that if I define the parameters for Limit Entries To Folder: /TimeSheets/Processing & Include Nested Items: No, I get no data.

Can you help!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

@CU08042159-0 Fun fact. The Get Files (properties only) returns folders as well. You need to use a Filter Query to return Files only. Refer to this YT Short. Additionally, this action will limit the number of returned files and folders to 100. If you have more than 100 files and folders (combined) in your doc library, you need to toggle on pagination.

In the meantime, you might be interested in these YT Tutorials:

5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:
✓ How to troubleshoot a false Condition action result
✓ How to get dynamic content when it isn’t selectable from the list of dynamic content
✓ How to troubleshoot an Apply to Each action that isn’t looping through
✓ How to troubleshoot a skipped Apply to Each action
✓ How to troubleshoot a Filter Query
✓ How to use a SharePoint yes/no column in a Filter Query
✓ How to use Compose actions to troubleshoot a Power Automate flow
✓ How to troubleshoot multiple emails being sent
✓ How to troubleshoot multiple Teams messages being sent

If you still run into issues while building your flow, share screenshots of your full flow and the logic behind it. Upload a screenshot of your flow in edit mode. If you are using the new designer, toggle it off and click each action to expand it.

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
BD-15041227-0 2 on at

Like (0)

Report
Copy link

Link copied!

You didn't answer the question.

I had the same issue. When trying to use the GetFiles properties function.
I found that the only way to make this work is to have the IncludeNestedItems as blank. Selecting either Yes or No returns nothing at all.

Was this reply helpful? Yes No