SharePoint Choice field with "Allow 'Fill-in' choices:" is not working correctly inside our Power apps

(0) Share

Report

Posted on by johnjohn123

3,514

We have a SharePoint field named "options" of type Choice and which allow Fill-in, as follow:-

and we built a power apps standalone app, but when we type-in the choice field and we save the form:-

the options field value will be saved as the default value and not the value we type it in ("New222" in our case)? any advice?

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@johnjohn123 ,

That option works in SharePoint on the standard interface, the problem is that Power Apps combo boxes and drop down controls do not allow it. If you need to do it, give the user a Text box in the same card, with an "Add" button to show/hide the combo box or the text input and base the update of the card on which control is visible.

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.

Visit my blog Practical Power Apps
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelzThanks for the useful reply. but is there any reference or link i can go through to implement this approach ?
WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@johnjohn123 ,

I thought I described it fairly well for a user with the level of code I have seen you post previously . You need to

Unlock the data card

Add a Text input (I assume there is a Combo Box in there already)

Add an icon or button in there setting a Variable

UpdateContext({varAdd: !varAdd})

which allows you to toggle between the boxes - also at Screen OnVisible set this Variable to false

The Visible of the Combo Box would be

!varAdd

The Visible of the Text box would be

varAdd

The Update of the data card would be

If( varAdd, YourTextBoxName.Text, YourComboBoxName.Selected.xxxx )

where xxxx is the valid output of the combo box (Value/Result/FieldName). I am also assuming a single-choice combo box here or this gets difficult.

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.

Visit my blog Practical Power Apps
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelzbut this formula will raise an error "Expected Record value":-

If( varAdd, YourTextBoxName.Text, YourComboBoxName.Selected.xxxx )

i think the update should contain choice and not a free text value
Verified answer

WarrenBelz 156,574 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
@johnjohn123 ,

You did not say what type of field you are writing back to - my response was for Text.

If a single select Choice field

{ Value: If( varAdd, YourTextBoxName.Text, YourComboBoxName.Selected.xxxx ) }

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.

Visit my blog Practical Power Apps
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ok worked for me thanks
MS14 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Do you have a solution to allow multiple options to be added?