Posts

Showing posts from January, 2021

Power Automate: Using the SharePoint Update Item action

Power Automate's Update Item action for SharePoint has an issue with choice fields in that when you add that action, all fields are blank EXCEPT Choice fields.  Choice fields will instead default to the top item in the choice list.   This is really bad because if you don't clear them the flow will overwrite any existing values with the top items. Currently, the only way I can see to avoid this issue is to manually clear each field, so here are the steps: Choose the dropdown item on the choice field. Choose "Enter Custom Value" Immediate go back to the field and click the 'X' in the field and it will be cleared Repeat for each choice field that you don't want to change. I think the above is just a hack/workaround to a problem with how this action is configured by default so I put this into the uservoice/suggestion box for PowerAutomate.    Upvote this if you think it's worth it: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/SharePoint-Update-