Unanswered

Free text in Dropdown

(0) Share

Report

Posted on by gjbannister01

185

Ok so I have created a form on my powerapps that has dropdowns with the option of free text. Whenever I submit my form, it resets the free text I have put in the dropdown to blank. It does not do this when I choose one of the options. I know in SharePoint when I opt for free text, it adds my free text then as an option, so it is doable there, but it is not functioning the same on my power apps.

How do I get it to add my free text and keep it when I hit submit?

Also, I have already tried Update> If(IsBlank(DataCardValue1.Selected), {Value:DataCardValue1.SearchText}, DataCardValue1.Selected).

I say this because I saw this as an answer on someone else's post about this same exact question.

Thank you in advance.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@gjbannister01

Check out https://powerusers.microsoft.com/t5/Building-Power-Apps/Add-new-item-dynamically-in-Combo-box/td-p/530905
gjbannister01 185 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the variable referencing? I need all data cards to be mapped back to a column created in SharePoint, so is this formula only referencing the intended column?
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gjbannister01,

Have you solved your problem?

Do you want to save the free text to the Choice column or save the free text as the options of the dropdown list?

If you just want to save the free text to the choice column, you just need to input something within the search bar and then submit the form.

Please set the Update property of the DataCard as below:

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

"Whenever I submit my form, it resets the free text I have put in the dropdown to blank", which is abosolutely right if you want to keep the free text in your dropdown list after your submission.

This kind of free text always displays when you enter it, after you submit form, it disappears.
gjbannister01 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok so I have a dropdown unit. In the SharePoint list, I have created a units column which is a choice column, but also has "Can add values manually" option enabled. On my PowerApps, I have created a form based off of this list and when I go to use the units column, I can choose from the drop down or type in my own unit. The problem is, whenever I type in a value manually, it does not save, it just turns blank once I hit submit, unlike in SharePoint, if I were to type in a unique value, it would automatically save that unique value as a new choice option in the drop down.

I have tried the formula you put above, and it is not working. Do I need another control in addition to my data card?

I have tried:
If
(IsBlank
(DataCardValue47_2.Selected)
&&!IsBlank
(DataCardValue47_2.SearchText),
{Value:DataCardValue47_2.SearchText},
DataCardValue47_2.Selected)
and
If
(!IsBlank
(DataCardValue47_2.Selected.Value),
DataCardValue47_2.Selected.Value, DataCardValue47_2).

When it is saying search text even though it is a unique value, is it supposed to search the choices or create a new one so it will save?