User Profile
lsittler
Brass Contributor
Joined May 18, 2017
User Widgets
Recent Discussions
Re: SharePoint Visitor Permissions Group - Teams Phones License
Hi Chris_Clark1968 What you’re observing is by design. The “Everyone except external users” (EEEU) claim includes all internal Entra ID identities, not just human users. This means it will also include service accounts, admin accounts, room/resource mailboxes, and other non‑person identities. As a result, using EEEU can lead to unexpected side effects, including licensing evaluations (for example Teams Phone), even for accounts that should never be licensed. Because of this, EEEU is generally not recommended for controlled or governed scenarios: You cannot manage or filter its membership It includes non‑human identities It increases the risk of oversharing and licensing noise Microsoft is progressively discouraging its usage in modern SharePoint and OneDrive scenarios https://learn.microsoft.com/sharepoint/data-access-governance-everyone-except-external-user-report?wt.mc_id=MVP_386670 I can recommend you the approach to disable/hide this claim at the Tenant level: Set-SPOTenant -ShowEveryoneExceptExternalUsersClaim $false Then, replace it by a Dynamic Security Group (for example, All Employees) using a rule such as: (user.accountEnabled -eq true) -and (user.userType -eq "Member") -and -not (user.userPrincipalName -startsWith "svc.") -and -not (user.userPrincipalName -contains "-adm@") This query is based on the following assumptions: Service accounts following a naming convention (svc.*@contoso.com) Admin accounts with suffix (-email address removed for privacy reasons) Guest accounts containing #EXT# in the UPN (this is Microsoft OOB behavior) and have userType = Guest Only enabled accounts should be included If you have additional user attributes available in your tenant (for example, department, company name, or custom attributes), you can further refine this rule to better match your use case. I hope this helps. Best regards15Views1like0CommentsRe: Managed MetaData and Document Libraris
Hi akelly, Great question — this is a very common requirement in SharePoint Online. In the modern experience, there’s currently no supported way to display a modal or popup when users drag & drop files into a document library in order to force metadata entry. That said, when required metadata columns are configured on a library, SharePoint does enforce completion in a different way: 👉 If a document is uploaded without all required fields completed, it remains incomplete (and checked out if versioning/check‑out is enabled). In that state, the file is only visible to the author and site administrators until the metadata is filled in. 👉 If your goal is to enforce metadata usage, here are a few approaches, ordered from the most out‑of‑the‑box to the most custom: Default column values (per folder or library): helps prefill metadata; users can adjust values if needed. Document Sets: useful when documents belong to a structured container with shared metadata. ➡️ The following options typically rely on an intake experience rather than allowing users to upload files directly into the library: SharePoint Library Forms (internal users only, external accounts not supported yet): allows file upload through a form that can require metadata before submission. Microsoft Forms + Power Automate: common pattern to collect files and metadata, then route them into SharePoint. Power Apps custom forms: replaces the default file properties form and allows richer validation and UX. Custom development solutions: for example SPFx, a dedicated upload portal, or third‑party solutions. Hopefully this gives you a clearer picture of what’s possible today and which option best fits your scenario. Best regards32Views0likes0CommentsRe: SharePoint HomeSite Does HomeSite replace Start Page or other functionalities When enabled?
Hi green60, Since my latest answer, maybe you will be interested in the future new SharePoint start page. It has not been released yet, but interesting to know if this one can match your needs and expectations. - https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=&searchterms=124824 - Microsoft SharePoint Roadmap Update - May 2024 - Microsoft Community Hub 😉389Views0likes0CommentsRe: SharePoint HomeSite Does HomeSite replace Start Page or other functionalities When enabled?
Hi green60, The SharePoint Home Site has not the same purpose of the SharePoint Start Page. SharePoint Start Page Enable by default, this system page (_layouts/15/sharepoint.aspx) allow users to access quickly the: Following sites Recent sites Frequent sites Suggested sites Save for later In addition to finding most SharePoint Sites quickly and easily, it is possible to create a new Site and Create New Post. Important: This page cannot be modified. SharePoint Home Site It is a SharePoint Site Collection - /[teams|sites]/[homesite] It is such as a "Global Intranet" for your Tenant. You can use most of the OOTB Web Part to build an awesome page to improve the user experience. You can't replace the Start Page with your Home Site but you can: Remove the SharePoint ShortCust from the App launcher and create an Org one to redirect users to your home site Specify a custom Tenant/Org logo with an URL to redirect users to your Home Site Some additional features are linked to the home site: Control the SharePoint App Bar Viva Dashboard Now required for Viva Connection It is the official source of organizational news (visible from the SharePoint Start Page) You can find additional information in the Microsoft Documentation: https://learn.microsoft.com/en-us/viva/connections/home-site-plan I hope this information will help you.992Views1like1CommentRe: Template SharePoint Library?
Hi WYellow, Here, it seems the same subject as yours with a Microsoft answer: https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-create-a-document-library-template-in/6aef9586-3bdd-4f65-a9e6-5e488b82b73e The conclusion is: currently, no easy way - to create a Template by script or automation. - https://pnp.github.io/powershell/: extract existing library as Template (XML) and import it to another site - https://pnp.github.io/cli-microsoft365: script the configuration of your library - Power Automate / Logic App: you can use REST API to create or use an existing library and apply all settings Hoping this information will help you 🙂2.1KViews1like1CommentRe: Hub Site Logo not updating on associated sites
Hi KCRyan37, The logo of the Hub site is not synced with the associated site. Why? Here is an example of a use case: You have a Hub site Intranet, and you have associated all departments of your organization with this hub. Each department has is own logo (HR, IT, Finances, etc.) What is "synced" between the hub site and an associated site: - Hub site navigation (shared navigation😞 a common navigation bar located at the top of all sites - Theme - Hub Visitors: you can sync hub permissions to associated sites (limit of 10 groups/users visitors only) One other purpose of the HUB sites is to capitalize/merge the Search content from all the associated sites. In this case, you can use the OOTB Web Part to display the content of the Hub and all associated sites: https://support.microsoft.com/office/c2dcee50-f5d7-434b-8cb9-a7feefd9f165 https://support.microsoft.com/office/e34199b0-ff1a-47fb-8f4d-dbcaed329efd https://support.microsoft.com/office/93cbd17b-0bf8-4355-9f32-cc90e0443e6d https://support.microsoft.com/office/5fe4da93-5fa9-4695-b1ee-b0ae4c981909 Hoping this information will help you 🙂1.5KViews1like0CommentsRe: MC211640: Conditionally show or hide columns in a SharePoint list or library form
Hi Vikram_Samal, thank you for your answer. I understand that Power Apps is the solution to create custom form but I had hope that SharePoint could have a simple feature like this because the formula is available for the edit mode too. It is complicate to explain to the final users that, yes you have a conditional formula but no it does not work like that. Create a Power Apps for a simple use case like this one is pretty huge (potentially with authorizations, licences and external sharing). Anyway, it is noted. That you for your time 🙂39KViews0likes0CommentsMC211640: Conditionally show or hide columns in a SharePoint list or library form
After several attempts to operate a conditional field on item form, the formula still invalid. The use case is the following one: 1 column Provider, type Choice with 2 values 2 other columns msProducts and pnpProducts, type Choice When the provider is equals to Microsoft, the column msProducts should appear From the default SP form, click on Edit form > Edit columns > (Ellipsis on msPorducts) > Edit conditional formula The tested formulas with invalid condition are: =if([$Provider]=='Microsoft', 'true', 'false') : formula suggested by the official documentation https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide =if([Provider]=='Microsoft', 'true', 'false') =if(Provider=='Microsoft', 'true', 'false') The same tests are performed by replacing '==' by '=' and by removing the simple quote around true & false This formula is valid but does not work =if(@Provider=='Microsoft', 'true', 'false') The conditional formula is not functional currently or something is wrong?Solved40KViews1like9Comments
Recent Blog Articles
No content to show