Forum Discussion
Find and replace part of an item in a SharePoint List
I'm looking to do a similar thing, but am having issues with the Flow (full disclosure--I've never used Flows).
I have a Notes column and want to mass edit changing an error from when data was imported into the list (user did a find/replace in the .CSV file and it was a tad too aggressive, changing things we didn't want to change).
I was able to create the new flow as shown above, and I selected my site address and selected my List in the List Name, however when I click "add dynamic content" it doesn't show any of the columns I have in my list--it just has general fields like name, email, date, city, state, etc, few of which are present in this particular List.
Joe_Grover I can see from the cursor that you are in the filter query field. There won't be anything in the dynamic content box for that at this stage, the only items you have are in the manually trigger a flow section. So leave the filter query empty.
What you then need is a Filter Array action. Select value from the dynamic content box and you will then see in the filter field that the columns from your get items are available.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Ok, thanks. That got me a bit further. I'm almost there, heh.
I need to tweak the steps a bit for what I'm trying to do.
- "ComposeTitle" shows as an invalid reference in my Compose action. The field I want to search for text in is called "Notes," so what would I put in for my expression in the Compose action? For clarity I want to search for a string of text (irrespective of case) and change one of the words. For example, looking for "this is good" and changing it to "this is great".
- In the Update item action, do I add the Outputs to the Notes field?
- And there are some required field in the form. I don't know if I can ignore the warnings that the fields are required (since I don't want to touch those fields) or if I should temporarily disable that requirement in order to run the Flow. This wouldn't be a big deal as nobody should be entering/changing stuff in this List anymore anyway--there just isn't a way to mass-change this after we migrate the data so I'd like to correct it beforehand.