The overall purpose of the flow is to add the appropriate metadata to the corresponding columns based on the name of the document located in an Excel file.


  1. The flow is initiated manually.
  2. Upon launch, the flow uses the "List rows present in table" action to retrieve the items in the table from an Excel file stored in a document library.
  3. Next, it uses the "Get items"/"Get Files Property only" action to fetch the items in a document library.
  4. It then applies an "Apply to each" action to process the values from the "Get items" action.
  5. Another "Apply to each" action is used to process the values from the "List rows present in table" action.
  6. The flow then employs a "Condition" action inside of the second "apply to each" to check if the name field in the Excel file matches the name in the document library.
  7. If the names match, the flow updates the corresponding fields in the metadata columns.

The issue arises when the flow attempts to find the files in the "Get items" action. Although the site address is correctly specified, it requires using the "Enter custom value" option when I use Get Items. It finds the library perfectly fine when using the Get Files Property only action. However, When I export the out put or use compose to see what its returning in that step, It goes the the library and exports the directories with out the file names.

Example: {Link}":"https://company.sharepoint.com/sites/Blah Blah/Documents%202/03%20Guidelines","{Name}":"03 Guidelines","{FilenameWithExtension}":"03 Guidelines"

Documents%202 is the name of the document library essentially Documents 2

03%20Guidelines is the name of the folder the file is inside of it.

In the library there are several nested folders.

The files are located in each folder and "Include Nested Items" option is on.

The out come im trying to get is for either the get items action or the Get files by property action to return the file names so I can check if they are a match to the ones listed in an excel file. If they do match I want it to use the excel file to update the metadata columns.

I was able to accomplish this in mydev environment using the steps above and nested some documents one folder below. the solution worked but in the production environment its only pulling the path not the file name.

enter image description here

enter image description here

1 Answer 1


You are using list actions on a document library. That will not work.

List actions work only for lists.

Instead of "Get items", you need to use the library action "Get files (properties only)". Then you can continue with the Apply to each for the output of that action.

When you want to update the file properties, you need to use "Update file properties" and identify the file by its SharePoint list ID, which is returned by "Get files (properties only)".

  • If that resolved your issue, please mark the answer as described in the tour. If it didn't, please leave a comment, so I can follow up.
    – teylyn
    Commented Jun 19 at 4:30
  • I tried Get Files (properties only) and got the same results before but I will try again with "update file properties". Ill message back if it works.
    – Mile T.
    Commented Jun 19 at 18:19
  • I'm attempting to get all the document properties in s SPO document library. In Power automate I use Get file (properties only). In the document library there are several folders. The Get file (properties only) is only returning the folder names not the names of the files inside. I need the flow to look into the document library past the folders and get the name of all the documents inside
    – Mile T.
    Commented Jun 20 at 0:33
  • what is your filter criterion for Get file (properties only)? do you want to return from a specific folder only?
    – teylyn
    Commented Jun 20 at 4:22
  • Right now I have Get file (properties only) pointed to the library I want to pull all the names of the documents inside . I have include nested set to yes but no current filter queries set.
    – Mile T.
    Commented Jun 20 at 17:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.