Extract Excel file names into Sharepoint List

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

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

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

4. 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

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