Lists
3142 TopicsSharePoint Form JSON Customize layout header - Managed metadata not working
I'm trying to add a managed metadata field titled Status to the header portion of a SharePoint form. Here is the JSON I am using: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/form-formatting.schema.json", "elmType": "div", "style": { "background-color": "#e8f5ee", "border": "1px solid rgba(0,0,0,0.1)", "border-radius": "8px", "padding": "12px 16px", "margin-bottom": "12px" }, "children": [ { "elmType": "div", "style": { "display": "grid", "grid-template-columns": "140px 1fr", "row-gap": "4px", "column-gap": "12px", "align-items": "center" }, "children": [ { "elmType": "div", "style": { "margin": "0", "line-height": "1.2", "font-weight": "600", "color": "#616161", "font-size": "32px" }, "txtContent": "=[$Title]" }, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='ID: ' + [$ID]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='Status: ' + [$Status]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='label: ' + [$Status.label]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='Label: ' + [$Status.Label]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='GUID: ' + [$Status.termGuid]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='Path: ' + [$Status.path]"} ] } ] } Here is the result: Only the Title and ID fields appear. All other attempts render blank. The Status field does have a Value which I do see on the Body of the form What is corret JSON syntax to display Managed metadata fields in the Header?21Views0likes0CommentsHow to prevent overnight events from appearing in the "All Day" section in Lists calendar view?
Purpose I am trying to create a reservation calendar for an equipment using the calendar view in Microsoft Lists on MS Teams. Each work session lasts from several hours to several tens hours, with most sessions typically around ten to fifteen hours. What I’ve done I created a calendar view using Microsoft Lists via SharePoint and added several events. The calendar is mainly used in weekly view. Issue Events that span overnight or last more than 24 hours are displayed in the "All Day" section at the top of the calendar, rather than as vertical blocks in the main time grid. Since the purpose of this calendar is to manage equipment usage, it is not ideal that actual usage times are shown as "All Day" events and not in the time-based section of the calendar. QuestionIs there a way to adjust the formatting or settings so that all events are displayed in the main time grid, rather than in the "All Day" section? Any advice or suggestions would be greatly appreciated.8Views0likes0CommentsSharepoint list column type removing hyperlink
With either a Rich Text or Enhanced Rich Text column type, when I try to use a link to the Onenote desktop app (begins with 'onenote:https://'), SP will remove the hyperlink on its own. My guess it because it only allows 'https://'. Has anyone found a way to get SP to accept this kind of a link?24Views0likes1CommentSharePoint Board View: Clicking an a href triggers default click action as well
I’m using SharePoint’s new board view with JSON for custom card formatting. On the card I’ve included a clickable link using `"elmType": "a"`, with an `href` and `"target": "_blank"`. The annoying thing is that if someone clicks on the link, this opens the link in a new tab, but it also triggers the default click action (which opens a form). Is there any way to avoid this from happening? Or is there a way to disable the default click action? Unfortunately `customRowAction` doesn’t support something like `"action": "none"` or `"action": "disabled"`.15Views0likes0CommentsHow to filter document library web part by a page property column
Dear community members, i am looking for a way to filter my document library web parts inside a sharepoint page by a column that i have added to the page properties. I have tried to add the that has this column as a webpart list and filter against it, and this working fine but i dont want to filter this way. The idea is to create a page for each project in my main list and filter the document library webparts inside of it automatically. is this a possible solution? And if not feasible via page properties, is there any other solutions for this? Thank you in advance for anyone who could help in this. AliSolved102Views0likes2CommentsWhy Is SharePoint’s Priority Column Free Text and Not a Choice Field?
While https://bluesite.consulting/en-us/articles/sharepoint-site-template-projecthome-review.html, I noticed something unusual in the work action tracker list—a column setting that seemed out of place. Specifically, the Priority column isn't set up as a typical choice column with selectable options. Instead, the available choices are entered as free text in a single text field (left image) I saw this years ago in the old SharePoint. where options for a choice column are defined within a text field rather than as a standard list of choices (right image). Does anyone know why this might be happening or what could be causing this behavior?Solved54Views0likes3CommentsSharePoint Online List: Filtered List View Not Refreshing After Change
Before recently, any time a change was made to a list row column that a view filter was based on, the items in view would automatically refresh to show the changes. Now the list view doesn't update unless the user refreshes the page in their browser. This is a consistent issue across all lists in the tenant. Our organization has SharePoint lists with a 'Status' column that impacts what items are shown in a view and its hurting productivity when these views aren't updating with new items unless the page is manually refreshed. Is there a new setting that is impacting the ability for filtered views to auto-refresh?83Views1like2CommentsCan't switch off grid view
We've a number of pages (about 90) We have a couple of views on each page (different for each one) from a main List This works for most of the pages/views we have. However some have defaulted to Grid View and we can't switch it off How can we get rid of this? we don't want grid view only the link to the Canvas App form to enter information. We've no idea why it's appeared and we can't get rid of it. Does anyone have any idea how we can revert these to the default view. Thanks64Views0likes1CommentAI- based Post Sorting
I have developed a Post and Comment module inside SPFx. where i have 3 sharepoint list:- Posts Comments Reaction here is the SPFX, with 2 posts and the first post has 2 comments:- Currently the Posts and their Comments will be shown sorted by the created date , here is the method to show the posts:- async getPostsPage(pageSize: number = 10, afterId?: number) { let url = `${this.siteUrl}/_api/web/lists/getByTitle('SocialPosts')/items` + `?$select=Id,Title,Body,Created,Author/Id,Author/Title,LikeCount,CommentCount` + `&$expand=Author&$orderby=Id desc&$top=${pageSize}`; if (afterId) url += `&$filter=Id lt ${afterId}`; const data = await this.getJson<{ value: any[] }>(url); return data.value.map(v => ({ Id: v.Id, Title: v.Title, Body: v.Body, Created: v.Created, AuthorId: v.Author?.Id, AuthorTitle: v.Author?.Title, LikeCount: v.LikeCount || 0, CommentCount: v.CommentCount || 0 })) as import('../Models/Models').Post[]; } and the comments:- // ---------- Comments ---------- async getComments(postId: number): Promise<Comment[]> { const url = this.commentsUrl() + `?$select=Id,Body,Created,Author/Id,Author/Title,LikeCount,Post/Id,PostId` + `&$expand=Author,Post&$filter=PostId eq ${postId}&$orderby=Created asc`; const data = await this.getJson<{ value: any[] }>(url); return data.value.map((v) => ({ Id: v.Id, Body: v.Body, Created: v.Created, AuthorId: v.Author?.Id, AuthorTitle: v.Author?.Title, LikeCount: v.LikeCount || 0, PostId: v.PostId ?? v.Post?.Id, })); } but the client is asking us if there is a way to order the items using AI algorithm so it show the most relevant posts and comments first? which approach i can follow? to allow order items inside SPFx using AI algorithm instead of Created date?? any advice?24Views0likes0CommentsGlitch when creating Sharepoint list from Excel
I've been trying to create a Sharepoint list from an Excel spreadsheet, and I keep having a problem with one column. The column contains mostly numbers, but they are not formatted very consistently. Some records have additional characters like #, / or -, which is not a problem for me. However, if I choose "Number" as the data type for that column in Sharepoint, I get errors on the records that contain non-numeric characters, and the entire list isn't converted. If I first convert the column to Text or General format in Excel, then choose "single line of text" as my Sharepoint data type, the list isn't created at all. After a few seconds it says that the process is 100% complete, but no list is created. Any ideas would be greatly appreciated. Thanks.9.9KViews3likes8Comments