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.

Does anyone know how to build a look up table, using the 1st list for keys and a 2nd list for values?

For instance:

  1. [“Start Date”, “Allergies”, “Allergy Details”]
  2. “02/01/2021”, ”Yes”, “No pork”]

The Zap should convert these lists to this lookup table, where I can look up key=“Allergies” and get output=“Yes”:

  • Start Date: 02/01/2021
  • Allergies: Yes
  • Allergy Details: No pork

@helenmerlin - You might want to give a try to one of my custom integrations. You can use it to achieve what you described above. Check out the screenshots below.

Invite Link: https://zapier.com/developer/public-invite/124523/97233f2cc2b7cc0a321afdc3e77de0b3/

 

 

 

Wow @ikbelkirasan thank you so much! What an elegant solution 🙂 Very grateful to have you around as a moderator :pray_tone2: Happy new year!

@helenmerlin - You’re welcome! Happy new year to you, too :)

@ikbelkirasan can you modify the Transform tool so that if the Key list and Value lists are empty or (null), the Zap will still complete with (null) value? I don’t want it to fail and stop the entire Zap

@helenmerlin - Sure, can you try again and let me know if it’s working as intended?

@ikbelkirasan it’s not working yet. Here is the screenshot of input & output. Thank you!

 

@helenmerlin - Thanks for the feedback! Can you refresh the page then try again?

@ikbelkirasan it works like a charm! You rock! :smile:

@helenmerlin - Haha great! Glad I could help :)

Terms & Conditions