Skip to main content
Community site session details

Community site session details

Session Id : PBImIeYY6zjxTY1ukuAWNz
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.

  • TimHDev Profile Picture
    44 on 30 Mar 2023 at 10:23:40
    Re: Sharepoint, Update List Item, How To Update Just A Single Column / Value, & How To Handle Choice Fields?

    Thanks for your reply.

    I tested it out and it works as you say. 👍

    Fields left empty appear to be ignored.

     

    I'm surprised at the lack of proper documentation for Power Automate & Apps...

    I keep hitting the same problem - no documentation.

    I just want to be able to RTFM...

     

    Is Microsoft's policy to leave it all up to forum posts & the "community" to try to figure out how it's products work?

     

  • 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

  • TimHDev Profile Picture
    44 on 29 Mar 2023 at 09:50:46
    Re: Sharepoint, Update List Item, How To Update Just A Single Column / Value, & How To Handle Choice Fields?

    I added a photo to the post under "cover photo", but it's not showing, so I'm adding it here as an attachment.

    Maybe "cover photo" is something else...? Hard to tell.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete