Extract Excel file names into Sharepoint List

SharePoint Asked by Madeline on February 13, 2021

I have SharePoint online 2013 and workflow 2010.

I have a list of excel files that I’d like to extract the names into SharePoint List.

Is it possible?

One Answer

SharePoint 2010 workflows have been retired since August 1, 2020 for new tenants and removed from existing tenants on November 1, 2020. It is recommended that you use MS Flow (Power Automate).

Please follow steps:

  1. Upload Excel files to SharePoint Documents Library

enter image description here

  1. Create a List named "Excel List" to store Excel file Title

  2. Go back SharePoint Documents Library, click ▪▪▪ >> Automate >> Power Autonate >> to create a flow

enter image description here

  1. Workflow Steps:
  • Add the "When an item is created or modified" Trigger
  • Add the "Get files (properties only)" Action
  • Add a Condition: [Get files (properties only)] Title contains xlsx
  • on the "If yes" branch, add the "Create item" Action

enter image description here

  1. Save and Test this flow. And go to the "Excel List" page, you will view page screen as shown in the figure below:

enter image description here

Answered by EchoDu_MSFT on February 13, 2021

Add your own answers!

Related Questions

Create Folder and Upload File to Document Library

1  Asked on November 21, 2021 by chris-harrington


How to create list to track documents uploaded

1  Asked on November 17, 2021 by bstock


when try to open a MS project file, getting an issue.

2  Asked on November 15, 2021 by achiever-sp


Content Search WebPart: query Date and Time field

2  Asked on November 13, 2021 by akshay-dattatray-nangare


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP