Top 10 posts of 2018 on SharePointLibrarian.com

Thank you, friends, for making 2018 my best blogging year yet. I enjoy sharing what I learn along the way, and am glad to know it’s being found useful.

The following includes the ‘Top 10’ most popular posts by views published in 2018:

Solution: “We’re sorry. We can’t open {file} because we found a problem with its contents.”
When using SharePoint Designer workflows to automatically create documents from a template you might run into an error message: “We’re
Read more.
Customize styles/formatting of SharePoint list column header rows
Note: This post applies to on-premise/server lists or O365 lists set to “classic” view. This will not work on modern
Read more.
How to resolve SharePoint list view threshold error: “The view cannot be displayed because it exceeds the list view threshold…”
SharePoint lists have a default limit of 5,000 items per view. But lists can contain 30 million items (just not
Read more.
How to create a SharePoint Governance Plan (includes template)
What is governance? The Burton Group says “Governance uses people, process, technology, and policies to define a service, resolve ambiguity,
Read more.
Using today’s date and/or current time in calculated columns and list view filters
I previously shared how to create a “Today” column in SharePoint that would always be up-to-date even if list items
Read more.
Embedding Power BI Report Server (PBIRS) reports in SharePoint
If you’re on-premises and looking to embed a Power BI Report Server report in SharePoint, you’ll find it’s not as
Read more.
How to create a powerful date table or DateKey in Power BI
DateKeys are essential for relative time measures. In “manage relationships” you tie the ‘DateKey' to a date field in each
Read more.
View and share Power BI Report Server (PBIRS) reports full screen
The O365 Power BI Service has an easy “expand” icon on reports to make them full screen whereas Power BI
Read more.
Intro to conditional formatting & rules/validation when customizing SharePoint new item forms with PowerApps in Office 365
This is my intro to conditional formatting & rules/validation when customizing SharePoint new item forms with PowerApps in Office365. The
Read more.
Show last modified date for a SharePoint list without using code
How to display last modified date for a bulk-updated list in SharePoint without using code.
Read more.

Want more? Check out the archives for all previous posts:


Solution: “We’re sorry. We can’t open {file} because we found a problem with its contents.”
When using SharePoint Designer workflows to automatically create documents from a template you might run into an error message: “We’re
Read more.
Customize styles/formatting of SharePoint list column header rows
Note: This post applies to on-premise/server lists or O365 lists set to “classic” view. This will not work on modern
Read more.
How to resolve SharePoint list view threshold error: “The view cannot be displayed because it exceeds the list view threshold…”
SharePoint lists have a default limit of 5,000 items per view. But lists can contain 30 million items (just not
Read more.
How to create a SharePoint Governance Plan (includes template)
What is governance? The Burton Group says “Governance uses people, process, technology, and policies to define a service, resolve ambiguity,
Read more.
Using today’s date and/or current time in calculated columns and list view filters
I previously shared how to create a “Today” column in SharePoint that would always be up-to-date even if list items
Read more.
Embedding Power BI Report Server (PBIRS) reports in SharePoint
If you’re on-premises and looking to embed a Power BI Report Server report in SharePoint, you’ll find it’s not as
Read more.
How to create a powerful date table or DateKey in Power BI
DateKeys are essential for relative time measures. In “manage relationships” you tie the ‘DateKey' to a date field in each
Read more.
View and share Power BI Report Server (PBIRS) reports full screen
The O365 Power BI Service has an easy “expand” icon on reports to make them full screen whereas Power BI
Read more.
Intro to conditional formatting & rules/validation when customizing SharePoint new item forms with PowerApps in Office 365
This is my intro to conditional formatting & rules/validation when customizing SharePoint new item forms with PowerApps in Office365. The
Read more.
Show last modified date for a SharePoint list without using code
How to display last modified date for a bulk-updated list in SharePoint without using code.
Read more.