Power Platform Community Forum Thread Details

Get File (only properties) does not find all files

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.

Quick Links

Leaderboard > Power Automate