SOLVED

Update SharePoint Text Column

Copper Contributor

I have a SharePoint list with a text column named SupervisorLU2.  I would like to create a Flow that updates the value (in SupervisorLU2) based on the content.  I have setup a Manual Flow.  My first step was to Get Items from the list where SupervisorLU2 = specific text.  What are the next steps I need to take to update the text to a different value?

1 Reply
best response confirmed by RJF61 (Copper Contributor)
Solution

@RJF61 Use below actions after Get items action:

  1. Add "Apply to each" action after get items action. Use value array from get items action output as input the apply to each
  2. Add "Update item" action inside the apply to each action. Use same site address and list name as get items action
  3. Use appropriate ID from apply to each loop for item ID option in "Update item" action
  4. Set the SupervisorLU2 column value to any text you want.
  5. Save and Run the flow.

You can also take backup of list data before running the flow. Check: Export to Excel from SharePoint or Lists 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 best response

Accepted Solutions
best response confirmed by RJF61 (Copper Contributor)
Solution

@RJF61 Use below actions after Get items action:

  1. Add "Apply to each" action after get items action. Use value array from get items action output as input the apply to each
  2. Add "Update item" action inside the apply to each action. Use same site address and list name as get items action
  3. Use appropriate ID from apply to each loop for item ID option in "Update item" action
  4. Set the SupervisorLU2 column value to any text you want.
  5. Save and Run the flow.

You can also take backup of list data before running the flow. Check: Export to Excel from SharePoint or Lists 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

View solution in original post