web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : IBRFXVx1SvPuBlgbSx6fCu
Power Apps - Building Power Apps
Unanswered

Free text in Dropdown

Like (0) ShareShare
ReportReport
Posted on 17 Apr 2023 16:23:30 by 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.

  • gjbannister01 Profile Picture
    185 on 18 Apr 2023 at 12:34:59
    Re: Free text in Dropdown

    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?

  • v-qiaqi@microsoft.com Profile Picture
    on 18 Apr 2023 at 09:34:37
    Re: Free text in Dropdown

    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 Profile Picture
    185 on 17 Apr 2023 at 16:42:02
    Re: Free text in Dropdown

    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?

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on 17 Apr 2023 at 16:29:03

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete