I've a combobox called 'Solution ID' which shows blank on edit form..i tried this [ThisItem.SolutionID] then it just shows 'solution1;solution2' in the combobox but doesn't sae this value on submit. i want combobox to show like Solution 1 and solution 2 pre selected...
Also, i tried Filter(Solution.SolutionName, SolutionName=ThisItem.SolutionID), then it works but only if we select one value..if we select multiple value, it shows blank again!
AN UPDATE:
I tried RenameColumns(Split(ThisItem.SolutionID, ";"), "Result", "Value") in the defaultselecteditems in combobox which works great but my form has multiple Combobox, some may need to be edited. So, I am reading the stored data from DB using the above rename script.
However, after editing, when I am sending back the data, it's writing only the newly created data but all the Combobox in which no change was made, the data for them is deleted.
Also, seems Concat function is not able to read the values from the Combobox (referring to the values that are being read from the Combobox).
Any solution for this?

Report
All responses (
Answers (