Updating/Renaming choices of a SP list column and the selected choices of the list items

(0) Share

Report

Posted on by julienvdc

203

Hey,

As you know, when you're renaming choices of a column of a SP List, it will not retroactively update the choices of existing items. In my case

I am trying to build a flow that would update my items with the new name for the choices. In my case it is a multiple choice possibility and not all choices have been renamed.

Any idea/tips on how my flow should be looking like?

Cheers!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report
Updating/Renaming choices of a SP list column and the selected choices of the list items

You could use a Get Items with a Filter Query to check if the field contains this old value. After that you can loop through the results and use a Select action to retrieve the multiple choice field values in the From. In the Map you can combine the replace function with the item function. After that you can use the outputs in an update item action.

Below is an example

The list with the old values (Flow)

The flow setup, which uses the replace function in the select action

replace(item()['Value'], 'Flow', 'Power Automate')

The test result

Was this reply helpful? Yes No