Dropdown list: allow "fill-in" choices?

[Charles-v-D]

Hi All,

I have a powerapp as form for a sharepoint list. In the sharepoint list I have a "Choice" field that gives a dropdown list where my users can select different options. I have enabled the "Allow 'fill-in' choices in the column in order to give my users the ability to type an entry in case their desired option is not in the dropdown list. This works fine in the classic sharepoint input form.

Now I'm setting the input form to PowerApp and start developing the powerapp. The dropdown option in the PowerApp works fine.. BUT: it does NOT allow for typing a new choice. See screenshots below

Any suggestions how to fix this?

Thank you

Regards

Charles

[yashag2255]

Hi @Charles-v-D 

Can you try to use the below expression on the Update property of the field's datacard:

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

Note: Make sure that you have enabled Search on the DataCardValue25 control.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[gabibalaban]

Hi @Charles-v-D ,

You found the key setting from Sharepoint list column here:

....

Also, to solve your issue you need also to change the update property of the datacard with something similar to:

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

In this way you'll write a new value to your column - choice type.

Hope it helps !

[Charles-v-D]

@yashag2255 @gabibalaban 

Thank you for getting back to me so fast!. I have implemented @yashag2255 his solution and now I'm able to type "fill-in" choice in my dropdown list, but when I hit save, it is not recognized as input (the field is mandatory), so I get error message:

update property set in the datacard:

search property set to ON in the dropdownlist:

This is the result: I can type an new entry in the dropdown box, but it is not accepted when I click SAVE

Please help?

Thanks & Regards

Charles

[gabibalaban]

Hi @Charles-v-D ,

It is mandatory to check your Sharepoint choice column checkbox "Can add values manually" as i wrote it in my post.

Did you achive that ? 

[Charles-v-D]

@gabibalaban 

Yes I did (see below), when I use classic sharepoint to enter data I can type new choices and all works fine.. only when I use powerapp the fill-in ones give me problem...

[Charles-v-D]

@gabibalaban 

I have implemented your suggestion. the Update property of my datacard now reads:

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

when I type a value in the dropdown box and click save, the error message about demanding input no longer appears (good!) but the actual value I typed in the dropdown box is not saved into the SharePoint list. 

In the sharepoint list I have enabled the "allow fill-in" setting for the corresponding column and in the powerapp I see that the "allow searching" is ON.

Any suggestions how to resolve the issue of the value not being stored in the shrepoint list?

Thanks!

Regards

charles

[WorTony]

This worked a treat for me - thanks for posting it 👍

Tony

www.id-live.com

[sambr1]

I am having the same issue, including more than one option stopped.

[sambr1]

the custom form allows to fill in but stopped accepting multiple values.

any idea how to fix?