# Pass the connector result to App input drop down list options **URL:** \ **Category:** Support, Troubleshooting, & Help\ **Created:** [May 17, 2021, 4:04pm UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729 "2021-05-17T16:04:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ruijia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/ruijia/32/2371_2.png) [@Ruijia](https://community.tulip.co/u/Ruijia)\ **Post date:** [May 17, 2021, 4:04pm UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/1 "2021-05-17T16:04:25Z")
Hello, I already created one DB connection and get the result from as an array which could display in the app. Meanwhile, i also created an dropdown list as option for input in the app. May i know how to build the link and let the connector result to App input drop down list options…? For example, i have below 3 department name, i need convert them into the dropdown options. Then i could choose them as input… ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/20d1f4d4e489e960f88600fc8a0fd8e5fcf1b3f2.png) Thanks in advance! ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [May 17, 2021, 6:50pm UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/2 "2021-05-17T18:50:41Z")
hello @Ruijia, welcome to the Tulip Community!! it would be great if you could introduce yourself at: [Welcome to the Community, let's meet!](https://community.tulip.co/t/welcome-to-the-community-lets-meet/738) regarding your question, on the Dropdown Single Select, Options \> Variable you can assign it to the to the Array you have returning from your Connector Function: ![Screen Shot 1](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/3/3f52325ea9b3fd2783cbb5158a3479d41c2342a0.jpeg) as a note this does need to be a Text Array: ![Screen Shot](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/c/c5ed3fde45647185dfb8190c79a5074e1a5008e4.jpeg) ![Screen Shot 2](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/9/9ab033a63027e1b7002c848d565622a385b56434.jpeg) are you seeing this as an Option on your App?? let us know!! ---
**Author:** ![Grant](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/grant/32/182_2.png) [@Grant](https://community.tulip.co/u/Grant)\ **Post date:** [May 17, 2021, 7:58pm UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/3 "2021-05-17T19:58:04Z")
Hi @Ruijia, I believe you can add one additional trigger action when you’re running that connector function to use the `MAP_TO_TEXT_LIST()` expression. This can help map to a text array, which is what the single select widget is looking for. Looking at your screenshot, I believe you’d set this up by saying `MAP_TO_TEXT_LIST(@variable, 'DEPARTMENT_NAME')` where `DEPARTMENT_NAME` is your key (name of the column). Let me know if that works for you! Thanks, Grant ---
**Author:** ![Ruijia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/ruijia/32/2371_2.png) [@Ruijia](https://community.tulip.co/u/Ruijia)\ **Post date:** [May 18, 2021, 2:58am UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/4 "2021-05-18T02:58:28Z")
Hello Grant, Maybe I take some grammar mistake when use the function… what I done, ![image010.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/6/6444db84c1bf837da4afc8ea10a0439ef307fe0c.png) ![image001.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/4/49bada13bdda4b0420557dfbc2e0504b64f486b9.png) ![image002.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/0/058c7d48030c32395bc029b6a00182ab5f55d53b.png) ![image003.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/5/5f6da08ebdd5d847d87495652d22f9da493ad35b.png) ---
**Author:** ![Ruijia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/ruijia/32/2371_2.png) [@Ruijia](https://community.tulip.co/u/Ruijia)\ **Post date:** [May 18, 2021, 3:06am UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/5 "2021-05-18T03:06:06Z")
Thank you Gio for your swift support! I am new for Tulip and just get company sandbox access try to build my personal app. I think I met the same issue which you mentioned in the [https://community.tulip.co/t/tip-of-the-week-getting-started-with-arrays/2406/2](https://community.tulip.co/t/tip-of-the-week-getting-started-with-arrays/2406/2). But unfortunately, all your suggestions and Ermingut’s solution not working in my end… maybe I took some mistake when use the syntax… I put all the captures from my end when replying Grant in an separated mail. Hope you could help me to point out the syntax error point…? Thanks. ![image001.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/6/690d1a1165ce6d73f5d6f2bbd72df2b3ec762067.png) ---
**Author:** ![Grant](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/grant/32/182_2.png) [@Grant](https://community.tulip.co/u/Grant)\ **Post date:** [May 18, 2021, 4:17am UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/6 "2021-05-18T04:17:48Z")
Can you try using “Department\_Name” instead of “DEPARTMENT\_NAME” in the `MAP_TO_TEXT_LIST` and report back? It may be case sensitive. Thanks! ---
**Author:** ![Ruijia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/ruijia/32/2371_2.png) [@Ruijia](https://community.tulip.co/u/Ruijia)\ **Post date:** [May 18, 2021, 6:06am UTC](https://community.tulip.co/t/pass-the-connector-result-to-app-input-drop-down-list-options/2729/7 "2021-05-18T06:06:13Z")
Hi Grant, Yes, I change it to same as field name ‘Department\_Name’ and follows step by step as [https://community.tulip.co/t/table-records-in-a-select-option/867/4?u=ruijia](https://community.tulip.co/t/table-records-in-a-select-option/867/4) mention, but still no data come out… ![image001.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/8bb7b128091f7793e15884fe73f34b75a5b749e0.png) ![image002.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/b/b312b62cbcc527631f1864bb958cbf601e0618f5.png) ![image004.png](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/9/9ef5ff389ad9f017586ab62c7c36c20f5a82b246.png) I was assuming it’s because of the data type different…? The only different my test is the data from table, but the example is from HTTPs output. Not sure if have debug function to see how the data transfer and where it is… Thanks.