# Lookup Multiple Values
**URL:** https://community.glideapps.com/t/lookup-multiple-values/36752
**Category:** Ask for Help
**Created:** [January 5, 2022, 9:27pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752 "2022-01-05T21:27:13Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 5, 2022, 9:27pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/1 "2022-01-05T21:27:13Z")
When using select multiple in a choice component I’d like to lookup all the names associated to the underlying values being submitted.
So my flow is I have a choice component on a details screen where the display is a list of names and the values are pre-assigned UUIDS. If I use a split text column and then a relation match multiple I can see all the values I want but don’t know where to go from there. The end goal is to pass the values (both names and UUIDS) in the most elegant way through a webhook.
As it stands now I could submit my column holding the comma separated values through a webhook and that works for my purpose. But I also need all the names tied to those values, even if it was another comma separated list, that would work.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 5, 2022, 9:38pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/2 "2022-01-05T21:38:30Z")
maybe a few screenshots will help to understand… I’m a little lost with your explanation…
template column will not help with it?
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [January 5, 2022, 11:14pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/3 "2022-01-05T23:14:23Z")
Hola Eric,
Here thinking fast:
1- Create a Template column using “UUID - Name” format in your “Names” table
2- Using the values saved by your Choice component (separated by comma, slash, etc) create a new array as a column. Let’s call it “UUID[]” column.
3- Create a multiple relation between “UUID[]” and your “UUID” column (belonging to “Names” table) and later a new ~~Lookup Column~~ **Joined List** to retrieve the “UUID - Name” values already created above.
This should be enough to get what you want… I think 😇
Saludos!
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 5, 2022, 11:48pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/4 "2022-01-05T23:48:47Z")
Hello gvalero,
I think this is exactly how I have it set up. When you say create a new array column am I correct to use a ‘split text’ column? (Forgive me I am new to using split text)
I like yours and @Uzo suggestion of using a template column in the Names table because I can paste them both together, so I’m doing that now,
But the problem is I still can’t figure out how to use that lookup column as a value in a webhook action. Could it be because it comes from a multiple relation? Perhaps I am overlooking something simple so I will keep at it.
Thank you both for your prompt replies.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 5, 2022, 11:56pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/5 "2022-01-05T23:56:46Z")
lookup works with single and multiple relations…you cannot use multiple lookups as a value … what exactly is the problem?
if you need multiple values in one cell… use if else columns to find related values and join them
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 5, 2022, 11:59pm UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/6 "2022-01-05T23:59:45Z")
Yes I can see the lookup is returning the correct values in the editor.
But I can’t find it here as a value that can be used in a webhook.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 6, 2022, 12:01am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/7 "2022-01-06T00:01:19Z")
yes… because is multiple
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 6, 2022, 12:02am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/8 "2022-01-06T00:02:29Z")
Ok so how to create a comma separated list of my lookup values? Possible?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 6, 2022, 12:03am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/9 "2022-01-06T00:03:44Z")
no, create a workaround for relation using IF-ELSE columns and JOIN column… it is a lot of work… but if I understand better your app, I can come up with some easy solution…
the main idea is to check if values are from the user or have specific criteria, isolate them and join…
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 6, 2022, 12:15am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/10 "2022-01-06T00:15:01Z")
Hmmm I want to try to avoid app bloat… this feature is something I want but don’t necessarily need.
Let me ask you, If you had a choice component (select multiple) on a details screen how would you submit both the ‘display as’ and the values in a webhook. I’m open to reorganizing my data a bit if it saves columns.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 6, 2022, 12:21am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/11 "2022-01-06T00:21:26Z")
I’d probably build a collection of name=\>value pairs, and wrap that up as a single JSON object, then send that through the webhook.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 6, 2022, 12:23am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/12 "2022-01-06T00:23:18Z")
what is the format of your webhook?
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 6, 2022, 12:25am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/13 "2022-01-06T00:25:40Z")
That sounds like exactly what I’m looking for and also above my pay grade hehe. Do you have an example of a simple JSON being used? I will start doing my homework and run with your advice.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 6, 2022, 12:33am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/14 "2022-01-06T00:33:01Z")
@Uzo you were right all along. I should just use the template column as the values in my choice component 🤦♂️ Then I could submit the comma separated list in the webhook… that will do just fine.
@Darren_Murphy thanks for jumping in. I will do some research on using JSON because I’m sure it will be useful.
I am humbled to have so many experts come to my help. Ty all.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 6, 2022, 12:35am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/15 "2022-01-06T00:35:57Z")
that was my first impression when reading your post, but you describe your problem in a very complicated way… so I got confused 😉
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 6, 2022, 12:38am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/16 "2022-01-06T00:38:59Z")
> [@Eric\_Penn](#):
>
> I will do some research on using JSON because I’m sure it will be useful.
It’s pretty simple really, a bit like building an HTML table with several rows. You just have a template for each row, and then you combine them all together using another template.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 6, 2022, 12:47am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/17 "2022-01-06T00:47:16Z")
> [@Lookup Multiple Values](https://community.glideapps.com/t/lookup-multiple-values/36752/15):
>
> that was my first impression when reading your post, but you describe your problem in a very complicated way… so I got confused wink
Thank you for the feedback. I will try to describe my problem better in the future… and maybe even attach some screenshots 😉
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 6, 2022, 12:57am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/18 "2022-01-06T00:57:36Z")
> [@Eric\_Penn](#):
>
> and maybe even attach some screenshots
let’s not get too carried away 🤣
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [January 6, 2022, 12:58am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/19 "2022-01-06T00:58:29Z")
a picture is worth 1000 words…
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [January 6, 2022, 1:00am UTC](https://community.glideapps.com/t/lookup-multiple-values/36752/20 "2022-01-06T01:00:30Z")
> [@Lookup Multiple Values](https://community.glideapps.com/t/lookup-multiple-values/36752/6):
>
> Yes I can see the lookup is returning the correct values in the editor. But I can’t find it here as a value that can be used in a webhook.
I should have started here ☝ I realize there are no such things as stupid questions but after re-reading, that one was pretty border line… haha
[Next page](https://community.glideapps.com/t/lookup-multiple-values/36752.md?page=2)