I usually use double layout in the items of a ComboBox, everything is fine when choosing "Primary text", "Secondary text" and "Search text" but at some point in the development or when saving that configuration it is reset or configured in a default way that I don't know how it works when working with SQL Server data; I fill the ComboBox with data from a table that refers to the foreign key of a main table, only that in the canvas app it reacts badly and those values that I mentioned before are reset.
I think it is a bug in the canvas app system, it would be ideal if they could solve it in the future, it is not at all appropriate for clients to find those ComboBoxes with data that they do not see as familiar and it is annoying to be reconfiguring this every time what's going on.