1

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

1

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

6
  • what is the name of the flow template that we need to use here? Mar 13 '20 at 9:17
  • Currently there is no official template to meet your requirement, it's customized steps for your reference.
    – Julie_MSFT
    Mar 16 '20 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? Mar 18 '20 at 8:09
  • Add an asterisk before date in excel,such as *3/18/2020
    – Julie_MSFT
    Mar 18 '20 at 8:49
  • tried with *3/18/2020 still not accepting the format. @Julie_MSFT Mar 18 '20 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.