Error Understanding Help:

Aidan Lambert

I'm trying to use the “add records to list” action in power automate, but no matter what ID I use, I keep getting the a message that says “The list specified does not support appending ids”

Edit: I'm also noticing an ErrorName: ""AppendIdsToListRequestInvalidListId" but that doesn't really make sense, because I'm selecting the list straight from the drop down menu in the action.

The full error message: {"Message":"The list specified does not support appending ids","ErrorName":"AppendIdsToListRequestInvalidListId","ErrorCode":400,"RawMessage":"The list specified does not support appending ids","ErrorArgs":[]}]}

Does anyone know what this means? What kinds of lists support appending IDs? Is it a configuration option I need to change, or is related to the type of list perhaps?

Evan Webb

A couple questions: Is your list type – Constituent, Gift – consistent with the kind of record you want to add. And are you using the System ID not the Lookup ID (called the Gift ID in DB View)?

Also, Is this list already in existence? Or are you creating it fresh in the flow?

Aidan Lambert

It's a constituent list. You're question did help me recognize that my flow was using the participant's system record ID and not the system record ID of their respective constituent record, so thanks (the flow is to add new participants for an event to a list). But after fixing that error, I'm still getting the same result. So yes, the ID and list type are (now) the same.

The list is already in existence. It was created by me a couple months ago. I did check to see the permissions access on it, and it's marked as “others can manage.”

Glen Hutson

Aidan Lambert:

It's a constituent list. You're question did help me recognize that my flow was using the participant's system record ID and not the system record ID of their respective constituent record, so thanks (the flow is to add new participants for an event to a list). But after fixing that error, I'm still getting the same result. So yes, the ID and list type are (now) the same.

The list is already in existence. It was created by me a couple months ago. I did check to see the permissions access on it, and it's marked as “others can manage.”

If you're familiar with queries in DB View, just like there are Dynamic and Static queries, there are dynamic and static lists. Though you can manually add/exclude from a list created in WebView (which if you started off with filters means it's a Dynamic list), the underlying API doesn't like manually adding to Dynamic lists. I've started off by creating a list via Power Automate (which makes it a Static list) and then from then on can keep adding to it from various different flows.

Ben Lambert

Glen is correct - there are actually some types of lists that do not support appending IDs (because it conflicts with other filters on the list). I've confirmed this behavior with the team that owns this functionality, and also suggested that they update the documentation for the AppendIdsToList endpoint.