# Selecting options from X/Y query outputs

**URL:** https://community.glideapps.com/t/selecting-options-from-x-y-query-outputs/22708
**Category:** Ask for Help
**Created:** [February 13, 2021, 1:55am UTC](https://community.glideapps.com/t/selecting-options-from-x-y-query-outputs/22708 "2021-02-13T01:55:22Z")
**Posts on this page:** 1
**Showing post:** 14

<div class="post-metadata">

### Author: ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [February 16, 2021, 12:27am UTC](https://community.glideapps.com/t/selecting-options-from-x-y-query-outputs/22708/14 "2021-02-16T00:27:16Z")

</div>

> [@belzoni](#):
>
> I did the same for you in Column C with the somewhat new Sheets function [FLATTEN](https://support.google.com/docs/answer/10307761?hl=en). Same result…

Glad to hear it! hmm. Not getting same results on my end. Is this the full formula to replace what I have in A2?

I should mention it was Jeff and Thinh who came up with this [workaround](https://community.glideapps.com/t/solved-dynamic-product-variants-in-choice-component/12344) for the inability to use [array columns in choice components](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108).

Yes, pls do post back esp if you venture into multi-choice selections.

---

_[View the full topic](https://community.glideapps.com/t/selecting-options-from-x-y-query-outputs/22708)._