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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

TimHDev 44 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (2)

Report

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

Was this reply helpful? Yes No
TimHDev 44 on at

Like (2)

Report

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?

Was this reply helpful? Yes No