Hi,
Im having trouble with showing the DefaultSelectedItem in a combobox. The DefaultItem i am wanting is from a Collection and it matches with the datasource of the Items Property of the Datasource and i'm giving the Combobox a record. I believe that the issue lies not in my DefaultSelectedItems formula, which is;
Filter(CatalogueSupplier,CATEGORY = First(ItemToDuplicate).CATEGORY)
And that the issue is something to do with Distinct Function i'm using in the Items Property. The Formula for my Items Property is below.
Sort(Distinct(CatalogueSupplier,CATEGORY),Value,SortOrder.Ascending)
If i change the Items property to "CatalogueSupplier' then the DefaultSelected Item shows Correctly, but then my combobox then has hundreds of the same rows. Any thoughts on how to sort this?
Am i best to create a Distinct Collection of the CATEGORY Items on page visible and then use that Collection as my Items Property, or is there a way to change the DISTINCT formula above to show the correct item?
Edited:
Thinking on, Im assuming that as the Combobox is looking for a Column Called "Value". So i need to Rename the Column in my DefaultSelectedItems from 'Category' to 'Value', however i'm not having any joy with this formula.
Filter(CatalogueSupplier, RenameColumns(CatalogueSupplier, "CATEGORY","Value"),CATEGORY = First(ItemToDuplicate).CATEGORY)
Don't think i'm using the RenameColumns Function correctly?
Thanks
Thanks
