Saturday, February 12, 2022

5 Useful Sites for SharePoint Formulas

The following are five useful sites to utilize for SharePoint Formulas:

Introduction to SharePoint Formulas and Functions:

https://support.microsoft.com/en-us/office/introduction-to-sharepoint-formulas-and-functions-94e1b4cc-cd1c-49c2-80ec-90c9b9591f47  

 

Examples of Common Formulas in Lists:

https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

 

Use Column Formatting to Customize SharePoint:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

 

Calculate Data in Lists or Libraries:

https://support.microsoft.com/en-us/office/calculate-data-in-lists-or-libraries-c5261743-667f-4833-bede-e516cef2a0e1


Understand SharePoint Forms Integration:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration 

5 Sites for Power Automate and PowerApp Templates

The following are five great sites to utilize to find and use various Power Automate and PowerApp templates:

Power Automate Templates:

https://powerautomate.microsoft.com/en-us/templates/

 

Templates & Downloads:

https://resources.techcommunity.microsoft.com/templates-downloads/

 

Community App Samples:

https://powerusers.microsoft.com/t5/Community-App-Samples/bd-p/AppFeedbackGallery

 

Use Excel and Word templates:

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/templates-overview

 

Create a cloud flow from a template in Power Automate:

https://docs.microsoft.com/en-us/power-automate/get-started-logic-template

 

Use flows in teams created from templates:

https://docs.microsoft.com/en-us/power-automate/teams/introduction-teams-templates

3 Useful SharePoint Site Templates with Site Scripts Websites

The following are three sites to utilize to understand SharePoint site templates with site scripts.

Such aspects are useful when one wants to create a customized site template in the Microsoft 365 SharePoint Online environment to be available when creating new web sites:

SharePoint site template and site script overview:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-overview

 

Get started creating site templates and site scripts:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/get-started-create-site-design

 

Apply and customize SharePoint site templates:

https://support.microsoft.com/en-us/office/apply-and-customize-sharepoint-site-templates-39382463-0e45-4d1b-be27-0e96aeec8398

Visio Templates for SharePoint and Microsoft 365 Projects

The following are three good sites to use for Visio templates that then can be used to diagram out SharePoint and Microsoft 365 projects:

Use Wireframe Templates to design websites and mobile apps:

https://support.microsoft.com/en-us/office/use-wireframe-templates-to-design-websites-and-mobile-apps-2d54dc55-f5c4-49a2-85da-d649eb7fc281

 

Featured Visio templates and diagrams:

https://support.microsoft.com/en-us/office/featured-visio-templates-and-diagrams-27d4274b-5fc2-4f5c-8190-35ff1db34aa5  

 

Office Visio Stencil:

https://www.microsoft.com/en-US/download/details.aspx?id=35772

Tuesday, February 1, 2022

SharePoint - Pivot

The following are SharePoint Dictionary words of the Day related to Pivot: 

PivotChart filter pane

User interface element which displays a list of active fields in a pivot view and is utilized to apply filters to those fields.

 

PivotChart report

Chart which uses a pivot for the source data and uses filtering and sorting functionality for the report.

 

PivotTable data field

Pivot field which is in the PivotTable area which is where the data values are displayed.

 

PivotTable field list

A user interface element that displays a list of all pivot fields. A pivot field list can be utilized to populate a pivot report.

 

PivotTable filter parameter

Value which a filter on a pivot report is set to, that indicates matching values which are included in the result set.

 

PivotTable item

Single member of a pivot field.

 

PivotTable member

Individual data item within a certain dimension that is displayed in a pivot report. For example, a sales person maybe in the geography dimension from the Northern United States Region.

SharePoint - Permission

The following are SharePoint Dictionary Words of the Day Related to Permission:

Permission

A rule which is associated with an object to regulate who can gain certain access to that said object and what aspects they can perform based on that access.

 

Permission level

Set of permissions which can be granted to certain SharePoint groups on a site, list, folder, item, or document.