cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Moving data from excel sheet to a share point list

I have an excel sheet that has 6000 rows of data. I want to be able to take this excel sheet and be able to upload it to an already existing share point list.  I have tried doing get a row excel connector and create item connector but It keeps giving errors. Not sure if I am using the wrong connectors for this task. 

4 REPLIES 4
Highlighted
Super User
Super User

Re: Moving data from excel sheet to a share point list

Hello,

Could you please share a screenshot of the error you are getting? A picture of the flow would be awesome as well.

Thanks




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Helper III
Helper III

Re: Moving data from excel sheet to a share point list

@Jcook 

 

I was working on it a bit yesterday it has become a mess lol Now I can't even get it to save b/c the key column is wrong. But the basic idea was to go into the excel sheet, get the rows and then create a new item within my sharepoint list

 

 

2019-11-19 08_46_11-Window.png

Highlighted
Super User
Super User

Re: Moving data from excel sheet to a share point list

Hi, and good morning.

On your excel action. Click the three dots and go to settings. Turn on pagination, and set the amount of records in there. By default excel will only handle 250 or something close to that number.

Let me know if that works.

-Josh

If my post was useful please consider liking my post. If my post solves your issue please mark my post as a solution to help others. Thanks.




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Helper III
Helper III

Re: Moving data from excel sheet to a share point list

I checked for that settings but it doesn't exist on the excel connector.

2019-11-19 10_11_21-Window.png

I made some progress and got it to upload to my sharepoint list however I have an issue with uploading my dates.

It says String was not recognized as a valid DateTime.

I tried changing the format of my sharepoint list column from date and time to single line of text and it lets me import data but the date with be wrong and say like 43730. I

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (11,671)