cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Adding More Options To Choice Column In The PowerApp (User's Input)

Hi,

     I have a choice column that can also accept user's input in the powerapp.

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

   However, unlike sharepoint, where you can see user's custom input in the choice options the next time you create an new item, you can only see the pre-configured options in the powerapp .  So I was wondering if there is anyway that can achieve the same thing in the powerapp. 

   I was looking for pnp powershell, (put in the azure function, connect to the flow, so the choice option will be expanding as the user enters more value). However, I did not see any way of acheiving this as well.

    Is there any workaround for this issue? Thank you for your time! Any help would be greatly appreciated!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft
Microsoft

Hi agent3154,

 

I'm not aware of any easy way to edit choice columns in SPO, even if you had to use the SharePoint REST API.

It might very well be possible, but it sounds like quite a bit of overhead and complexity.

 

This doesn't answer your question directly, but if you don't come right with the API and if your users aren't interacting with the list directly (i.e. only via your app), then I'd suggest using a plain text column to save the data but create a separate lookup list with your dropdown options for PowerApps to lookup and control the input. 

 

You can then show the options in your control and add/remove user entries like any other list.

 

[Edit]

I forgot to add that I sometimes do this a different way in my own apps  

I get similar results using the same plain text data column in my list (no lookup list or column), an input text field, a listbox containing Distinct values from the column, and some visibility and reset  variables.  I basically build my own 'dropdown/lookup/text input' - if you're interested in this approach let me know and I'll post the details.

 

Hope this helps,


RT  

 

View solution in original post

Highlighted

hi, @RusselThomas

     Thank you for your suggestion! I actually figured it by using the method you metioned. 

     For people who are having the same issue, this is what I did:

 

1. Create a new sharepoint list ( let's call it ChoiceList),  with a single column.

2. Create edit form for the orignial list. For the column that you want to acheive "fill-in options", set the data type to single line of text. 

3. Replace the generated dataValueCard with a ComboBox, set its item property to

'ChoiceList'.columnName

, and dataCard's update property to

 

If(Not IsBlank(ComboBox.Selected), ComboBox.Selected.columnName,ComboBox.SearchText)

4. Create another edit form for the ChoiceList, set its default to 

If(Not IsBlank(ComboBox.Selected), ComboBox.Selected.Title,ComboBox.SearchText)

 

5. lastly, submit both forms in the powerapp, when submitting the form for the ChoiceList, change the OnSelect to

If(IsBlank(LookUp('ChoiceList',DataCardValueOfTheChoiceListColumn.Text in ColumnName)),SubmitForm(ChoiceListForm))

This will prevent dupilicate values.

 

This solution works fine, but I am also interested on your approach. If you got some time to show me the details that would be great! 

Thanks again for the help!

 

  

 

View solution in original post

7 REPLIES 7
Highlighted
Microsoft
Microsoft

Hi agent3154,

 

I'm not aware of any easy way to edit choice columns in SPO, even if you had to use the SharePoint REST API.

It might very well be possible, but it sounds like quite a bit of overhead and complexity.

 

This doesn't answer your question directly, but if you don't come right with the API and if your users aren't interacting with the list directly (i.e. only via your app), then I'd suggest using a plain text column to save the data but create a separate lookup list with your dropdown options for PowerApps to lookup and control the input. 

 

You can then show the options in your control and add/remove user entries like any other list.

 

[Edit]

I forgot to add that I sometimes do this a different way in my own apps  

I get similar results using the same plain text data column in my list (no lookup list or column), an input text field, a listbox containing Distinct values from the column, and some visibility and reset  variables.  I basically build my own 'dropdown/lookup/text input' - if you're interested in this approach let me know and I'll post the details.

 

Hope this helps,


RT  

 

View solution in original post

Highlighted
Community Support
Community Support

I think here you are talking about the Fill-in Choices field in SharePoint?

This is currently not supported, we have an idea submitted on this already:

SharePoint Choice - Fill in option

 

A workable way to submit custom Input is the methods you posted, but currently based on what I know, there is no option available to have PowerApps display those "Fill-in" options automatically.

The Choices() function could only obtain the pre-defined choice values.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

hi, @RusselThomas

     Thank you for your suggestion! I actually figured it by using the method you metioned. 

     For people who are having the same issue, this is what I did:

 

1. Create a new sharepoint list ( let's call it ChoiceList),  with a single column.

2. Create edit form for the orignial list. For the column that you want to acheive "fill-in options", set the data type to single line of text. 

3. Replace the generated dataValueCard with a ComboBox, set its item property to

'ChoiceList'.columnName

, and dataCard's update property to

 

If(Not IsBlank(ComboBox.Selected), ComboBox.Selected.columnName,ComboBox.SearchText)

4. Create another edit form for the ChoiceList, set its default to 

If(Not IsBlank(ComboBox.Selected), ComboBox.Selected.Title,ComboBox.SearchText)

 

5. lastly, submit both forms in the powerapp, when submitting the form for the ChoiceList, change the OnSelect to

If(IsBlank(LookUp('ChoiceList',DataCardValueOfTheChoiceListColumn.Text in ColumnName)),SubmitForm(ChoiceListForm))

This will prevent dupilicate values.

 

This solution works fine, but I am also interested on your approach. If you got some time to show me the details that would be great! 

Thanks again for the help!

 

  

 

View solution in original post

Highlighted

hi, @v-micsh-msft,

    Thanks for the information! I am looking foward for this to be implemented soon.

Highlighted

@agent3154 

 

I am not able to set the update to you formula as the second half of step 3.  it gives me an error every time.  Also I do not understand step 4.   Do i need to add another screen, and forms donot have a default property.

Highlighted

Sorry for reviving this old thread, but I'm having trouble getting implementing this workaround. Could you please describe your alternative solution to this problem?

Highlighted

Hi, I would like to know if the choices can be added to the list and not get added to the drop-down choices. i.e. When I have 1,2,3,4 in my choices, if I add 5, I do not want 5 to be added to my choices. Is that possible and how?

 

Thanks a ton in advance!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,717)