web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Updating/Renaming choi...

Power Automate

Unanswered

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

(0) Share

Report

Report

Posted on by julienvdc

210

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:

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation