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

[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.

[TimHDev]

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.

[v-bofeng-msft · Accepted solution]

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]

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?