0

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?

2
  • Do you mean you have a local folder with bunch of excel documents and you want their names to be stored into a SharePoint online list? Recurring activity or one time job?
    – UBK
    Jan 21 at 1:34
  • Yes. Mainly, to show the names of the files in a dropdown list in SP field.
    – Madeline
    Jan 21 at 15:05
0

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

2
  • Thank you, but I don't have MS Flow. Only InfoPath, SPD 2010 and SP2013. Is there another way? MS Flow has to be purchased right?
    – Madeline
    Jan 21 at 15:07
  • Hi, Madeline. Yes, the best way is to use MS Flow. You could click microsoft.com/en-us/p/microsoft-flow/… to read more information. Jan 26 at 9:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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