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

(1) Share

Report

Posted on by TimHDev

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.

Thanks.

All responses (3)

Answers (1)

TimHDev 44 on at

Like (2)

Report

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 on at

Like (2)

Report

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.

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

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

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 44 on at

Like (0)

Report

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.

sp-update-item.png