# If then else can't select lookup with If Then Else?

**URL:** <https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746>\
**Category:** Ask for Help\
**Created:** [July 10, 2023, 9:59pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746 "2023-07-10T21:59:24Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [July 10, 2023, 9:59pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746/1 "2023-07-10T21:59:24Z")

</div>

I have an image that I am referencing if it is found, however I can’t select if from If Then Else?

 ![Screenshot 2023-07-10 at 23.57.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d454a056088c12fb22e2cb5211ddf97936812ef2.png)

See the structure of it here?

 ![Screenshot 2023-07-10 at 23.57.49](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e40eac0551e079cdb7b0dfe8de759877069c09f4.png)

---

<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:** [July 10, 2023, 10:01pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746/2 "2023-07-10T22:01:03Z")

</div>

That’s because you are either using a multiple relation or a full table as the source of the lookup, so the result is an array. How is the lookup column configured?

Arrays can contain multiple values, so they will not work in places that only work with single values.

---

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [July 10, 2023, 10:06pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746/3 "2023-07-10T22:06:21Z")

</div>

“My Stickers” is a “query” which extracts relation limited to one value based on the user id.

The lookup is straight fwd

 ![Screenshot 2023-07-11 at 00.05.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/055db1406af65263f45f3fff89053f3cdc978c6f.png)

---

<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:** [July 10, 2023, 10:08pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746/4 "2023-07-10T22:08:02Z")

</div>

OK. Queries always result in arrays (as if they were a multiple relation), so in that case you’ll want to use a Single Value column instead of a Lookup.

---

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [July 10, 2023, 10:10pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746/5 "2023-07-10T22:10:57Z")

</div>

Solved, tx Jeff 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 11, 2023, 10:11pm UTC](https://community.glideapps.com/t/if-then-else-cant-select-lookup-with-if-then-else/63746/6 "2023-07-11T22:11:17Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.