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.
Change in SharePoint File Selection Behaviour
Has anyone noticed this in the last week/s? Basically before, you used to be able to SELECT files without opening them. Now, 5-6 times out of ten, if I try to select a document or folder it opens instead. Like, even when i am clearly clicking the checkmark to the left of the file/folder, it will STILL OPEN in the browser, rather than just selecting. It's like the file open behaviour has gotten more sensitive or something? It's really frustrating because my users need to add metadata to documents by selecting them, and now they have to fight with SharePoint nearly every time.
Active Site Usage Not Matching Storage Used?
At my new position our SharePoint storage is getting used quickly. As of right now we have 69GB available of 11.75TB. When look at the active sites the total Storage Used only adds up to 2TB. Where is the other 8.75TB coming from? Version history was changed to 100 major versions and to delete versions after 1 year. Is it possible that the versions still being retained could add up to 8.75TB? I archived a site that was 13GB but it's still showing 69GB available. How long does it take to reclaim that storage?Clarification on StorageQuota and BonusStorageQuotaMb in SharePoint Online (CSOM / PowerShell)
I’ve been using CSOM and the Get-SPOTenant PowerShell cmdlet to retrieve storage-related data for my SharePoint Online tenant. I noticed that the StorageQuota property accurately reflects the total storage available. However, I plan to purchase additional SharePoint Online storage and would like to clarify: Will the newly purchased additional storage be included in the value returned by the StorageQuota property? I also came across another property called BonusStorageQuotaMB which does not have any documention and seems like new one too— could someone please explain its purpose and how it differs from StorageQuota? Understanding how these properties behave is important for me to monitor and report tenant storage accurately. Thanks in advance for your insights!Clarification on StorageQuota and BonusStorageQuotaMb in SharePoint Online (CSOM / PowerShell)
Hi everyone, I’ve been using CSOM and the Get-SPOTenant PowerShell cmdlet to retrieve storage-related data for my SharePoint Online tenant. I noticed that the StorageQuota property accurately reflects the total storage available. However, I plan to purchase additional SharePoint Online storage and would like to clarify: Will the newly purchased additional storage be included in the value returned by the StorageQuota property? I also came across another property called BonusStorageQuotaMB — could someone please explain its purpose and how it differs from StorageQuota ? Understanding how these properties behave is important for me to monitor and report tenant storage accurately. Thanks in advance for your insights!
I need to speak to a person at Microsoft
Firstly, I don't know if this is the correct place to ask, if not, I apologise, and would be greratful if I could be directed to the correct medium. So..... *** I am writing this on behalf of someone else *** His account has been locked after he had been hacked and infected with a virus, and Microsoft will not unlock it. However, they have decided (today) to take his money for his 365 subscription, that he can't use, and doesn't want. When looking for a way to cancel it, the answer is log-in to his account and cancel it himself. BUT, he can't log in because the account is locked. He has tried looking for a phone number to speak to someone, but cannot find any. He has tried looking for a Live Chat, but, (if it exists) it is only available after he logs in. He just wants to cancel the subscription, and get a refund. Can someone please give me a contact number - preferably in the UK, but any English speaking representitive, in any countrty will do. Thanks,Quick Links “Button” layout drawers stuck open on modern SharePoint page
We’re using the Quick Links web part in Button layout on a modern SharePoint Online page. Normally, the label “drawer” only appears when you hover over the button. Recently, the drawers under all buttons are stuck permanently open (see red lines below marking the title drawers that I want to disappear). We must use the Button layout for our design standards, so switching to another layout is not an option Our IT team says there’s no HTML/CSS toggle to control this, and publishing an older page version would undo recent changes without guaranteeing a fix Rebuilding the web part isn’t realistic since we don’t have all the original links and images. This has happened before, but usually it “clears up” after some time — this time it’s persistent. Has anyone else run into this? Is this a known regression with Button layout, and is there a fix? Any guidance would be appreciated.
Cannot change a content type template's url anymore
Hello, I created a new content type for my site, everything works well, however I'm unable to change it's template url (Advanced settings -> use existing model). This is the error that appears once I hit the save button: This roughly translates to: "Unable to update advanced settings. A Web-type file cannot be attached as a template." Now this is strange because in the past I could do this without any issue. Has something changed in the template system, or could it possibly be a bug? Thanks in advance
AI- 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?New blog: Do We Really Need to Buy More SharePoint Storage?
I’ve published a new blog post exploring a common question: Do we really need to buy more SharePoint storage? In this article, I cover: How SharePoint storage is calculated What counts towards your storage quota Practical strategies to optimise storage before purchasing more When it actually makes sense to buy additional storage 📖 Read the full post here: Do You Really Need More SharePoint Storage? | Optimisation Guide If you’re managing SharePoint Online or Microsoft 365 storage, this guide will help you make informed decisions and avoid unnecessary costs.
