Sharepoint Output: only able to append
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am able to connect to my SharePoint site and tried 'Create list' but receive an error only stating 'Error in creating list.', no other details.
So I manually created a list on the site, made sure the data types were the same and after connecting to it in Alteryx I am only able to use the Append option. I get the error messages below for the other options.
Overwrite:
Error: SharePoint Output (21): Request forbidden -- authorization will not help.
Update:
Primary column: [jobID]
Error: SharePoint Output (21): Bad request syntax or unsupported method.
Upsert:
Primary column: [jobID]
Error: SharePoint Output (21): Bad request syntax or unsupported method.
I would like to be able to create the list and then update or upsert the jobID if any fields change AND add new rows if they are new jobIDs.
- Labels:
- Output
- Sharepoint
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry, had to bump back up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you ever get this resolved? I have the exact same issue when trying to overwrite a list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@craigja, unfortunately, no. I ended up writing to a table and then use Power Automate to update the SP List when there is an item created or modified in the table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Did you manage to get this sorted? I'm looking at the same issue right now. I need the tool to overwrite the sharepoint list with fresh data every day and I am stuck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@danespoors I'm still working through it. I'd much rather Alteryx handle it all but the workaround is still using Power Automate.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We all know how difficult it is to truncate and reload. Quantum computing can't solve it, how could we expect Microsoft to do so? This Sharepoint tool has more problems than its worth
