Unanswered

Fill-in combobox connected to a Sharepoint list

(0) Share

Report

Posted on by 8900tfgie9rioge

Hello,

I'm trying to implement a combobox in an app connected to a Sharepoint list which has the option for users to either select an item or fill-in their own item. Saving is done using OnSave = SubmitForm(SharePointForm1) etc., no custom buttons as some solutions propose.

Solutions such as this one Manual Fill In Option For Combo Box

do not work, as I get the following error:

The following code produces the error on the image above.

Put this code in Update Property of the Card. It will fit your scenario much better.

If(
 !IsBlank(ComboBox1.Selected),
 ComboBox1.Selected.your_column_name,
 ComboBox1.SearchText
)

My question is how to create a combobox that allows user fill-in an app connected to a Sharepoint list (the app is made using Integrate --> PowerApps --> Customize forms).

Thanks for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @8900tfgie9rioge ,

Assuming you are writing back to a Choice field here

{ Value: Coalesce( ComboBox1.SearchText, ComboBox1.Selected.your_column_name ) }

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
8900tfgie9rioge 6 on at

Like (0)

Report
Hello, @WarrenBelz, thanks for your reply.

I'm sorry, I forgot that the code that works and that users accepted as a solution is from a Tweet linked in an answer to the question I linked to

Code modified for my case:
If(
!IsBlank(DataCardValue20.Selected),
DataCardValue20.Selected,
{Value: DataCardValue20.SearchText}
)

The
your_column_name
part from my original question is not present in that Tweet.

When I use your code on the Update property of a specific DataCard
{ Value: Coalesce( DataCardValue20.SearchText, DataCardValue20.Selected.your_column_name ) }
I get an error despite trying multiple ways to reference a column. "Column name", 'Column name' and Column_name all produce an error. If I drop the your_column_name and use DataCardValue20.Selected.Value, the code produces no errors, but doesn't work.

Thanks again for all your help so far.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @8900tfgie9rioge ,
I actually use the code myself (just tested one here on a prod app) and it works fine. 'your_column_name' was from your post and I assumed you knew this was simply a place marker for the actual output of the Combo Box. If this is a choice field you are referencing in the Items

Choices(listname,fieldname)

and are writing back to the same field, then you need

{ Value: Coalesce( ComboBox1.SearchText, ComboBox1.Selected.Value ) }

in the Update of the data card. This is simply "shorthand" for

{ Value: If( !IsBlank(ComboBox1.SearchText), ComboBox1.SearchText, ComboBox1.Selected.Value ) }

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No