web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get File (only propert...
Power Automate
Suggested Answer

Get File (only properties) does not find all files

(1) ShareShare
ReportReport
Posted on by 15
Hi guys,
I want to build a flow that searches a folder in Sharepoint and then uses the name to check whether certain files are present. I use the connector "Get Files (only properties)". In some folders this works well. In others nothing is found.
Like: /Shared Documents/FolderA gives several results, /Shared Documents/FolderB gives none.
Both contain subfolders and documents. I don't use any filters in the connector. What could be the problem?
 
best regards
Manuel
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
    Hi,
     
    Please share your flow, share pictures of your folders, share the inputs and outputs from a flow run.
     
  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at
    I've been experiencing this issue with the Get files (properties only) action too. It's very annoying and means you can't rely on that action. Unsure whether it's related to the total number of items in the library, but the library I have the issue with has around 220,000 files and folders with about 30,000 root folders. There doesn't seem to be a way I reliably can get an entire directory listing out of all the root folders in there using the Get files (properties only) action.
  • MB-10101330-0 Profile Picture
    15 on at
    I have built another smaller flow to give a better overview of what I want to do. It is only important that all documents are found, so that I can use the names for later comparison.
     
    I use 5 steps:
     
    1) trigger manually
    2) get files (properties only)
    3) initialize empty variable
    4) append in loop for all names and path from (2) to the variable
    5) compose.
     
    The right side of the flow is unimportant for this. But it might be interesting that "get the file metadata via path" (first on right side) provides the desired information about a file that is not found on the left side. So in principle, Power Automate can find this, but did not do so when retrieving multiple files (2) on the left side.
     
    Extract of the folders in shared documents:
     
    Both folders contain a large number of files (pptx, xml, docx, pdf...).
     
    Run 1:
     
    You can see in the first run how at least 16 files are found in the "Infoscreen..." folder. In fact, there are significantly more.
     
    Run 2:
    In the second run "Projekte" nothing is found.
     
    I have now noticed something interesting. All files found were created before 2020. Editing obviously has no effect.
    But in run 2, however, there are also files from before 2020
     
    - Output:
    [name: path, created, edited]
    Fotos: Shared Documents/Infoscreen DB Sicherheit/Fotos, 2019-05-10T09:17:03Z, 2019-05-10T09:17:03Z
     
    ViewNeo: Shared Documents/Infoscreen DB Sicherheit/ViewNeo, 2019-05-10T09:17:38Z, 2019-05-10T09:17:38Z
     
    0-0_Standort_Ansprechpartner: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/0-0_Standort_Ansprechpartner.xlsx, 2019-05-10T09:19:56Z, 2022-01-07T14:47:40Z
     
    0-01_Standortübersicht RB Süd_Korrektur: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/0-01_Standortübersicht RB Süd_Korrektur.xlsx, 2019-05-10T09:20:03Z, 2020-12-02T09:24:13Z
     
    0-02_Standortübersicht RB Südost_Korrektur: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/0-02_Standortübersicht RB Südost_Korrektur.xlsx, 2019-05-10T09:20:07Z, 2019-05-10T09:20:10Z
     
    0-03_Infoscreens-Geräteart: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/0-03_Infoscreens-Geräteart.xlsx, 2019-05-10T09:20:12Z, 2021-10-22T07:33:29Z
     
    0-6_Player einrichten: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/0-6_Player einrichten.docx, 2019-05-10T09:20:28Z, 2019-05-10T09:21:44Z
     
    1-0_DLINK Router konfigurieren: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/1-0_DLINK Router konfigurieren.docx, 2019-05-10T09:20:34Z, 2022-12-07T13:01:58Z
     
    1-01_DWR-921_man_revb_Handbuch_de: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/1-01_DWR-921_man_revb_Handbuch_de.pdf, 2019-05-10T09:20:43Z, 2019-05-10T09:20:47Z
     
    2-0_Anschluss LTE Router und MiniPC: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/2-0_Anschluss LTE Router und MiniPC.docx, 2019-05-10T09:21:06Z, 2024-04-19T12:18:25Z
     
    3-0_Infoscreen Informationen: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/3-0_Infoscreen Informationen.xlsx, 2019-05-10T09:21:17Z, 2024-07-04T11:45:55Z
     
    4-1_Anlegen von Benutzern: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/4-1_Anlegen von Benutzern.docx, 2019-05-10T09:23:40Z, 2019-05-10T09:23:45Z
     
    4-2_Hinweise zur Erstellung von Folien oder Web-Seiten: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/4-2_Hinweise zur Erstellung von Folien oder Web-Seiten.docx, 2019-05-10T09:23:48Z, 2019-05-10T09:23:51Z
     
    Passwort: Shared Documents/Infoscreen DB Sicherheit/ViewNeo/Passwort.txt, 2019-05-10T09:23:50Z, 2019-05-10T09:23:51Z
     
    Infoscreen Folien: Shared Documents/Infoscreen DB Sicherheit/Infoscreen Folien, 2019-06-27T06:12:31Z, 2020-01-13T13:43:02Z
     
    Infoscreen_Hotline: Shared Documents/Infoscreen DB Sicherheit/Infoscreen Folien/Infoscreen_Hotline.pptx, 2019-06-27T06:12:35Z, 2019-06-27T06:12:37Z
     
    Could it have something to do with the date? I hope this information helps to better understand the problem.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard