Replace Blank\Null values on datatable

made it and it is finally working (minimized to 40 columns)! :slight_smile:
but now i tried to run with the multiple records (~10K) and it is running for over 30 minutes already… any way of expediting?

In which part does the run time took longer? Is it on reading the excel file? If yes, then I think it is only normal reading a record with 10,000 rows and 40/65 columns. Also, try to use Clear Data Table on the data table that are not being used anymore, put the Clear Data Table activity after the last activity that Data Table was used.

“Add list items” for 15,000 records into Sharepoint takes a few hours… this is where I’m failing now…

thanks!