We have a requirement that when an excel file will be uploaded into SharePoint document library, all its data should be captured and should be moved to separate lists accordingly.

for example: if we have two fields called "user" and "user access" in excel then after uploading of excel file into SharePoint library, "users" field values should be created in a separate "users" list and "user access" field values should be created in access list of SharePoint. How to extract those details? Is workflow can do that or any other way?

below is the sample input of excel file to be uploaded:-

enter image description here


Here are steps for your reference:

Step1: Format the excel file as table refer to this article, the result looks like this: enter image description here

Step2:Create a flow to list rows present in a table, apply to each to cycle the table and create new item in different lists using differnent column name.

enter image description here

  • what is the name of the flow template that we need to use here? – Adarsh Awasthi Mar 13 at 9:17
  • Currently there is no official template to meet your requirement, it's customized steps for your reference. – Julie_MSFT Mar 16 at 1:05
  • flow is working fine now but failing while getting a Date field from excel table as it is considering that as a string? Could you please let me know how to avaid this issue? – Adarsh Awasthi Mar 18 at 8:09
  • Add an asterisk before date in excel,such as *3/18/2020 – Julie_MSFT Mar 18 at 8:49
  • tried with *3/18/2020 still not accepting the format. @Julie_MSFT – Adarsh Awasthi Mar 18 at 10:08

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.