I was recently experimenting with Microsoft PowerAutomate and I have encountered a following issue.

I have a large Excel list that contains up to 330 rows of data. I would like to migrate that list from Excel into SharePoint. My problem here is that when I import the list into SharePoint not all of the data is visible. This basically means that some of the rows of data from the columns in Excel were inserted into the SharePoint list and some rows of data were left out.

I attach the screenshots describing the problem below:

1.Here is how some of my data looks in Excel initially

enter image description here

enter image description here

2.Here is how the list looks in SharePoint when I recreated the list. It has relevant data types and let's the user to insert relevant values into the table later on.

enter image description here

3.Here is my flow which I created in Microsoft Power Automate:

enter image description here enter image description here enter image description here

And finally here is my output(migrated data From Excel into SharePoint).

enter image description here

(The above picture and the picture below are representing the same SharePoint list. I had to divide the list into two slides though, for improved visibility.

enter image description here

As you can see some of the data from Excel is missing. Some columns have not been loaded into the Excel file even though they were specified in the flow.

If you have any idea why this might be the case please let me know.

Many thanks!

  • 1
    Hi Mateusz, this could be due to mis match between formats in Excel and SharePoint. For instance the date format in Excel doesnt match the date format in SharePoint. And the Vehicel text in Excel perhaps have a return and the correspondig field in SharePoint is a single line of text. I recommend to check the outputs of the columns.
    – RuneBH
    Jan 14 at 13:01
  • Thank you for your answer. I checked the data types and this seems to be the issue. After I changed the data types I managed to import more columns, however it was not possible to import all of the columns for some reason. 2 days ago

Your Answer

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

Browse other questions tagged or ask your own question.