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