I’m running an issue when setting up a multi-step zap where a Table Lookup output is not giving the expected outcome when I pass in multiple line items.
Here’s the flow I’ve created:
- New Google Form response (Trigger)
- Text to Line-item formatter converts comma delimited field from Google Form spreadsheet to line items
- Lookup Table formatter converts text values from the line items to id numbers, so they can be passed into Pipedrive
- Create organization action for Pipedrive, passing the converted line items into a multi-select field
Here are some screenshots that I think will be helpful:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/3d1db505-782c-4886-b01b-f873731fb912.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/0c24cf9a-5d8d-4260-b305-34dbc18bec32.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/e45628c8-d600-4e40-933f-b7c18823af34.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/f4bb279e-998f-4a5d-98c7-bbc4238c821c.png)
The “Event Planner” value is getting converted to “9” as expected. However, the “Florist” option is resulting in an empty value, when I would expect it to output “10” based on the Lookup Table.
Am I missing something here?