lists
3146 TopicsMaking a FAQ using lists need help with json formatting colors
So I was following a tutorial on Youtube on how to make a FAQ list but I cant get the formatting right. There are 4 columns in this list Title, Question, Answer, Show More Basically I have it grouped by title and then grouped by question The problem is the as you can see in the screenshot below the title and question are all the same color I want them to be a different color. I have also attached the JSON I am using in formatting below. But basically I need help figuring out how to make the title in this case documentation different from the questions. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "hideSelection": true, "hideColumnHeader": true, "hideListHeader": true, "groupProps": { "headerFormatter": { "elmType": "div", "attributes": { "class": "sp-row-card" }, "style": { "color": "#333333", "background-color": "#F7F7F7", "flex-grow": "1", "display": "flex", "flex-direction": "row", "box-sizing": "border-box", "padding": "8px 12px", "border-radius": "6px", "align-items": "center", "flex-wrap": "nowrap", "overflow": "hidden", "margin": "4px 6px 6px 4px", "min-width": "max-content", "box-shadow": "0 1px 3px rgba(0,0,0,0.1)" }, "children": [ { "elmType": "img", "style": { "max-width": "28px", "max-height": "28px", "margin-top": "0", "border-radius": "3px", "margin-right": "12px" } }, { "elmType": "div", "children": [ { "elmType": "span", "style": { "padding": "4px 6px", "font-weight": "600", "font-size": "16px", "color": "#B31B24" }, "txtContent": "@group.fieldData.displayValue" } ] }, { "elmType": "div", "style": { "flex-grow": "1" }, "children": [ { "elmType": "div", "style": { "display": "flex", "flex-direction": "column", "justify-content": "center" } } ] } ] } }, "rowFormatter": { "elmType": "div", "attributes": { "class": "sp-row-pwc-bg" }, "style": { "display": "flex", "justify-content": "flex-start", "color": "#222222", "padding": "8px 16px", "border-radius": "6px", "max-width": "920px", "margin": "6px 8px 8px 60px", "background-color": "#FFFFFF", "box-shadow": "0 1px 4px rgba(0,0,0,0.08)", "align-items": "center", "flex-direction": "column" }, "children": [ { "elmType": "div", "style": { "text-align": "left", "font-weight": "600", "font-size": "16px", "color": "#E4002B", "user-select": "none" }, "txtContent": "" }, { "elmType": "div", "style": { "margin-top": "8px", "font-weight": "400", "font-size": "14px", "color": "#5A5A5A", "white-space": "pre-wrap" }, "txtContent": "[$Answer]" }, { "elmType": "button", "customRowAction": { "action": "defaultClick" }, "txtContent": "Show more", "attributes": { "class": "sp-row-button" }, "style": { "display": "=if([$ShowMore] == 'Yes', 'inline-block', 'none')", "margin-top": "10px", "color": "#FFFFFF", "background-color": "#E4002B", "border": "none", "padding": "6px 16px", "border-radius": "4px", "cursor": "pointer", "font-weight": "600", "font-size": "14px", "text-align": "center", "box-shadow": "0 2px 6px rgba(228,0,43,0.3)" } } ] } }11Views0likes0CommentsAdvice on what method of List to implement
Hello. I'm trying to implement a control of water meters readings. At first, I created a list for the equipments and one list for the readings, with a lookup column linking both lists through the equipment column in the first. But then i remembered the delegation limit. I have more than five hundred equipments and the readings must be registered in a daily basis and that data would surpass the delegation limits of five thousand rows in about two weeks. Because of that, I decided to create a list to each equipment, what would result in more than five hundred lists, but would give much more time (13 years) before the delegation limit for each equipment. But to avoid human errors on selecting the equipment, I'm failing on setting a default value for the readings lists and it made me rethink if that is really a clever idea. My question: what method should work best in this case? Or is there a better way to do it I'm not seeing? Thank you in advance!Solved89Views0likes3CommentsTo hide the file preview section in a SharePoint Document library gallery card with JSON
Hello All, I have a SharePoint document library and I created a gallery view for it. I displayed several columns/metadata on the gallery view. I want to disable/hide the file preview section in this card. I believe this can easily be done by changing some code in JSON at the Format view Advanced. However, I don't know how to do it. I hope there is someone, in this form, could be able to help me. Thanks in advanced.7Views1like0CommentsThis List is Empty - but it isn't
Hey all, I have a bug that I've never encountered before. I have a sharepoint list that was working perfectly fine until around 3 PM today. My sharepoint list has about 14 items in it. When I tried to view my sharepoint list, it said "this list is empty". My first thought was that someone accidently deleted the records, so I checked the recycle bin and there was nothing in it related to the list. I checked the sharepoint list under "site contents" and it lists about 14 items in the list (which is what I expect), but when I open the list, it still says "this list is empty". I have a power automate flow that triggers when a Microsoft form is sent, it gathers the response details and makes a row in this list with the content from that form. Again, this process was perfect for a solid week and I've used the same process for dozens of forms over 4 years with no issue. Where this gets really odd is that when I make a new Microsoft form response, my power automate flow runs perfectly and It appears it makes a sharepoint list item. Indeed, in the site contents, after submitting a new form response, the item count goes up by 1 for the sharepoint list. However, the list still says "this list is empty". I even made a new view that only shows a single row (no filters applied), that all 14 records have filled out, my sharepoint list refuses to show any data. I also can't seem to add columns, edit columns, or do what I would normally do for a sharepoint list. I am an owner of the sharepoint list and the form has permission inheritance on. What's even more odd is that I can run powerbi desktop and use my same account credentials to use the sharepoint list as a data source and all 14 rows show up PowerBi desktop, which leads me to believe that the data does actually still exist in the sharepoint list. Every other sharepoint list, including other sharepoint lists on the site, do not have this problem. If possible, I don't want to have to make another list since it's used for other power platform items. However, this is baffling me.68Views0likes1CommentSharePoint 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?79Views0likes1CommentHow 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.16Views0likes0CommentsSharepoint 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?38Views0likes1CommentSharePoint 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"`.24Views0likes0CommentsHow 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. AliSolved117Views0likes2CommentsWhy 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?Solved74Views0likes3Comments