# Lookup column as a source for component

**URL:** <https://community.glideapps.com/t/lookup-column-as-a-source-for-component/8504>\
**Category:** Ask for Help\
**Created:** [May 5, 2020, 11:49am UTC](https://community.glideapps.com/t/lookup-column-as-a-source-for-component/8504 "2020-05-05T11:49:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Swellart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swellart/32/6118_2.png) [@Swellart](https://community.glideapps.com/u/Swellart)\
**Post date:** [May 5, 2020, 11:49am UTC](https://community.glideapps.com/t/lookup-column-as-a-source-for-component/8504/1 "2020-05-05T11:49:14Z")

</div>

Hello, I get the User Phone number from the User sheet to another one with the lookUp column. Now I want to set a lookup column as a source for the phone component but I can’t see it in the drop-down list.  
What’s wrong?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 5, 2020, 12:39pm UTC](https://community.glideapps.com/t/lookup-column-as-a-source-for-component/8504/2 "2020-05-05T12:39:06Z")

</div>

Is your relation a single or multiple relation?

Have you tried using the new user profiles feature, so you do’t have to use a relation an lookup?

> [@Insert User Data ANYWHERE in your App!](https://community.glideapps.com/t/insert-user-data-anywhere-in-your-app/8460):
>
> Saw these in the Glide data editor for the first time today. Both EXTREMELY helpful: 1. Probably not new, but it’s the first time I had to use it: Rollup \> Count True Use Case: Getting count if true to divide by total to establish a % complete. [Screen Shot 2020-05-04 at 1.38.00 PM] 2. Definitely new: Getting User Profile Data in the Template Column! Use Case: Too many to count! Bring in User Profile Data into ANY tab!!! This is now the best way to achieve all that has been mentioned in th…

---

<div class="post-metadata">

**Author:** ![Swellart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swellart/32/6118_2.png) [@Swellart](https://community.glideapps.com/u/Swellart)\
**Post date:** [May 5, 2020, 3:31pm UTC](https://community.glideapps.com/t/lookup-column-as-a-source-for-component/8504/3 "2020-05-05T15:31:46Z")

</div>

My relation is multiple (I have to match many to one).  
Regarding the new user profiles feature - it’s really great one but In my case, I don’t see how to use it. I need to get the phone of the user who placed the order. In order-form, I get the user’s email as a special value and after in order sheet with the user’s email relations and lookup, I get the phone of every client placed an order. Finely I want to put the phone component together with all other order information on the screen for the shop’s manager…  
So I tried to indicate the lookup column as a phone source for the component but I can’t see it in the drop-down list of available columns…

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 6, 2020, 1:49am UTC](https://community.glideapps.com/t/lookup-column-as-a-source-for-component/8504/4 "2020-05-06T01:49:50Z")

</div>

A lookup for a multiple relation is going to return an array of multiple values. You can’t place a multiple value array into a single value component.

> [@New Tabs are not showing](https://community.glideapps.com/t/new-tabs-are-not-showing/3752/13):
>
> You can’t fill a single value component value with a multiple value array. Plus, is that an array column or a relation column in your first screenshot? Relation columns contain entire rows of data. Not columns. You would need a lookup column attached to that relation, and even then the relation would need to be a single relation for you to use the lookup column in the component.
