I am going from excel, to a new sharepoint list, to the existing sharepoint list.
I was trying to pull in 6000 records, but even if I reduced the table to 500 records it kept timing out.īut it inspired me to a different solution.
When I tried to list rows present in table, it would timeout trying to pull up the table name. The previous solution did not work for me. If you liked my response, please consider giving it a thumbs up. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If this reply has answered your question or solved your issue, please mark this question as answered.
#IMPORT EXCEL DATA TO SHAREPOINT LIST UPDATE#
Note, if you have choice type columns, you need to update the choice value in the create item action and point to the excel column that contains the choice label.įor multiple select persons or choice type fields, you will have to create arrays and pass it in the create item action. Similarly you can point to the columns as per your datasheet to excel and sharepoint list. The person field can be updated using the email address of the users (provided they exist in the O365 users in the organization) and you need to point the relevant excel column to that particular persons column in the action (tPersons is my person type column in sharepoint and Column4 contains the email ID's of the folks) (This action gets you only 256 rows so please change the top count to the number of rows that you want to get from the excel). Here, I am using the list rows present in a table action to get the rows from the excel table.
0 kommentar(er)
