Showing results for 
Search instead for 
Did you mean: 

SharePoint Choice - Fill in option

Well it seams like when PowerApps was created as the new custom form for SharePoint somehow the ability to have fill in options for Choice fields was forgotten. 


I see there are requests people have entered for This option but I don't know that anyone created an "New Idea" for it since that was requested even yesterday.


To me this is a show stopper for a number of forms I am creating for SharePoint. I really hope this can be implemented soon.

Status: New
Advocate I

Thank you for the solution!!!

Regular Visitor

is it true that : If(Not IsBlank(DataCardValue.Selected); DataCardValue.Selected;{Value: DataCardValue.SearchText; '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})


is only possible with a premium subscription because of the azure connector?

Advocate V

No, the important part is "Sharepoint", so a premium connector is not needed for that.

Regular Visitor


This is the result I get. (was the reason to wonder about the connectors.)

Advocate V

"DataCardValue" has to be the real name of the control you use. Could be "DataCardValue1", "DataCardValue26" (or whatever was set automatically as the name)


My advice: always rename all the controls you use inside PowerApps to "human readable" names. So for example when you want to select cars, you could name the DataCard "CarDataCard" and the dropdown control "CarDropDown" or "CarDataCardValue" (or whatever you like)

Regular Visitor

In my case it is dacatacard 1.

Even with this changed I get an error about the IF statement.

Advocate II
Advocate II

You don't want to use DataCard1, if you click on the update field you will see "DataCardValue#. Selected"


Also, where are you putting that IF statement? You want to drop it into the update field inside the datacard Advanced -> More Options


Where you have DataCard1 you want to have DataCardValue#, make sure that you're changing the ; to , as well.


So it should look like so: 

  If(Not IsBlank(DataCardValue#.Selected), DataCardValue#.Selected,{Value: DataCardValue#.SearchText, '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

Regular Visitor

It works!
  If(Not IsBlank(DataCardValue1.Selected); DataCardValue1.Selected;{Value: DataCardValue1.SearchText; '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

Was the solution. strangely the connector stays red but there is no error message and the list is updating with the desired text.


Thank You!


Regular Visitor

The only remaining problem: Multiple sellect does not work for the own text. Multi sellecting one of the predifined itims in combination with own input seems not to be possible. I guess this is because of the if is blank statement, is there a way arround this?


Regular Visitor

After saving the form with the own input selecting more than one option is possible.