Skip to main content
Answer

Multi-select field not returning output during testing

  • September 27, 2024
  • 16 replies
  • 85 views

Forum|alt.badge.img+1

I am trying to bring data from a multi-select field into Jira to create a new issue that also has a checkbox field to match.  I’m using Formatter/Utility/Lookup Table.  It is registering the input but nothing is coming back on output.  Any reason?

 

 

 

Best answer by johanna5

Figured it out - I am good now @Troy Tessalone .  The Two or More coming from the form has a space in front of Two.  I fixed that and I’m seeing it.  Really appreciate you!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

16 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 27, 2024

Hi @johanna5 

For us to have more info, post screenshots showing how your “Configure” section is configured.

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 27, 2024

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 27, 2024

The right is the Jira ID for that selection


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 27, 2024

@johanna5 

Can you post screenshots showing how the data is returned from Step 1 for the Lookup Key variable?

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 27, 2024

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 27, 2024

@johanna5 

Ok, since that is a comma separated string of text, you’ll need to add another Formatter step to convert the string to line items.

  • Formatter > Utilities > Text to Line Items

Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 28, 2024

@Troy Tessalone  do I add that before or after the formatter - utilities - lookup table?


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 28, 2024

Ok I put it before the step above, here is the input/output.  Its still only recognizing one of them:

 

 

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 28, 2024

@johanna5 

How is your Formatter > Utilities > Lookup Table step configured now?

It should have the output variable mapped from the new Formatter > Utilities > Text to Line Items.


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 28, 2024

So here is the Race - Text to Line configuration:

 

When I test that step, the output shows the two selections:

Then, when I get to configure the next step, I use that text to line in it:

 

But when I test it, it only pulls back the first one in the output.  The Data in pulls in both though.

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 28, 2024

I think I just spotted the issue!  I spelled Two “of” More Races wrong….it should be an “or”.  Going to try that now :) 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 28, 2024

@johanna5 

You have a typo.

It says: Two of More

It should say: Two or More

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 28, 2024

@Troy Tessalone So I fixed that typ but still not pulling back both???

 

I tried refreshing things but nothing...


Forum|alt.badge.img+1
  • Author
  • Beginner
  • Answer
  • September 28, 2024

Figured it out - I am good now @Troy Tessalone .  The Two or More coming from the form has a space in front of Two.  I fixed that and I’m seeing it.  Really appreciate you!


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 29, 2024

@Troy Tessalone  Ran up against a similiar situation with the multi-select not returning both selected values in Jira.  The text to line step has the output I’m looking for:

And when I use that output in the next step, it pulls it in just fine:

Here’s the config for this step too;

But then the output only returns the first value:

I’ve checked the mapping is correct.  

 

Here are the logs for the POST on the last step:

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • September 30, 2024

I started a new thread with the above question and will mark the answer Troy already gave as best.