Recent Discussions
Export list of users with unique permissions
Hello community, The context: We have a document library with 30 000 items. We broke inheritance and set up special permissions for some of them. Now we have about 30 items with special permissions that can be listed in Sharepoint Online. See the picture below. What we want: We want to get list of user on each item now. How can we do that? The output should look like this item1 - user 1 item1 - user 2 item1 - user 3 item1 - group 1 item1 - group 2 item 2 - user 1 item 2 - user 5 ... The idea We will write powershell script But can we identify items with special permissions the same way Sharepoint does it in the picture? How? How to use the API correctly because we cannot list each item (30k) in Sharepoint for performace reasons right? Related topics maybe? List of Unique Permissions from Site Settings | Microsoft Community Hub mentioning StephenRice18Views0likes0CommentsNot able to use "(" - opening bracket in SharePoint Online Webpart
I have an SPO site where I am creating multiple pages. Every single page prevents me from typing an opening/left parenthesis. I can type a closing parenthesis no problem. I've cleared my cache and restarted. It began recently - probably around the same time as the update where a closing parenthesis/quotation appears when you type an opening one.16Views0likes0CommentsSharePoint Designer 2013 is deprecated
I am not sure that this topic has been discussed before. https://learn.microsoft.com/en-us/sharepoint/what-s-new/what-s-deprecated-or-removed-from-sharepoint-server-subscription-edition According to this page the, July 14, 2026 after that date, SharePoint Designer 2013 will no longer be supported. But it looks like we still can create a publish workflows? Does any body have suggestion for 3. Parties’ solution for that. Did checked Nintex K2 and its very expensive. We just have 10 workflows send email with content in body. And one approval workflow. Any solution i can create with SPFX or in SP to have this opportunity to create WF. I know about VS but there are not that simple.28Views0likes0CommentsMaking 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)" } } ] } }11Views0likes0CommentsTables in Word Docs Stored on SharePoint Breaking
Custom Table Styles are breaking in Word documents stored on SharePoint. This started a week ago after a recent Office update. A solution of having only one person editing the document at a time defeats the purpose of SharePoint collaboration. Always editing in the desktop app is not a reliable solution either; not all tools are available in the browser. Tables break and fix themselves without intervention - sometimes in the desktop app and sometimes in the browser. Any insight is appreciated.16Views0likes0CommentsDeveloper dashboard says “You don’t currently qualify” – please enable E5 sandbox
Hi Microsoft team, I joined the Microsoft 365 Developer Program today with a personal Microsoft account from Austria. My profile page is now accessible, but my dashboard still says: “You don’t currently qualify for a Microsoft 365 Developer Program sandbox subscription.” Could you please manually enable my Microsoft 365 E5 sandbox tenant so I can start testing? Thank you very much for your help! Tino15Views0likes0CommentsSharepoint Webpart Discussion
I make a webpart using react language in that webpart I have create a form in that I have a dropdown in that I want to display all users of my community but currently only site users are displayed These are all the required code lines for populating dropdown :- const [users, setUsers] = React.useState<IDropdownOption[]>([]); const userResults = await sp.web.siteUsers(); const userOptions: IDropdownOption[] = userResults.map(user => ({ key: user.Id.toString(), text: user.Title })); <Dropdown label="Assigned To" options={users} selectedKeys={assignedToUsers} onChange={(_, option) => { if (!option) return; setAssignedToUsers(prev => option.selected ? [...prev, option.key as string] : prev.filter(k => k !== option.key) ); }} placeholder="Select Assigned to person(s)" multiSelect styles={{ dropdown: { width: "100%", marginTop: 10 } }} /> } For displaying all user I also tried the Microsoft Graph Api and changed according to that but these won't work so I now I am finding alternate option so please tell me if you have any solution24Views0likes1CommentChange 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.25Views1like1CommentAutomatically email supplier when their certificate expires
Good afternoon. I have set myself a challenge and really could do with some help. I have a list of suppliers like below. I have expiry dates set up, with a colour formatting to show any date past the current date. On the end of the row, there is an email address of the company contact. I want SharePoint to automatically email that person as soon as it turns red/expires. What is the simplest way of doing this? I have looked at Flows etc, and online on video tutorials, but some of the guides are old and out of date or very complex and I am a novice. Is anyone kindly, can give me a step-by-step guide on how to do this, as this would be just awesome and finally bring my company into the 21st century! Thanks in advance.49Views1like3CommentsTo 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.6Views1like0CommentsIndexing Ideas Needed - Parts I.D. Order in Libraries : Ex.) Parts R1 thru R10, R2...
GOAL: To resolve the subject line issue that is intensive and eliminates the following workaround. WORKAROUND A sequential number in a separate index number is formatted as a "Number". Many times I must export the library and add the number in MS Excel and paste these back into the library's index number column. IDEAS ON RESOLUTION Your thoughts on how to properly index the part I.D.s without a separate index number column are welcome including: Alternative formatting to apply to the alphanumeric Part I.D. description in the Part I.D. column to promote correct indexing Any programmed solutions Best regards, Clint Hill46Views0likes3CommentsPNP Search Results sort by title
Hi. I have a PNP Search results webpart, that brings me all the Document Libraries in SharePoint site (that are not the standard ones Like site assets, pages etc) I want the results to be sorted, but i tried with sort column and it does not work, I want it to show in alphabetical order If i use "edit sort order" and select by title, it gives me an error I added a RefinableString where i have the title but it is still not sorting it How can i get this list sorted without having to add another column for the Title (with out the link) THank you19Views0likes0CommentsCSOM: My “one query to rule them all” plan backfired — got “Request uses too many resources” 😅
Hey folks, So I’ve been playing around with CSOM (Client-Side Object Model), feeling fancy about making one super-efficient query that loads everything I need at once. Something like this: clientContext.Load( clientContext.Web, w => w.SiteUsers.Include(...), w => w.Lists.Include(...), w => w.SiteGroups.Include(...) ); Basically, my thought was: “Why make multiple calls when I can just get everything in one go?” But CSOM had other plans. Instead of being impressed, it hit me with the dreaded: "Request uses too many resources." Even when I tried to be nice and limit the properties, it still said “Nope.” 🙃 So now I’m wondering: Is it actually more efficient (and safer) to create a new ClientContext for each object I want to query (like Web, SiteUsers, Lists, etc.)? Or am I just thinking about this the wrong way and missing some batching trick? Would love to hear how others handle this — or if there’s a secret sauce to making CSOM not freak out when you ask for too much.8Views0likes0CommentsCSOM batch request: “Request uses too many resources” when loading multiple sites with GetSiteByUrl
I’m currently exploring CSOM (Client-Side Object Model) and analyzing how property values for client objects such as Web and Site are requested and returned in XML format. I used Fiddler to inspect the request and response bodies. I’m now trying to implement a batch-based query where I load multiple sites with a limited set of properties using the GetSiteByUrl method. However, I’m running into this issue: When I load 10 sites, I get the error: “Request uses too many resources.” When I reduce the number to 8 sites, it works fine. I also compared the bytes sent and bytes received for different batch sizes (screenshot attached). So my question is: Is there a specific limitation on the total request size (bytes sent/received) or number of operations in a single CSOM batch request? If yes, is there any official documentation or guidance on how to determine these limits? Thanks in advance!21Views0likes0CommentsDisable ready-made agents with Sharepoint Agents
Is there any way of disabling ready-made agents when using pay as you go with sharepoint agents. I want to restrict these ready-made agents in the sharepoint sites of my organization and deploy Copilot Studio agents in sharepoint for some sites. Is any way of achieving this without making use of copilot licenses? There is a way using "Restricted content discovery" but this needs at least one copilot license and this feature I think that disables the use of that sharepoint site as knowledge source for future copilot studio agents while it is active.15Views0likes0CommentsThis 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.67Views0likes1CommentActive 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?12Views0likes0CommentsSharePoint Missing Authentication for _vti_bin
The issue with the vti_bin folder is that it is accessible without authentication. However, the remediation measures outlined below are not technically feasible for SharePoint Online (O365). I found few remediations for this issue which are as follows: Configuration Options: Administrators can configure authentication for _vti_bin through various methods, such as: Enabling anonymous access:This allows anyone to access the site and its resources, including _vti_bin URLs, without logging in. Restricting access in Web.config:The Web.config file can be modified to deny access to anonymous users for specific _vti_bin paths. Using the ViewFormPagesLockDown feature:This feature can help restrict access to certain SharePoint resources, including those within _vti_bin The below links are for reference: https://www.c-sharpcorner.com/uploadfile/Roji.Joy/how-to-secure-external-anonymous-access-to-sharepoint-2010-sites/#:~:text=Even%20when%20lockdown%20mode%20is, https://learn.microsoft.com/en-us/archive/blogs/fabdulwahab/security-protecting-sharepoint-server-applications https://sharepoint.stackexchange.com/questions/167264/restricting-access-to-contents-in-vti-bin-for-both-authenticated-as-well-as-a I would like to verify whether the provided fixes are applicable to O365 SharePoint. If they are not, could you please advise on alternative solutions that can be implemented to mitigate this issue?21Views0likes0Comments
Events
Recent Blogs
- SharePoint document libraries are getting some major upgrades! We’re excited to share several improvements rolling out now (or very soon) that make libraries more user-friendly, powerful, and in...Nov 04, 20252.8KViews3likes2Comments
- 2 MIN READWe are excited to start a new blog post series focused on the different partner offerings around SharePoint in Microsoft 365. In this first post, we focus on Advania’s Fresh Intranet – an AI pow...Nov 04, 20251.2KViews3likes0Comments