web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate Flow: "...

Power Automate

Unanswered

Power Automate Flow: "Get files (properties only)" Returns Empty Array in Client SP Site

(0) Share

Report

Report

Posted on by AGBT900

19

Hello Community,

I’ve built a Power Automate flow that:

Triggers When a new email arrives.
Creates a folder in a SharePoint Online document library.
Saves email attachments to that folder.
Uses Get files (properties only) to list files in the folder.

The issue:

In my test environment (where I have Full Control over SharePoint), the flow works perfectly.
When migrated to the client environment, "Get files (properties only)" returns an empty array even though files exist in the folder.

What I’ve verified:

The flow creates the folder and saves attachments successfully in both environments (proves write-access works).
Folder paths and action configurations are identical between test and client flows.
The client’s SharePoint account has been granted edit permission to the library.
No filters or special queries are applied in the "Get files" action.

I am unable to understand why get files returns an empty array. Can you suggest anything to debug this problem?

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@AGBT900 Hi,

If you create a minimal flow, manual trigger + Get files (properties only) , will you get any result if run as the client account ?

Was this reply helpful? Yes No
AGBT900 19 on at

Like (0)

Report

@stampcoin Yes, the flow returned values when I created a separate flow in Client's Acc.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@AGBT900 Hi,

Since the minimal flow works. It might be a delay problem.

Please try below one of them:

Option 1:
Trigger: When a new email arrives Create folder Save attachments Delay (e.g., 60 seconds) Get files (properties only)

Option 2:

Initialize variable (e.g., FilesFound = false) Do Until (FilesFound = true or max attempts reached): Get files (properties only) Condition: length(outputs('Get_files')?['body/value']) greater than 0 Yes: Set FilesFound = true No: Delay (e.g., 15 seconds)

Was this reply helpful? Yes No

Join the conversation