Hello everyone,I need to delete some records from an excel in SharePoint and update some fields in others.I have thought about downloading, saving to DB and doing it there and then generating Excel again and uploading it to SharePoint, but do you know of any way to do it directly, without having to save to DB?thanks greetings
Discussion posts and replies are publicly visible
Hi auroraj5980 I think we don't have any direct method to do it. As you said you need to download the document and temporarily store it in appian. Use some staging table to modify the data when upload the file again, make the changes edit/delete the records and save into DB. Always have a copy of deleted records, because the records which are deleted might also be deleted in sharepoint.