Forum Widgets
Latest 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 StephenRice
Not 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.
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)" } } ] } }
Tables 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.Sharepoint 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 solutionChange 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.
Automatically 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.
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.Indexing 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 Hill
