Unanswered

Replace text in Sharepoint list

(0) Share

Report

Posted on by CB4455

Hi I'm new to powerautomate

I have a SP list and in one single text field called 'colour' I want to replace all entries that say blue to saying red. I understand there is a Replace function that I can put into an expression but I don't know how to build the flow. I know how to get list data but I don't know how to update using the replace function. Can anyone please walk me through the steps? Flow would be manual trigger. So I start with Manual trigger - then get data?

Thanks very much in advance for any help you can give me.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

@CB4455 You don't need the replace function. Just follow the flow below making sure in the Get items action that you set a filter query to only bring back the items currently marked as Blue as that is more efficient than evaluating every single item in the list. My list uses a choice column for Color which is why in the update item action it says Color Value rather than just Color.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
CB4455 3 on at

Like (0)

Report

Thanks very much! This really helps

Was this reply helpful? Yes No
leonardosouza 20 on at

Like (0)

Report

@CB4455, you don't even need to bother creating a flow. If you're just trying to replace the value of a whole field, just filter your items in your list. With the filter applied, select all items and edit the field you want.

Was this reply helpful? Yes No