lists
3194 TopicsSharePoint - Filter stacking
SharePoint list with a Link to Documents (hyperlink) column. When you click the link, it should open to the library where these documents are stored based on the associated ID for the record with all the documents that have that "Document ID", in this case 5550. /AllItems.aspx?FilterField1=ABC_ID&FilterValue1=5550&FilterType1=Text This field is a Hyperlink field The item opens in the library where the documents are all being stored, but is showing an additional filter value (sometimes, it will show three additional values) for example, it will show 5550, 5596, 2208 (all random each time). Is it caching old searched filters? When I go to the library and clear all filters and then filter from the All documents on the 5550, I get all my documents back no problem. I compared the URL with the broken filter to the URL from the all documents filter and they are the exact same Why would this be happening? What is breaking the filter and adding or stacking additional filters to the requested link. Any help to fix this would be appreciated.88Views1like6CommentsHow 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!Solved119Views1like3CommentsColumn Visibility based on previous people column
We've setup persistent approvals for travel requests using a Power Automate flow (not the built-in workflow), so the approved status is not lost if/when the list item is edited. We have a choice column for Approval Request allowing "Draft" and "Submitted". Just need a control to prevent saving the list item as "Submitted" if there is no selection in the Approver (people) column. As you know, we can't use a people column to evaluate conditional visibility on the list form... https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide And we've tried JSON formatting with a 'helper' column to show if an approver has been assigned or not: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(length([$Approver]) > 0, 'Assigned', 'Unassigned')" } But this doesn't set a value in the column so cannot be used for list validation settings. To reduce complexity, we're trying to do this without using a Power Apps form and conditional visibility... but maybe it's not possible? Already found this help redirecting to Power Apps... https://techcommunity.microsoft.com/discussions/sharepoint_general/column-visibility-based-on-previous-multi-choice-column/3987360 Any alternative suggestions are welcomed. Thanks!22Views0likes0CommentsHow 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?132Views0likes1CommentPlanner 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.108Views2likes1CommentSharePoint 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 Gomes71Views0likes0CommentsTrying 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!268Views0likes5CommentsSaving 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.Solved163Views0likes2CommentsSharePoint 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.9KViews3likes5CommentsSharePoint 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, Jake156Views0likes1Comment