# Solved: Dynamic product variants in choice component **URL:** https://community.glideapps.com/t/solved-dynamic-product-variants-in-choice-component/12344 **Category:** Ask for Help **Created:** [July 12, 2020, 2:08am UTC](https://community.glideapps.com/t/solved-dynamic-product-variants-in-choice-component/12344 "2020-07-12T02:08:52Z") **Posts on this page:** 1 **Showing post:** 3
### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney) #### Post date: [July 12, 2020, 10:35am UTC](https://community.glideapps.com/t/solved-dynamic-product-variants-in-choice-component/12344/3 "2020-07-12T10:35:54Z")
I guess I didn’t realize it, but I’ve been doing this (or something very similar) for a while in some of my apps. By using the same basic logic of moving all options to a separate sheet using “UNIQUE” formulas, I can then create a relation to the User Profile and then lookup the user’s specific choices so that only the ones that they’ve added to their profile are available. I use this for employees’ jobs… people at my organization can have more than one job title, so they’re able to add multiple jobs to their profile, then when they’re filling out a form, they have a choice component that only displays their jobs as choices. > [@raising\_hand\_woman User Profile columns in conditions and columns](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/54): > > Figured it out! Created a new sheet with all Jobs listed (used a Unique function that combines and sorts the Jobs columns in the User Profile sheet ---- =sort(UNIQUE(PROPER({‘User Profile’!G2:G;‘User Profile’!H2:H})))). This gives me a column I can use to create a relation from the array of job titles to the UNIQUE column in the Jobs sheet. Once I have that relation done, I can add a Lookup in my other sheet that pulls in the Jobs Relation values. It’s hard to explain but it works! --- _[View the full topic](https://community.glideapps.com/t/solved-dynamic-product-variants-in-choice-component/12344)._