I have the Sharepoint List it has data like 50k rows but I am using the delete listitem activity but its taking 9 hrs to delete the item is their any another way to delete the list item
if you want to delete all then recreating list makes sense or using ui makes sense
it would take time as you would use a loop to delete each item
cheers
Thanks for your Response
I am not using the loop i am just using delete the list Item i need to delete all the Item and add new item to the list some time its showing error like
**Delete List Items: An error occurred while sending the request. **
then why not delete the list and create a new one with same schema?
delete list items can take time…also exact exception details would be there in exception details from locals panel..if in runtime you might need to log stacktrace and innerexception to know the details
cheers
my requirement is to only delete eth list item and add the new data from the redshift table so its taking too much time but its giving some error in between is there any better way to perform this task
Thanks in Advance
Nithya
if its clearing full list then deleting list and adding can be done
if errors in between we need full error details to see what it is
cheers
the error is clear about material_number missing..check the name …display name and field names can be different
cheers
Hi @nithya.an
Per error, looks like either name(display name and internal name can be different) is not correct or you don’t have write access on the list.
I have installed the microsoft 365 package but I am not able view the Microsoft Office 365 Scope]
This is something that should be done by your Sharepoint admins, not an automation.