This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is there a way to use Alteryx to take an output file with a handful of records and remove list items from SharePoint that match one of the fields in that file? Seems limiting to only be able to append or Update the content of a record.
Perhaps I can figure out a way to tag the records as needing to be removed and then run an MS Flow to remove any records with certain criteria?
One thing that you could try is to read in your Sharepoint list with the SharePoint List Input putting a Block Until Done tool after it to make sure all records are read in before proceeding, read in the list of records you want to remove, Join them together on a common field, then take the unjoined records from the Sharepoint Input and write those back out to your SharePoint lists using the SharePoint List Output tool using the Delete List and Append option.
Would suggest testing this on a test list to make sure it is working as expected before applying to your actual list. (you can ignore the error in the screen shot below, i just didn't configure the tool)
Peter Stoddard Premium Support Advisor Alteryx, Inc.