User Profile
Joe_Grover
Copper Contributor
Joined Jan 21, 2021
User Widgets
Recent Discussions
Renaming a folder with too many files
One of our teams has a Team/SharePoint site with an archive folder. Everything in there is old files, and they'd like to rename the folder. However, we get the error that it exceeds the list view threshold. I've spent the afternoon trying to find out how to get this folder renamed and so far nothing has worked. The general consensus is to create a filtered view, but I'm not sure what to filter it based on, as all of the files have been there and untouched for some time, causing most of the columns I could index be fairly similar (they were moved to SharePoint 3 years ago from an on-prem fileshare). One of the options I'd seen was to sync it using OneDrive and rename it locally but that still gave me the same error. I also tried renaming the folder from within Teams without success. If someone could provide some guidance for how to get this done, I'd appreciate it. Right now, I'm thinking I'll just have to move a bunch of stuff out of some of the folders to temporary locations, but even that is challenging as I'm not aware of a good way to get a count of items in folders and subfolders in SharePoint to know which are the best ones to move out.Re: Find and replace part of an item in a SharePoint List
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.Re: Find and replace part of an item in a SharePoint List
RobElliott 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.
