cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
EYOST
Level: Powered On

Combo Box Display Fields Issues: From Different Table? Display More Than 2 Fields? Field Not Display When Using Sort Distinct Filer Formula?

Hi all,

 

Have anyone experienced these on Combo Box Display Fields?
1) Primary Display Field from Table A, Secondary Display Field from Table B

2) Display more than two display fields 

3) When the Item Property is using Distinct(maybe Sort too) with Filter formula, it only can show one Display Fields, it can't show one more display field. 

For Eg, Sort(Distinct(Filter(TableA, Code1 = ComboBox.Selected.Code), Description),Result,Ascending)

The Display Fields written as ["Result","ShortID"]. It only show Description in the selections.

 

Appreciate on your guidances and advises.

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Combo Box Display Fields Issues: From Different Table? Display More Than 2 Fields? Field Not Display When Using Sort Distinct Filer Formula?

Hi @EYOST ,

 

I'm afraid not. The Distinct function evaluates a formula across each record of a table and returns a one-column table of the results with duplicate values removed. The name of the column is Result.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Combo Box Display Fields Issues: From Different Table? Display More Than 2 Fields? Field Not Display When Using Sort Distinct Filer Formula?

Hi @EYOST ,

 

This is because that in Distinct function, you have used the syntax "Distinct(Table,ColumnName)", so this formula would only return the table with one Description column. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
EYOST
Level: Powered On

Re: Combo Box Display Fields Issues: From Different Table? Display More Than 2 Fields? Field Not Display When Using Sort Distinct Filer Formula?

@v-monli-msft 

Thanks for your reply!
Your answer is for No.3, may I know is there anyway to display secondary fields by using Distinct?

Community Support Team
Community Support Team

Re: Combo Box Display Fields Issues: From Different Table? Display More Than 2 Fields? Field Not Display When Using Sort Distinct Filer Formula?

Hi @EYOST ,

 

I'm afraid not. The Distinct function evaluates a formula across each record of a table and returns a one-column table of the results with duplicate values removed. The name of the column is Result.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,934)