cancel
Showing results for 
Search instead for 
Did you mean: 

SharePoint Choice List Missing

I wanted to create a flow that would change the "Status" field from 'Active' to 'Filed' once the user puts in an Issue End Date (because the status field is not on the power app form). However, the Status Field (which is a choice list with 2 choices: Active and Filed) was not available in the Update Item fields in the flow.

 

Is that intentional? I knew we couldn't use managed meta-data or people fields, but didn't hear anything about choice fields not being available for update.

 

Thank you in advance,

Audrie

Status: Completed
Comments
Power Automate Staff

I also found out that choice fields are read only so I can't use the Patch() function in a custom Power App to write to the choice field on SharePoint. I work around this, but it would be preferable to have choice data types available for all operations please.

Microsoft

Please add the choice type item to "Update Item" action with SharePoint List.

In current, only text type items can be selected.pic2.png

I think following scinario.
If "Status" item is changed to "Released", "Publish" column is changed to "Publishable" automatically by Flow.

Level: Powered On

Two things:

 

1) When using a workflow to update a SharePoint list item, any selection for a Choice field is deleted during the update. This prohibits building a workflow to update an item with any Choice field. Is there a workaround for this?

 

2) Update Item in a workflow currently does not allow for Choice field updates. Will this be accounted for soon?

 

Thank you -

Anonymous
Not applicable

having the same challenge.  I noticed that it removes the value of the choice field and people/group lookup.  If only there's a way to select which fields to update in the "Update Item" Action.

Level: Powered On

I am sorry Microsoft dev team on the Flow program, but you guys need to get your act together.  And whoever the Program Manager is, please take some more pride in yourself and the product you represent.  This breaking change was just recently introduced as I have a few list items from a couple weeks ago that have no issues with "Sharepoint update item" when an update is written back to the list item while keeping the original choice field .value.  Now with this Flow build that exists today in production not only are the original values wiped clear when an update is written back, but I had to develop around this to get the workflow to function correctly again.  I had to change each choice field type to a standard single line text data type just to keep the original values from being overwritten.  Now instead of my users simply selecting a value from an enum list they have to type in the value.  Not just that, but the value better be typed in correctly or my workflow logic will fail since it is keying in on that value exactly which was simple when a choice was used before.  Now I pray to the Flow Gods that the user types in the value correctly.  It's called regression testing and apparently it isn't being practiced well for this product.  The crazy thing is that I love the direction that Microsoft is taking with Flow, but when you are making mistakes like this it is simply unacceptable.  We deserve better!  Hopefully I receive a response soon as to when this regression bug is going to be corrected.