Hi all
Welcome to Tips and Tricks on SharePoint, Power Platform and other Microsoft 365 services.
Enjoy!
-
2025-02-15
Add users to SharePoint without sending them an email
Usually, if you invite users to your site, they will receive an email notification. Here is how to avoid it.
-
2025-02-15
Report on files with unique permissions
Show your users which files have permissions different than the rest of the library. For security and administrative purposes the library owners review the files and the granted access regularly.
-
2025-02-09
Disable attachments in SharePoint list
You may want to disable list attachments to maintain a cleaner or more secure list environment. Here's how you can do this for one or multiple lists.
-
2025-02-09
Create download link to SharePoint file
When you create a link to a file in SharePoint using the standard method, it opens in the browser by default. Make the file downloadable instead, by customizing the link.
-
2025-02-08
Customize Microsoft 365 login page
With Microsoft 365, you can customize your sign-in page and have a company-branded login experience for your users.
-
2025-02-08
Viva Engage vs Teams
A comparison of Viva Engage and Teams to help you understand when to use each
-
2025-02-02
Why use Viva Engage?
This article outlines the advantages and purposes of using Viva Engage.
-
2025-01-05
Site Pages library in Power Automate Flow
This article shows how to use Site Pages library in Power Automate flows.
-
2024-12-30
Exchange Online: What mailboxes User has access to?
The article describes a way how to verify user’s access rights to other people’s mailboxes.
-
2024-12-29
Viva Engage: View Analytics
As a leader or a corporate communicator managing campaign you can view the audience summary of your campaign. Have a look at some of the cool options that Viva Engage is offering.
-
2024-11-30
Create SharePoint dashboard
A dashboard in SharePoint is a page primarily designed for mobile use, providing users with quick access to essential tools and resources. Use PnP Powershell and choose Dashboard layout to create a dashboard.
-
2024-11-23
Customize your page header
You may want to disable list attachments to maintain a cleaner or more secure list environment. Here's how you can do this for one or multiple lists.
-
2024-11-17
Compare SharePoint tenant settings
The “Run As” feature in the Microsoft 365 admin center allows administrators to simulate and test various admin roles. It allows to test the permissions associated with every Microsoft 365 admin role.
-
2024-11-16
Microsoft 365: Run As [Product] Admin
The “Run As” feature in the Microsoft 365 admin center allows administrators to simulate and test various admin roles. It allows to test the permissions associated with every Microsoft 365 admin role.
-
2024-11-09
Microsoft 365: compare admin role permissions
In Microsoft 365 admin center you can now compare various administrators’ roles and select the one with minimum privilege for your admin accounts. The comparison lists detailed permissions of each role, and can be used for Compliance or ISO Documentation.
-
2024-11-09
SharePoint list view: hide new button
This article will give you a few JSON formatting examples on how to hide buttons in the command bar of a SharePoint list view, such as “add new item”, or “automate”.
-
2024-11-03
Remove Community Resources in Viva Engage
On the right-hand side of your Viva Engage Community you can see the available Resources such as SharePoint Site, Planner and OneNote. With the newest update from Microsoft you can now hide these Resources on the main page of the Viva Engage Community.
-
2024-10-03
Move Viva Engage conversation to another community
You can move a Viva Engage conversation to another community or stop users from moving posts to your community.
-
2024-08-18
Find content type ID using Powershell
Content type IDs in SharePoint uniquely identify the content type. This article helps you find the ID using Powershell.
-
2024-08-18
How to find SharePoint Online content type ID?
Content type IDs in SharePoint uniquely identify the content type. This article helps you find the ID using User Interface.
-
2024-08-11
Get version history programmatically
The following PnP Powershell cmdlets can help you retrieve the older versions for each SharePoint file.
-
2024-08-11
Count files or items with unique permissions using Powershell
Using PnP Powershell you can programmatically count files in a folder or the entire library in SharePoint Online that have unique permissions.
-
2024-08-10
Count files in a folder using Powershell
Using PnP Powershell you can programmatically count files in a folder or the entire library.
-
2024-08-03
Update SharePoint list item without changing the modified date
If you want to use multiple content types in your SharePoint list, you need to enable content type management first. Here is how to do it using PnP POwershell, Powershell & CSOM or simply your browser.
-
2024-08-03
Update SharePoint list item without changing the modified date
Updating SharePoint list item without changing the modified date is often called a system-update. This article shows you how to do it using PnP Powershell.
-
2024-08-03
Update SharePoint folder without creating a new version
How to update a SharePoint Online folder without creating a new version or triggering a workflow.
-
2024-08-01
Add SharePoint site permissions to a group using PnP
Using the PnP PowerShell module, you can assign permissions to an existing group within the Microsoft 365 environment. It can be a SharePoint group, security group or Microsoft 365 group.
-
2024-08-01
SharePoint Claims Deep Dive
In SharePoint Online, user and group identities are represented by different claim providers, which determine how identities are authenticated and identified within the system. SharePoint claim provider prefixes are used to format login names and indicate the type of authentication and the source of the identity claim.
-
2024-07-21
Modify Microsoft 365 group settings
Microsoft 365 group settings configured using the Set-PnPMicrosoft365GroupSettings cmdlet can be viewed and managed in various places within the Microsoft 365 admin center. However, not all settings may have a direct user interface (UI) counterpart, as some configurations are more advanced and typically managed through PowerShell.
-
2024-07-14
Conditional query in PNP Search Webpart
In SharePoint Search, especially when using the PnP (Patterns and Practices) Search Web Part, you can use the KQL (Keyword Query Language) search query template to build dynamic queries. The search query template allows for conditional logic using tokens and variables, but it's not as straightforward as using traditional programming "if" statements. By using the `{?{ }}` syntax in your PnP Search Web Part query template, you can introduce dynamic, conditional logic similar to "if" statements in programming.
-
2024-07-14
PnP Search query examples with KQL
KQL (Keyword Query Language) is a syntax used primarily within Microsoft products like SharePoint and Microsoft Search to formulate search queries. Understanding its basic rules and operators such as `AND`, `OR`, and other principles is crucial for constructing effective search queries. Here’s a breakdown of these rules with some examples.
-
2024-06-02
Manage Viva Engage with Graph API
Get, create and manage your Viva Engage communities using Graph API. Examples with Graph Explorer and explanation of the API. Read on...
-
2024-05-26
Close conversations in Viva Engage
There is a variety of reasons why you should be closing Viva Engage conversations. A guide to keeping your Viva Engage community in orderly fashion
-
2024-03-24
Hide Teamify Prompt
In SharePoint, when a site is created without being associated with a Microsoft 365 group or a Microsoft Teams team, users typically encounter a teamify prompt displayed in the bottom left corner of the site interface. You can remove this teamify prompt using a PnP cmdlet...
-
2024-03-24
Easy way to create CAML Query for list view
When loading thousands of SharePoint list items, you may want to limit the number of retrieved results. The GetItems(CamlQuery) method allows you to define a Collaborative Application Markup Language (CAML) query that specifies which items to return. Creating a complex query, however, can present quite a challenge. To make sure every slash and value are exactly where they should be, it's easier to create a view using User Interface and then copy the CAML Query behind it. In this article, I am showing how to do it
-
2024-02-17
Remove a Viva Engage leader
The leadership feature in Viva allows you to identify the leaders in your organization and the leaders to reach their targeted audiences. When you want to remove the leader functionalities from a user, you need to remove him from the leaders list in the Viva Admin Center.
-
2024-02-03
Viva: How to post as a delegate
Now, you can post on behalf of another person in Viva Engage. This feature allows Viva Engage users to assign a delegate who can post on behalf of them. Configure it through Yammer’s settings section...
-
2024-02-03
Viva Engage: Leaders vs Corporate Communicators
Viva Engage provides two special privileged roles that allow users for extra communication capabilities. One of them is Leaders and the other Corporate Communicator. The article compares the two roles.
-
2024-01-14
Post as a leader to specific groups
The leadership feature in Viva allows you to identify the leaders in your organization and the leaders to reach their targeted audiences.
-
2023-11-04
Add Viva Engage to your SharePoint pages
Viva Engage Conversations web part allows page viewers to participate in discussions without exiting the SharePoint environment. Use it to replace your old comments section with Viva Engage discussions.
-
2023-11-05
Office Online Server Troubleshooting in Sharepoint Environment
Office Online Server Troubleshooting in Sharepoint Environment
-
2022-08-05
Audit your sensitivity labels with Powershell
Audit your sensitivity labels with Powershell
Links to my older Social Technet Articles:
Content Types
- SharePoint Online content types in Powershell: Add
- SharePoint Online content types in Powershell: Get
- SharePoint Online content types in Powershell: Edit
- SharePoint Online: Remove site content type using PowerShell
- Content Type is still in use: Powershell to remove items and content types
Versioning
- Versioning and SharePoint: the Powershell perspective (part 1)
- Versioning and SharePoint: the Powershell perspective (part 2)
- Working with multiple items using Powershell
- Delete unique permissions in multiple lists using CSOM
- Create a report on SharePoint file versions
Workflows
- SharePoint Online: Verifying and modifying Flows Policy in site using PowerShell
- Reject? Approve? The third option in SharePoint Designer 2013 workflows
- Error handling in Microsoft Flow
Permissions & Sharing
- SharePoint Online: How to change primary administrator for all site collections using PowerShell
- Restoring and removing item permissions in subfolders for SharePoint Online using Powershell
- SharePoint Online Sharing settings with CSOM
- SharePoint Online: PowerShell to delete unique permissions in all list items
- SharePoint Online: Remove users from site groups using PowerShell
- Manage SharePoint Online Access Requests using Powershell
- SharePoint 2013/2016: Approve or decline Access Requests using Powershell and CSOM
OneDrive for Business
- PowerShell: OneDrive for Business usage report
- OneDrive for Business notifications with Powershell
- OneDrive for Business sharing settings with PowerShell
Other
- Get all checked-out files using Powershell
- SharePoint Online: Disable or enable attachments to list items using Powershell
- SharePoint Online: Get any object with PowerShell
- Powershell GridView to help with SharePoint data viewing
- SharePoint 2016 Troubleshooting: Installation error - The tool was unable to install Web Server (IIS) Role
- Powershell in SharePoint: Disable comments on modern pages in entire site using CSOM
Office 365
- Office 365 PowerShell Troubleshooting: quick guide
- Office 365 data loss protection: Prevent your SharePoint list from deletion using Powershell