Answered

Power App not showing fill-in choice created from Sharepoint list

(0) Share

Report

Posted on by yongsm

I created an app from Sharepoint data. One of the column type is Choice, which list down 5 choices and allow fill-in choice. This column is appear as a field in the Power App's Edit Form for user to fill up.

However, in Power App, the above said field did not allow fill-in choice, it only shows the 5 choices. Is there any way or setting to show the fill-in choice?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@yongsm

I highly recommend creating the field as Single line of Text field "MyChoices" and store all your choices in a separate list. Along with your 5 choices, add "Other" to the choices.

In the app, show a drop down and connect to the list which contains all the choices.

If the user selects "Other" option, show an additional text field "FillInTextField" to allow the user to fill in or type in.

In the Update property of your "MyChoices" , if the drop down value is Other, select the value from the Text field "FillInTextField". Otherwise, the store the value from drop down.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@yongsm，
Based on the issue that you mentioned, do you want to allow the users to fill in other choices within the drop-down control?
Could you please share a bit more about the scenario: do you want to fill in within PowerApps or fill in choices within the SP Choice column and display the added choice within PowerApps?
Let me make it easy for you, only the Combo Box could allow users to fill in text, so I assume that you use the Combo Box.
In the Combo Box, we name the fill-in text as SearchText.
If you want to show the fill-in choice in the Combo Box, you should enable the 'Can add values manually'. This operation could help you enter choices within the Combo Box.
Only this way could make the fill-in choice display within the PowerApps and allow the users to fill in choices whenever in the SP list or in PowerApps.
I have made a test which is confirmed on my side.
1/ If you have already added new choices within the Choice column in the SP list and just want to display the fill-in choice within PowerApps, you should enable the 'Can add values manually' function.
2/ If you just want to fill in a choice in the Combo Box within PowerApps, you should enable the 'Can add values manually' function within the SP list column setting and enable the 'Allow searching' function for the Combo Box.
Further, if you have the ComboBox within a Form, you should write the Update property of the data card as follows:
If( IsBlank(DataCardValue10.Selected), {Value: DataCardValue10.SearchText}, {Value: DataCardValue10.Selected.Value} )
Note: DataCardValue10 represents the Combo Box.
Hope it could help.
Best Regards,
Qi
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

Is there a way of letting the user add their own choice, but then not show the custom choice in the combobox. I only want the pre-determined choices set in sharepoint to show in the combobox and not the custom onces created by the user?

Regards
Oshin