Prevent list form
I have a list with 10 columns. I created a custom view to share this same list with some partners, but they only can see 6 columns. The problem is, I what that guests can only view the list, I dont want then to open the form. The list is already guest only, so, they cant edit the form. The problem is, even they cant edit the form, they can see the data of the other 4 columns on the form. Is there a way to prevent a guest to open the form of a list on the sharepoint? Thank youGallery view: horizontal scrolling?
I have a gallery view on a list with grouping. Currently, each group will be shown across multiple rows within the boundaries of the spCardContainer element. I want to display each card within a group on a single "line" with a horizontal scrollbar. I know I have options in CSS using (perhaps) flex-wrap, but I could use some help putting it together in JSON for my formatting. Who can help?
Maximum value for SharePoint List unique ID
Hi everyone, I have a SharePoint List that gets updated daily. I have 25000-30000 items that get completely deleted every night and then created again with new values and content. So every new item gets a new list ID. I'm a little bit worried because, even though SharePoint lists can store up to 30 Million items, what happens when the unique ID assigned to each item gets "overflowed"? For example, right now the last item's ID is 480368, and as I said before I create 30000 new items every single day , so doing a simple math it would take 1000 days to reach an ID number of 30000000 (if that's possible, I don't even know). What happens when the ID reaches a limit? Would it break the list? Will I be able to keep creating new items? Just to make it completely clear: the list will never reach the 30 million limit. It will always stay on 25000-30000 items. But I'm scared that the ID will break this process in less than 3 years. Thanks for your help!
SharePoint List calculated column formula using a Lookup column reference
Given: A SharePoint List (SPL) called Contractors with the following columns: ContractorID // Display name of the default ID column ContractorName Another SPL called Reports with the following columns: ReportID // Display name of the default ID column ReportNumber // Calculated column Contractor_ID // Lookup column referring to the ContractorID column of the Contractors SPL The calculated column, ReportNumber, would have a formula similar to: = [ReportID] & "-" & Contractor_ID Question: Does SharePoint Lists support the use of a Lookup column in the formula of a calculated column? If so, I need help on the proper syntax for the formula. (The formula above is not working) Thanks in Advance
Export SharePoint Calendar with All Events in Calendar View
I need to export my SharePoint calendar exactly as it appears in the Calendar view, including all events for each day, without collapsing into "+X more." Currently, SharePoint does not provide a built-in feature to export the calendar in its visual month/week layout. I am looking for a solution or workaround that allows me to: Export all events while preserving the calendar layout (month/week view). Ensure no events are hidden or collapsed. Use methods such as connecting the calendar to Outlook for export/print, Power Automate to generate a report, or other feasible options. My goal is to have a complete calendar view outside of SharePoint for reporting or sharing purposes.SharePoint Calendar View Events Collapsing into “+X More” Instead of Displaying All
In the SharePoint calendar (Month view), when a specific date has more than two events, the system only displays the first two events in the day cell and collapses the remaining items into a "+X more" link. This limits visibility, as users must click to view additional events instead of seeing them directly in the calendar grid. We need a solution or customization to allow all events for a single day to be displayed within the calendar view without collapsing into +X more.LookUp column shows up as [object Object] for single column in board view
Hi, I have seen similar questions from this topic, but I couldn't really apply to my problem. I have a SharePoint list which one of the lookup columns retrieves data from another list. This new column [Evaluated Property] allows multiple selection from the LookUp column it originates from. When viewed in list mode, the multiple selection LookUp columns results are visible (1st picture). However, when I create a board view, I get [object Object],[object Object]. I figure from other threads here in the discussion group that this can be solved using a JSON custom formatting. However, this did not seem to work. I am unsure how should I do this formatting since I am not familiar with JSON coding. Did anyone face this same issue and could suggest me how to handle this? Regards, Lucca
Power Automate and SharePoint List Required field URL
Morning: I have a problem. I am creating an automation based on a SharePoint list. The automation will check for date, and send a notification out when a document needs to be revised, at which point, the Document's status will change form Live to "Due revision". To make that change, i added an Update File and here is the problem The list has "Required" fields one of them is "Document Title" which is a Hyperlink type. this field has 2 parts, URL and Alternative Text. The Alternative text is what displays on the list The problem is, when using Power Automate "Get Items" " Document Title" on the "Update Item" action, then it will display the URL on the list instead of the document name (instead of showing the name of the Document it shows URL) So, is there a way to sort this out (other than changing the filed to not required - since it is an important one) Thank you
Filter to where I can see items assigned to [Me] but still can see all items in personal view.
Hi, I have a list with public views where a column is filtered for Delegate = [Me]. So this means a user can only see records where user is a "Delegate". All users have contribute access + cannot create, change and delete private views. However, some users have created private views PRIOR to being changed to contribute access only. These private views created PRIOR users can still see all items and edit them. Where I dont want them to be able to. Any work arounds for this? Am I missing something?
Attachments and approvals
Hello everyone, I'm hoping someone can give me some insight. I have setup a flow consisting of 3 approvers for my Sharepoint list which works seamlessly, my problem is that I need the second approver to add an attachment to the form before going through to the 3rd approver. Is there a way to add this to my approval request or should I stick to having a link on the approval request to the list? Thanks in advance
