Add a choice value to a SharePoint List Choice column (custom Canvas app)

Question

Either this is a simple process I have completely missed or not possible :(. I have a SharePoint List maintained via a custom Canvas app. The SP List contains a Choice column where the user may need to add a new value to the Choice column list. I can confirm the default form to add a List record allows the user to key-in a new choice to the Choice column:

However, once I customize the Canvas app, there is no longer an option to key-in a value.

The settings on the Choice column are (in both cases):

The column is not required

Requirement that this column contains information: No

Enforce unique values: No

Allow ‘Fill-in’ choices:  Yes

Versioning settings (found this online, but no idea why it would relate to this issue):

              Create a version each time you edit an item in this list:  No

I have created a flow that uses HTTPS to Get the current choice values, add the new one, and then POST the update back to the SharePoint list. The flow works. However, I cannot get it to work from the SP Canvas app. The Canvas app calls the Flow and it runs successfully, but the data is not written to the SP List item. Although, I see the new choice the next time the Canvas app is run. The new choice is also seen in the List Settings for the column. I feel it may be a timing issue? If there is a tutorial out there or you have any suggestions on how to get this to work, I would greatly appreciate it.

Answer 1

Hi LaceySharpe1:

I checked the relevant information, when using the workflow, there may be a time difference：Understand canvas app execution phases and data call flow - Power Apps | Microsoft Docs

At the same time, we have also found the following documents which may be available for your reference:Create SharePoint integrated canvas apps from scratch to view, edit, add, and delete SharePoint list items - Power Apps | Microsoft Docs

However, we mainly support O365 products so that we may not be able to answer your questions about Canvas appues.

To avoid sharing any incorrect information from our side, it is also recommended to ask the question in the Power Apps Community - Power Platform Community (microsoft.com) for a better help. Since your question is relate to Canvas app, it is better suited to post in that community. And it has more experts in this area to help you.

Thank you for your understanding.

Best Regards,

Tin

Answer 2

Thank you for the timely reply and links to articles that may be of help. I will also post the question to the Power Apps Community.

It seems odd to me that there are so few articles on adding values to a Choice column. Since it works by default when creating a new List record, you would think the feature would be available for custom SharePoint apps as well.

Thanks again!

Lacey