About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

  • 30 March 2023
  • 9 replies
  • 195 views
Churds
Userlevel 1

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!

 

 

icon

Best answer by Danvers 3 April 2023, 15:14

View original
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
Userlevel 7
Badge +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
Userlevel 4
Badge +6

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
Userlevel 1

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
Userlevel 4
Badge +6

Hi @Churds 

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

Churds
Userlevel 1

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
Userlevel 7
Badge +12

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
Userlevel 1

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!

ken.a
Userlevel 7
Badge +6

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
Userlevel 7
Badge +12

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

Terms & Conditions