Thanks for sharing the screenshot!
The error message 'Some record IDs specified were not found' in the table means the Pipeline is trying to update a record that doesn’t exist in the target table. That usually happens when the Upsert step is set to “Update only,” but the matching value (like a Record ID or key field) isn’t found.
Here are a few steps to help resolve this:
- Matching Field in the Upsert Step
- Open the Upsert step and confirm which field it’s using to find matching records (e.g., Record ID#, a custom key field, etc.).
- Make sure that value exists in the destination table.
- Upsert Mode
- Is the Upsert set to “Update only”? If so, and there’s no matching record, it will error out.
- If it makes sense for your use case, try switching to “Update or Add”.
- Review Input Values
- In the run history, click into the “Input” section of the Upsert step.
- Look at the value it’s trying to match — does that Record ID (or key) exist in the table?
Let me know what you find or if you already checked these items.
