Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Failed to create a person or organization field value in Affinity: Please select a valid list entry

Churds

Hey,

 

I’m trying to automatically add typeform responses to a list in Affinity. I can successfully pull the data from Typeform to create the entity in Affinity, fill in the mandatory global Affinity fields and add it to the desired list but when I try to update the fields in that list in the next step I keep getting an error (see below). I’m not sure why it can’t find the right entity in the list to update. I’ve tried using the Organisation name, the Organisation ID, the list ID and the entity ID (all taken from previous steps in the zap) but I get the same error about selecting a valid list entry. Any help would be really appreciated!

 

 

Best answer by Danvers

Hi @Churds!

What do you see if you click on the dropdown list for List Entry? That will tell you what you need to use to tell that step which entity to update. 

 

In the example below, you would need to use the ID of the customer (eg if you wanted to update Brian Eno, you would use the ID 532).

 

If you look at the dropdown values for the List Entry field and you see a list of organizations with the organization ID, let us know (because you’ve tried that and got an error). 

 

​I hope that's clear, please let us know if you have any questions!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Churds 

Good question.

Please post detailed screenshots with how your Zap step is configured to give us context, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Brem
Forum|alt.badge.img+6
  • BremZapier Staff
  • Zapier Staff
  • 404 replies
  • March 29, 2023

Hi @Churds 

Welcome to the Community! I'm sorry you’re having trouble with your Zap.

Can you please send screenshots of your Zap setup so we’ll know if there’s something wrong with the fields?

We’ll keep an eye out for your response.

Churds
  • ChurdsBeginner
  • Author
  • Beginner
  • 3 replies
  • March 30, 2023

Hey, thanks for the quick responses. Various screenshots below - let me know if you need any more.

First, the overall steps of the zap. Everything is working except step five.

I had tried skipping steps two and three and just automatically adding an organisation to the list but ran into some issues. I think this is because the list has one mandatory field that needs to be completed when a new org is added so using steps 2 and 3.
 

So step 2 adds the org to Affinity. Step 3 updates the mandatory field that’s needed before adding it to the specific list. Step 4 adds it to the pipeline list. Step 5 is then supposed to allow me to update the list specific fields for that org in the pipeline list.

 

 

Step five looks like this - I’ve cut off the 10s of fields that could be updated by the zap to save space. I’ve only filled in one text field so far as I just wanted to test if it worked at all but unfortunately no success.

 

 

This is where I’ve tried various different “list entry” options. In the screenshot you can see that I’ve chosen the organisation ID from step four when it was added to the target list.

 

Then when I run the test it gives me the error below.

 

 

Brem
Forum|alt.badge.img+6
  • BremZapier Staff
  • Zapier Staff
  • 404 replies
  • March 31, 2023

Hi @Churds 

It seems like you’re on the right track. I want to know, what is your plan in Zapier?

Churds
  • ChurdsBeginner
  • Author
  • Beginner
  • 3 replies
  • April 2, 2023

Hey Brem,
I’m currently on the free plan - I’m aware this doesn’t allow multi-step zaps but I wanted to make sure the zap actually worked before upgrading.

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • Answer
  • April 3, 2023

Hi @Churds!

What do you see if you click on the dropdown list for List Entry? That will tell you what you need to use to tell that step which entity to update. 

 

In the example below, you would need to use the ID of the customer (eg if you wanted to update Brian Eno, you would use the ID 532).

 

If you look at the dropdown values for the List Entry field and you see a list of organizations with the organization ID, let us know (because you’ve tried that and got an error). 

 

​I hope that's clear, please let us know if you have any questions!

Churds
  • ChurdsBeginner
  • Author
  • Beginner
  • 3 replies
  • April 3, 2023

Hey Danvers - you’re my hero! I’ve got it working now 😁

Screenshots below for reference:

This is what List Entry showed.

 

So I needed to use the composite ID

 

Now it’s working exactly as planned!

Danvers
1 person likes this
  • Danvers
    Danvers
ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6519 replies
  • April 3, 2023

Hey there @Churds,

Glad to know you were able to get it sorted with the help of my colleague Danvers! 🎉

If you have any other questions, please don’t hesitate to reach out. We are always happy to help! 😊

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • April 4, 2023

Woo! I’m glad that worked for you, @Churds :) 

Terms & Conditions