I want to populate Combobox with Distinct values from 3 columns in Dataverse. I tried many ways, for ex this
Modifying "Search Fields" & "Display Fields" Property will show values from Primary fields on searching moreover they're not distinct.
Combine multiple columns to form combobox items but this doesn't show all values as DISTINCT is non-delegable
Merge two columns with the same data type into one column this also doesn't show all values as ClearCollect is non-delegable
Can anyone suggest how to Search & Select using Combobox based on all distinct Values from 3 columns.
However I thought altering datasource in Powerapps might also work so I posted a question there as well.
If you want to create a field that combines 2 field values and then eliminates duplicates, try
Sort( Distinct( AddColumns( table,"newcol",Concatenate( col1,col2 ) ) ),Result )
in the Items property of the combobox