Hey ​@ElliotB,

What exact issue are you getting? Can you post the screenshots of Data in and Data out as well as any errors?

Hi ​@ElliotB 

For us to have more info, post screenshots showing:

• how your Zap steps are outlined
• how your Zap steps are configured in EDIT mode in the CONFIGURE tab with the field mappings visible

Thank you for your replies ​@Troy Tessalone ​@Sparsh from Automation Jinn . Please see below the Zap set ups. Let me know if you need more screenshots.

​@ElliotB 

Help links for understanding expected values in dropdown lists: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

TIP: Click field labels ( i ) to see tooltips with more info that may provide guidance.

The error appears to be related to the mapped variable value for the List Entry field.

Post screenshots showing the DATA OUT from Zap Step 2 related to the different IDs returned.

The step is Update an Entity (Affinity) and it’s asking for a List Entry (the row in a specific Affinity List).
In your mapping you’ve put “2. List Entries – Entity Id: 99566176.” That is the Entity ID (person/org/opportunity record), not the List Entry ID for the row in Deal Pipeline.

Because the action can’t resolve a valid list_entry for the selected list, Affinity throws the generic error:

“Failed to create a person or organization field value… Please select a valid list entry.”

Fix

• Pass the List Entry Id for the record in the Deal Pipeline list.

• If you don’t have it yet, add a search step like “Find List Entry in a List” (or “Find/Create List Entry”), then map List Entry Id from that step into List Entry here.

Also make sure the found list entry actually belongs to Deal Pipeline (IDs are list-scoped).

​@Troy Tessalone thanks for your response. Unfortunatly, we’re still seeing an issue.

This is what we’re seeing:

It doesn't seem to be finding the list entry ID:

In Step #2 - I create the opportunity. You can see that the entity exists in the Deal Pipeline and it shows the List Entry ID

In Step #3 - I search for the list entry ID and it doesn't find it

Of the possible List Entry IDs, I'm assuming it should be the List Entries ID? 217677408

The List Entries Entity ID is the ID for the organization

The List Entries List ID is the Deaflow Pipeline list ID

Creator ID - I'm assuming is me

​@ElliotB 

Give this a try for dropdown fields where you are trying to map a dynamic variable.

Switch to Static mode and try to locate the desired option from the dropdown list.

There you will be able to see the underlying option ID to help you make sense of which variable you should map when configuring as Custom mode.

Help links for understanding expected values in dropdown lists: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps

Hey ​@ElliotB,

I see how it can get a bit complex with so many IDs floating around.

But coming to the Update an Entity action in Zapier, it can either update the global or list fields of a person, organization, or opportunity. 

I was looking into affinity API to understand the Zapier integration a bit better. You can see here- https://api-docs.affinity.co/#get-a-specific-list-entry

 

I also saw more about organization id from the API which is the List Entries ID in your case- https://api-docs.affinity.co/#update-an-organization

 

Can you skip the Find the List Entry action for now and just put List Entries ID in Update an Entity action as I didn’t see in the screenshots if you have already tried it? Hope it helps!

PS: If you need more active assistance, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

Thank you ​@Troy Tessalone ​@Sparsh from Automation Jinn. Please see below for an update on the issue with several things we tried.

When I go to the static option to see what type of ID they're looking for, it looks like they're looking for the composite ID:

When I choose a specific entity from the list or when I choose the choose the Composite entity ID from the step above, I get the following error message:

I also tried to use the List Entry ID from the search step above and when I use that ID (or any of the other available IDs), I get this error message:

Here's the overview of the different IDs that are available when I search for a list entry

Thank you!!

Hey ​@ElliotB,

Couldn’t see the screenshots with the error message. Can you post them again?

In static option, you can also just type the id for now to test it. See more about it here- https://help.zapier.com/hc/en-us/articles/31709122224653-Enter-data-in-Zap-fields

​@Sparsh from Automation Jinn sure here they are:

When I go to the static option to see what type of ID they're looking for, it looks like they're looking for the composite ID:

When I choose a specific entity from the list or when I choose the choose the Composite entity ID from the step above, I get the following error message:

I also tried to use the List Entry ID from the search step above and when I use that ID (or any of the other available IDs), I get this error message:

Here's the overview of the different IDs that are available when I search for a list entry

Hey ​@ElliotB,

Thanks for the quick reply. I am talking about these particular screenshots. Somehow they are not visible-

When I choose a specific entity from the list or when I choose the choose the Composite entity ID from the step above, I get the following error message:

 

 

I also tried to use the List Entry ID from the search step above and when I use that ID (or any of the other available IDs), I get this error message:

​@Sparsh from Automation Jinn here they are again. Let me know if you can see them:

​@ElliotB, Yes they are visible now.

Hey ​@ElliotB,

Can you see the dropdown of the List Entry in configure and select a field there?


Did you also click on retest step as I think it’s still taking the previous value?

 

Is step 2 giving you the right opportunity ID to use in step 3 or just a different one ?