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.
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
I checked for that settings but it doesn't exist on the excel connector.
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
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!