How to set combo box secondary text for SharePoint lookup field

(0) Share

Report

Posted on by AdrianChang

I would like to set the secondary text for the SharePoint lookup field (combo box)

I read other discussion from community that said use AddColumns() in Items.
However, I set a Filtering already.

Please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@AdrianChang - screenshots are useful but in future please also paste your code as Text.

The pattern below is what you will need (please note this has been manually typed, so please look out for any errors):

AddColumns( Filter( Choices([@'[New] Warehouse Return Submission'].'Machine(s)/ Item(s)'), Value in Filter( '[New] Machine / Item Status List', 'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan" ).Title ), MyNewColumn, 'Enter your expression here' )

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Amik I would like to add the field 'Code + Name' of the lookup table, but I don't know how to draft the expression.

BTW I tried your formula like below.
AddColumns(
Filter(
Choices(
[@'[New] Loan Extension Submission'].'Machine(s)/ Item(s)'
),
Value in Filter(
'[New] Machine/ Item Status List',
'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan"
).Title
),
'Code + Name',
Filter(
Choices(
[@'[New] Loan Extension Submission'].'Machine(s)/ Item(s)'
),
Value in Filter(
'[New] Machine/ Item Status List',
'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan"
).ID
)
)

but the secondary text showed the same as Primary Text.

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Amik Let me give some background about this lookup field.

This power app is the form of '[New] Warehouse Return Submission'. This lookup field is looking up another SharePoint list of '[New] Machine/ Item Status List'.
The Primary text of this Combo Box is the Title of '[New] Machine/ Item Status List'.
And I want the Secondary Text of this Combo Box be the field 'Code + Name' of '[New] Machine/ Item Status List'.

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Amik Do you have any ideas?

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@AdrianChang - thanks for providing an explanation but unfortunately I do not understand any of it. On reading your code however, I think the below is what you're trying to do:

AddColumns( Filter( [@'[New] Loan Extension Submission'].'Machine(s)/ Item(s)', Value in Filter( '[New] Machine/ Item Status List', 'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan" ).Title ), 'Code + Name', Concatenate( Id, "-", Value ) )

Note: If you make any change to the Items property of a ComboBox, often you will need to "reselect" the field you want from the Primary text and Secondary text menu (even if you're reselecting the same field). If this does not work, try applying the formula to a new ComboBox control.

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Amik it is the same.

The combo box field setting like below.
The combo box field is a lookup field which is looking up the List - '[New] Machine/ Item Status List' (below).
Serial No. = Title, which is the Primary Text.
And I want to make the Secondary Text be 'Code + Name'.

It is my new try but it is failed also.
AddColumns(
Filter(
Choices(
[@'[New] Warehouse Return Submission'].'Machine(s)/ Item(s)'
),
Value in Filter(
'[New] Machine/ Item Status List',
'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan"
).Title
),
'Code + Name',
Filter(
Choices(
[@'[New] Warehouse Return Submission'].'Machine(s)/ Item(s)'
),
Value in Filter(
'[New] Machine/ Item Status List',
'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan"
).Code_x002b_Name
)
)

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Amik Is the secondary text can be the Value and Id only?

I would like to have 'Code + Name' here.

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@AdrianChang - is this what you're trying to do?

AddColumns( Filter( Choices([@'[New] Warehouse Return Submission'].'Machine(s)/ Item(s)'), Value in Filter( '[New] Machine / Item Status List', 'Customer Account No.' = DataCardValue1.Text And Status.Value = "Done - Loan" ).Title ), My_Code_Name_Field, LookUp( '[New] Machine/ Item Status List', ID = Id, //note the lower case 'Id' 'Code + Name' ) )

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Amik Thank you so much. It is exactly what I want.

Was this reply helpful? Yes No