Writings and ramblings on SharePoint for those who are addicted to it!
The following is a SharePoint dictionary word of the day:
Collaborative Application
Markup Language (CAML)
An XML-based language that is utilized to describe various
elements, such as queries and views, in sites that are based on the Microsoft
SharePoint technology base.
Cell
A box that is shaped by the intersection of a row and a
column in a worksheet or a table. A cell can contain numbers, strings, and
formulas, and use different formats on that data.
Cell contents
The information within a cell, such as text, values,
formulas, cell errors, etc.
Cell error value
Any of a number of special values that are returned as a
result of an unsuccessful formula calculation.
Cell formatting
The settings that specify the presence of a cell, such as
font characteristics and fill color.
Cell reference
The set of coordinates that a cell uses in a worksheet.
Example, B2 is the reference of a cell that shows at the intersection of column
B and row 2.
Cell value
A phrase for the text or numeric content of a cell, or the
results of a formula.
The following is a SharePoint dictionary word of the day:
Capacity planning
Process of classifying and preparing for an application,
hardware, and network options to anticipate site traffic, growth and failover in
order to attain site performance goals.
Calculated column
A column in a table which utilizes a formula that is copied
automatically to each record in the column or in another column if applicable.
The following are SharePoint dictionary words of the day related to Business Data:
Business data actions
A program or web page, available by using its uniform
resource locator (URL), that can be connected with an external content type so
that users can achieve the action on the specific elements of that type.
Business Data Catalog (BDC)
A service which collects information in regard to business
application data that occurs outside the server farm. Such a service can be used
to show business data in lists, web parts, search, user profiles, and custom
applications.
Business data connectivity
service application
An installed occurrence of the business data connectivity
shared service.
Business data connectivity
shared service
The SharePoint shared service that delivers a means for
storing and securing external content types, application models, and external
data sources.
The following are some good sites around SharePoint and Viva:
Create a SharePoint home site for Viva Connections:
https://learn.microsoft.com/en-us/viva/connections/create-sharepoint-home-site-for-viva-connections
Add SharePoint as a content source for Microsoft Viva Learning:
https://learn.microsoft.com/en-us/viva/learning/configure-sharepoint-content-source
Plan, Build, and Launch a Home Site for Your Organization:
https://learn.microsoft.com/en-us/viva/connections/home-site-plan
Overview of Viva Connections:
https://learn.microsoft.com/en-us/viva/connections/viva-connections-overview
Microsoft Viva Overview:
https://learn.microsoft.com/en-us/viva/microsoft-viva-overview
The following is a SharePoint dictionary word of the day:
Alert
An Internet communication that is sent to subscribers
automatically to notify them when certain criteria are met. Alerts are once
set-up are automatically sent when items such as documents, web pages, list
items, sites, or other assets have changed.
The following is a SharePoint dictionary word of the day:
Activities
Tracked updates associated to an explicit user. These items
are often related to the user’s social collaboration within SharePoint (such as
tagging, rating, likes, etc.).
The following is a SharePoint dictionary word of the day:
Action
The tiniest component of work in a workflow
system. An action can comprise one or more responsibilities that define work
that needs done.
Account administration
site
Web site which
allows administrators and end users to manage accounts that access
Microsoft/Office 365.
The following is a SharePoint dictionary word of the day:
Absolute path
A string that displays the location of a file and starts
with a drive identifier and root directory or network share and ends with the
applicable file name. Example: C:\Documents\Work\testexample.txt and
\\netshare\Documents\Work\testexample.txt.
The following are three good sites to help with SharePoint Online and Power Automate aspects:
Use SharePoint and Power Automate to Build Workflows:
https://learn.microsoft.com/en-us/power-automate/sharepoint-overview
Guidance - Migrate from Classic Workflows to Power Automate Flows in SharePoint
Create a Flow For a List or Library - Microsoft Support
SharePoint Online has some great simple project management features to be aware of:
1) It can be utilized as a central repository for project documents
2) It can be utilized to store and link to project plans (via Planner or via those created via a list)
3) It can be utilized to store calendar based information
4) It can be utilized as an issue log using out of the box list templates
5) It can be utilized for timesheet management via stored documents or created lists
6) It can be utilized to store project tasks via links to Planner, stored documents or via created lists
7) It can be utilized to store documents and make them manageable via a proper meta-tag-based strategy by type of document
The following are three aspects to promote emotional intelligence within a SharePoint environment:
1) Using Power Automate flows to integrate cognitive services into SharePoint content.
Example, a flow can process text input for sentiment, key phrases, translation, etc.
2) Using SharePoint lists to keep track of data and making it easier to build, edit, share and analyze.
Example, a flow for cognitive analysis can process text for sentiment, key phrases, translation, etc.
3) Using Power Apps and artificial intelligence to be able to take turn Excel spreadsheets and convert them into an app.
Example, an Excel spreadsheet can be turned into a PowerApp via common wizard aspects then can be available in the web and mobile desktops.
The following are ten serious risk factors that will effect a SharePoint project:
1) Having inaccurate metrics
2) Having inadequate measurements
3) Having schedule-based pressure
4) Having management issues
5) Having inaccurate cost estimates
6) Having the need to have everything perfect before launching
7) Having a creep in user requirements
8) Having low quality content and code
9) Having low productivity from core team members
10) Having the project cancelled
The following are five important SharePoint artifacts for project success:
1) Have good written SharePoint requirements
2) Have good SharePoint architecture in place
3) Have good SharePoint code and manage and maintain the versions
4) Have a good SharePoint project plan
5) Have a good SharePoint test plan
The following are Microsoft services that are good to know about:
Microsoft ERP which includes Dynamics 365.
Microsoft Cloud Applications which includes Microsoft 365 (M365), Azure Apps, PowerApps and SharePoint Online.
Microsoft Analytics which includes PowerBI and PowerApps.
Microsoft Azure Data Platform which includes Azure Data Lake.
Microsoft Azure Cloud Platform Services which includes Azure, Platform as a Service (PaaS), Infrastructure as a Service (IaaS) and Software as a Service (SaaS).
Microsoft Application Development Support which includes web, desktop, mobile app and devops.
Microsoft Migration and Integrations which includes cloud migration for Azure and Microsoft 365 (M365).
The following are eight good aspects to offer if you are a SharePoint consultant:
1) SharePoint project management consulting
2) SharePoint development aspects
3) SharePoint upgrades and integrations
4) SharePoint system administration
5) SharePoint health check and audit aspects
6) SharePoint compliance and permissions set-up
7) SharePoint meta-data tagging strategy
8) SharePoint system performance monitoring
The following are three key SharePoint consulting aspects:
1) Provide the expertise and guidance needed to design the solution
2) Supply talent and resources to execute the project in a quality way
3) Allows staff to focus on higher-value tasks
The following are some good information sites for Power Platform and PowerApps information:
Microsoft Power Platform: Learning Resources:
https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/
Power Apps Automate Processes:
https://powerapps.microsoft.com/en-us/automate-processes/
PowerApps Building:
https://powerapps.microsoft.com/en-us/build-powerapps/
PowerApps Blog:
https://powerapps.microsoft.com/en-us/blog/
Power Platform Code Samples:
https://learn.microsoft.com/en-us/samples/browse/?products=power-platform
Power Platform Documentation:
https://learn.microsoft.com/en-us/power-platform/
When working in SharePoint, the following are twelve key aspects to be an expert in and account for:
1) Quality engineering
2) Quality assurance
3) Next generation automation
4) Digital assurance
5) Digital transformation
6) Performance engineering
7) Mobile test automation
8) Cloud testing
9) Business intelligence testing
10) Security testing
11) Achieve high-speed quality
12) Agile driven center of excellence
The following are four key SharePoint project life cycle aspects:
1) Value of the project management process is key
2) Create projects using created templates
3) Control the project process with stage gates
4) Obtain reporting visibility on projects
The following are some good sites for SharePoint Government based reference:
SharePoint for US Government Environments:
Office 365 Government:
Plan for Office 365 Government - DoD deployments:
https://learn.microsoft.com/en-us/microsoftteams/plan-for-government-dod
OneDrive for US Government Environments:
Use the Government Cloud for SharePoint and Microsoft 365:
https://learn.microsoft.com/en-us/microsoft-365/community/government-cloud
Office 365 U.S. Government DoD Endpoints:
The following are good reference sites to utilize for Microsoft lists:
Microsoft Lists Resources:
https://adoption.microsoft.com/en-us/microsoft-lists/resources/
Introduction to Lists:
Create a List:
https://support.microsoft.com/en-us/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083
Use Column Formatting to Customize SharePoint:
https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
Configure the List Form:
https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration
Column Formatting:
https://support.microsoft.com/en-us/office/column-formatting-1f927342-2bed-4745-b727-ff8b7ff96b22
The following are good sites to learn Power Platform basics:
What is the Microsoft Power Platform?
https://powerplatform.microsoft.com/en-us/what-is-power-platform/
Microsoft Power Platform Documentation:
https://learn.microsoft.com/en-us/power-platform/
Introduction to Microsoft Power Platform for Developers:
https://learn.microsoft.com/en-us/power-platform/developer/get-started
Describe the Business Value of the Microsoft Power Platform:
https://learn.microsoft.com/en-us/training/modules/introduction-power-platform/
The following are three key SharePoint project aspects to utilize:
1) Have a SharePoint service catalog in order to process service requests faster
2) Have a SharePoint ticketing system which contains canned responses and smart suggestions to help users resolve tickets faster
3) Have a SharePoint cost-effective license which has the best features per a value pricing model
The following are four good aspects to consider for a SharePoint training plan:
1) Coordinate the implementation and training for the SharePoint technologies
2) Put together the needed SharePoint material. Use these sites for help or link to:
https://support.microsoft.com/en-us/sharepoint
3) Rollout the SharePoint material
4) Adjust as needed as new SharePoint technologies and aspects are available
The following are good SharePoint related introduction sites for reference:
Introduction to SharePoint and OneDrive in Microsoft 365 for Administrators:
https://learn.microsoft.com/en-us/sharepoint/introduction
About the SharePoint Administrator Role in Microsoft 365:
https://learn.microsoft.com/en-us/sharepoint/sharepoint-admin-role
Get Started With SharePoint:
Introduction to SharePoint Information Architecture:
https://learn.microsoft.com/en-us/sharepoint/information-architecture-modern-experience
Introduction to the SharePoint Success Site:
