web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Automate - Building Flows
Answered

Sharepoint, Update List Item, How To Update Just A Single Column / Value, & How To Handle Choice Fields?

Like (1) ShareShare
ReportReport
Posted on 29 Mar 2023 09:46:58 by 44

I have a simple flow triggered by adding a row to a SharePoint list.

All it has to do is:

a. Calculate a value from the data in the list row. (No problem)

b. Add that data to the "Approvers" column - in the same row.

However, the "Update Item" connector seems to require that ALL the columns are updated, as shown in the image.

 

Q1: I only want to update a single value - is there any way to do this?

 

Q2: If not, how do I handle choice fields???

- as shown, the form requires a value to be set for "Company Value", and I can't set it to a dynamic value like the other fields, so it seems there no way to preserve the data. Is that right?

This seems to make the flow impossible to implement...

 

Q3: Where is the official documentation for this connector?

- The most detail I can find is here, but it's next to nothing...
SharePoint - Connectors | Microsoft Learn

 

Edit: I see - so you have to embed images for it to work... Got it.

 

sp-update-item.png

Thanks.

  • Verified answer
    v-bofeng-msft Profile Picture
    on 30 Mar 2023 at 07:42:52
    Re: Sharepoint, Update List Item, How To Update Just A Single Column / Value, & How To Handle Choice Fields?

    Hi @TimHDev 

     

    You don’t need to worry about this. As the flow is able to update A Single Column as long as all the required columns inside the SharePoint list are updated with the dynamic content at the same time.

     

    I made a test to update only one column named “required_column_1”, my list has other columns like title, choice(the choice column), number_info.

     

    Update item: I didn’t provide any value for the number_info column.

    vbofengmsft_0-1680162103633.png

     

     

    Flow result: number_info still has its original value and the required_column_1 was changed.

    vbofengmsft_1-1680162103634.png

     

     

    As to updating the choice column, please select “Enter custom value” and select the choice dynamic content.

    vbofengmsft_2-1680162103635.png

     

     

    For the official document, I am afraid you are referring to the correct doc and there is no other official doc explaining this connector.

     

    Best Regards,

    Bof

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete
Loading complete