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.
Create a View with 4 columns in One in Dataverse
If you want to create a field that combines 2 field values and then eliminates duplicates, try
in the Items property of the combobox
Hi @Drrickryp Thanks for the response. But I'm not looking for COncatenating columns instead merging them, for ex
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
We are excited to announce a new way to share your ideas for Power Apps!