Find and replace part of an item in a SharePoint List

CindyZ you will rarely find a flow that does exactly what you want, it's usually quicker & easier just to build one from blank. And this is not a difficult flow.

I have a SharePoint list with the data provided in the original post:

The trigger is to manually trigger the flow. Then the first action is a SharePoint get items. I've added a filter query to only bring back items that have a value:

Add an apply to each and select value from the dynamic content. Then add a compose action and select the column which has the data you want to change, in my casre it's the Title column.

Next, add another compose action and in the expression tab of the dynamic content box add the following expression:

replace(outputs('ComposeTitle'),'ER','EAR')

That takes the ComposeTitle compose and replaces ER with EAR:

Finally and still inside the apply to each, add an update item and for the column with the changed data select the output of the previous compose:

 And this is the result:

Rob
Los Gallardos
Microsoft Power Automate Community Super User