Two global navigation bars?
On the top of any page, I have the top navigation (Using Managed Navigation). But there is also another navigation bar directly below this one (which add a link for 'help') on some of the subsites, libraries, lists, etc. I am pulling out my hair trying to figure out where this is coming from and how to get rid of this. Can anyone help me, please?
Microsoft Lists
Just been looking into Lists in SharePoint and find its great how you can make it look and function great, very pleasing to use. I like how you can have version history on items too and also if someone did delete the list you can restore it. But what if you want to restore if from backup, what if someone deletes a column. I use AvePoint backup and it doesn't show the list as a list when i restore. It just shows a spreadsheet. I cannot then paste the spreadsheet into an empty list because some fields like People and multiple choice do not format correctly from the spreadsheet back into a list. Is it just AvePoint or are there solutions to backup Microsoft Lists and restore them as a list. I cannot see going forward with lists if you cannot restore from backup. Thanks
Accessing Page Properties as filter for a List (List Web Part or Embed Web Part, or other)
Hello... I've unsuccessfully scoured the web for an answer to this question, so I apologize if the answer is out there and I just can't get this to work. I have found a number of potential solutions that didn't seem to pan out, so I figured I'd start at the top and see if what I am is possible. Some "simplified" background (capitalized and quoted words refer to Sharepoint content entities) I have a standard set of management tools in the form of "Lists"; Action Items, Risk Management, Deliverables for example. These "Lists" contain the data for all projects in the organization. Each project has its own Sharepoint "Page" on the organization Sharepoint site. Should note these are "Teams" Site/Pages. Objective is to have a template page that can be copied when a new Project is started and limit the amount of manual configuration. Each data "List" has a common key - Project. In each list, the Project is a "Lookup" field that gets its value from a separate Project "List". I didn't want to use a "Choice" field since multiple "Lists" draw from the same set of Projects and thus limiting duplicative adding of projects when a new Project starts. What I want to do is include each "List" on a Project specific "Page" and since the lists contain data for all Projects I want to filter the list based on the Project field in the list. If I add the "List" as a "List Web Part", the only filtering capability is "Dynamic Filtering" which connects a filter field to something selected in another library or list on the page. With the "List Web Part" it seems the only solution is to have a "List View" preconfigured in the "List" specific for each Project and then the "View" can be selected in the "List Web Part" settings. This solution, although it works, is not ideal since for each new program we would have to create a new "View" in each "List" for the new Project and, after copying the template "Page" edit the "View" field of every list on the page. What I would like to do is key the filtering of the "Lists" based on the active Project "Page". I have added a Project field to the "Page Properties" and set the field to the Project name that is in the Project list to potentially use as the filter key value in filtering the "Lists". But I can't figure out how to make use of the "Page Property" in any of the web parts, whether trying to leverage json in some circumstances, or other potential solutions. I have tried various things using the "List" view formatting. The "View" filtering capability doesn't let you filter based on a "Lookup" field, but even if I did, I would still have to figure out how to reference the "Page" property that identifies the Project. I think the closest I have come is trying to use the "</> Embed Web Part". I can add this web part and set the website address to "https://....../Lists/AIList/AllItems.aspx?FilterField1=Project&FilterValue1=ProjectA" and it will populate the web part with the list filtered to only show the items associated with ProjectA. But what I want is to set the FilterValue1 to the Project "Page Property". I have seen references to page properties in various posts using @{Page.Project} (for example) or [$Page.Project] or perhaps other forms for various purposes, none of which have worked either in this "Embed Web Part" or attempts I have made in other potential solutions using json to try to control what is displayed. Sorry for the long post, but if anyone knows a way to achieve the desired effect it would be very much appreciated.
Restricting View/Edit/Create of Sharepoint List items to creator only
Hi Team, I need to build a feedback Power App that can read and write to a Sharepoint Online List held within a Private team ( the HR team for example ). All users need to be able to edit their own records and their managers can update ones assigned to them BUT if they look at the list directly, they are not allowed to see other peoples records. What is the best way to achieve this level of access control..? Can it be done using SharePoint lists or does it need to be managed through Power Apps/Power Automate somehow..?
Making 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)" } } ] } }
To 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.This 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.
SharePoint 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?How 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.
