lists
3192 TopicsHow are you creatively working around the SharePoint List View Threshold
Hi community I'm looking for outside-the-box approaches to dealing with the SharePoint List View Threshold (5,000 item limit). I'm familiar with the standard guidance, indexed columns, filtered views, folders, but I'm curious how others have solved this more creatively, especially in M365/SharePoint Online environments where you can't raise the threshold from the admin side. Additionally, if you've tackled this in a healthcare, government, or other highly regulated environment where you couldn't just move to an external database easily. Would love to hear what's worked (and what's blown up) in practice. Thanks in advance!32Views0likes0CommentsHow to hide the Modify this view and Create View as per users available in groups
Hi All, I have classic view of SharePoint in list/libraries. I have group(for Managers). I just want want to show and hide the Create View/Modify View/Modify this view depends on users available in group. If user available in group(for Managers) then they can do anything like Create View/Modify View/Modify this view but if user is not a part of the group(for Managers) then they can not modify any Public views but the can create Personal view. Is there any way how I can achieve this functionality?117Views0likes1CommentPlanner and SharePoint task list
I’m exploring the use of SharePoint Task Lists alongside Planner. Is there a way to interlink these today, or is Planner expected to support SharePoint task lists more natively in the future? Also, with Planner Agent in the picture, how can these be more aligned and interlinked or even more centralized with SP.85Views2likes1CommentSharePoint Announcements items' body don't save the complete URL of links
I am working on a Power Automate flow to replace the SharePoint Alert feature (which will be retired in July 2026) to send a notification when new items are added to an Announcements list. The flow is working fine, but the links I added to the item's body is partial. The messages sent via Power Automate using Exchange connector replicates this error, so when the recipient receives the message, it looks ok, but the links are broken, because it has only "/sites/finance/home.aspx", not the whole URL (https://company.sharepoint.com/sites/finance/home.aspx). I'm using the classic interface, and even when I enter the full URL, as soon as I move away from the URL field, it changes to a partial, relative URL (/sites/finance/home.aspx, without the first part "https://company.sharepoint.com/"). Note: when I receive the exact same content via SharePoint Alert feature, the links work perfectly. Somehow, the Alert feature replaces the relative path with the whole URL. Is there a way to fix this? Thanks, Luciano Gomes65Views0likes0CommentsTrying to use Lists as a very basic CRM but having search issues
Hey All, I have a small business I'm considering using Lists to track some very basic client info and build a client database that is accessible to all employees on the company SharePoint site (we use MS 365). Workflow would be something like: Client calls in Receptionist(s) answer If new client, create an entry with first/last name, phone #, email address, their spouse's name (if any) and a Notes section to jot down notes from the call. If current client, receptionist can use search to find client, make new notes, read previous notes, etc That is basically it. I have this set up in Lists right now as a test with just two clients, each with a spouse. When I do a search for the person's name (Bill or Franklin), it returns a result. When I search for their spouses name (Susan), it returns nothing. I've run through the settings, reindexed the list, etc, and I just can't get a simple search to work. Am I attempting to use this correctly? Both name columns are single line fields. TYIA for any input!244Views0likes5CommentsSaving MS Form with many question responses to SharePoint
Hi, A department wants to save responses received from a MS Form to a SharePoint list. When I received the MS Form to create the columns in the SP list, noted there was 115 questions. Most of them are a Yes / No answer and a few where comments have been asked for. Then a Flow will need to be created. Firstly - This is too many questions. Secondly - Would SharePoint be the best place to store these answers knowing that an Excel spreadsheet is created for the responses? Thirdly - As the MS Form will be used regularly and responses coming in Day and Night is there another solution. The results will be used to Analyse the results using PowerBI.Solved147Views0likes2CommentsSharePoint List Rule to send email not allowing shared mailbox email address
Hi I have tried to search for an answer to this to no avail. We have a SharePoint list and want to create a rule that sends an email when a new list item is created. Sounds simple but I can't seem to add a SharedMailbox email address only UserMailbox email addresses. We do have a work around where we have created a rule in outlook instead that when the email arrives to the UserMailbox forward it to the correct SharedMailbox but it seems a bit silly that I can't directly add a SharedMailbox to the SharePoint list directly from the below. See below the screenshot of where I am trying to insert the SharedMailbox email address. It doesn't find it and if I add it in manually the create rule button doesn't activate. Am I missing something? Thank you!2.8KViews3likes5CommentsSharePoint List Migration to new Tenant
Hi All, I am preparing for a tenant-to-tenant migration of 60+ SharePoint lists that function as the back-end for various PowerApps. Since we are doing a staggered cutover, I need to perform an initial migration now and then run 'Delta' syncs over the next few weeks to catch new records, updates, and deletes. My primary challenge is that SharePoint's native ID column is not preserved during manual migrations (PowerShell/CSV), which will break our App logic and Lookups. How have others handled cross-tenant list synchronization at this scale? Specifically: How do you maintain record relationships and deep links when the system IDs change? What is the most efficient way to handle deltas across 60 lists without buying expensive 3rd-party migration tools? thanks, Jake137Views0likes1CommentPnP Template Error: "Invalid field name {guid}
Hello, I'm trying to apply a site template from one SharePoint Online site to another using PnP PowerShell. I have custom lists, some of them with a specific dependency chain: List X has a lookup to List Y. List Y has a lookup to List Z. All libraries/lists have "Allow management of content types" enabled. The cmdlets I run: Export: Get-PnPSiteTemplate -Out template.pnp -Handlers All -IncludeAllClientSidePages -PersistBrandingFiles Import: Invoke-PnPSiteTemplate -Path template.pnp The Error: During the Invoke process, I get: Invoke-PnPSiteTemplate : Invalid field name {guid} targetsharepoint site What I’ve tried: I attempted to manually remove the ID="{guid}" attributes from the XML inside the .pnp package, but that just makes the template schema invalid. Verified that I am connected to the target site with owner permissions. How can this issue be fixed? Any help would be greatly appreciated! Thanks!79Views0likes0Comments