Answered

Add another value to a combo box referencing a Lookup field

(1) Share

Report

Posted on by senna

217 Season of Giving Solutions 2025

I have a canvas app with a combo box pointing to a lookup field in a SP List. I need to add the value of "Not Applicable" to the lookup but not add it as a value in my list.

I have tried the below and am not getting an error but the selection in the combo box shows as blank until it is selected, any idea of a solution, thanks;

Ungroup(
 Table(
{CBOptions: ["Not Applicable"]},
 {CBOptions:mySpList.Title}
 
 ),
 'CBOptions'
 )

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Why are you adding the new option as an array with one record? It should just list it as the record. I think what you want is something more like this:

Table(

{CBOptions: "Not Applicable"},

[Code needed to return an array from your list]

)

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

senna 217 Season of Giving Solutions 2025 on at

Like
a
(1)

Report
Copy link

Link copied!

If anyone runs into this problem, I created a collection and use the collection as the data source

ClearCollect(myCollection,{Title:"Not Applicable"});

Collect(myCollection, myListName.Title);

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
You can try below :

With( { varOptions: Collect( colTemp, { Title: "Not Applicable" } ) }, Collect( colTemp, ShowColumns(mySpList, "Title") ) )

Make sure ComboBox properties are set correctly:

DisplayFields: ["Title"]
SearchFields: ["Title"]
Value (if used): "Title"

Was this reply helpful? Yes No