I have a SQL table "platform" <ID, descriptions>, where ID is an auto-increment value. I set up a combobox in PowerApps using the descriptions as choices. Then I would like to get the selected item ID. The original function I use is
```
ClearCollect(colPlatform, {var1, platform_ID});
ForAll(combobox.SelectedItems, Collect(colPlatform, {var1: ..., platform_ID: LookUp(platform, descriptions = descriptions, ID)}))
```
The first "descriptions" is the platform table column. The second "descriptions" is the combobox item values. Turns out the ID is always 1 whatever the original ID should be.
To avoid this problem, I created a temporary collection using a different name from "description" to collect item values in combobox, then use the new collection to substitute the function of combobox.SelectedItems to get the correct ID results.
May I know if there is a better way to avoid such operation? Is this a bug or if there is something wrong with my previous code?
Thank you.
fromage
