Category Archives: Uncategorized

Azure App Reg > Replace retired SPO ACS Client ID Secret

Step by step demo how to create Azure Application Registration as new method to replace the retired SPO ACS Client ID Secret method. How to register with PowerShell PNP, create Client ID (App ID), upload certificate PFX, and finally connect with PNP module Connect-PNPOnline. Cheers.

VIDEO

GITHUB

https://github.com/spjeff/office365/tree/master/SPO-AZ-AppReg

SCREENSHOTS

REFERENCES

FULL Screen Mode for SPList Canvas App with DEEP Link URL

How to display FULL screen with SPList Canvas App and then DEEP link URL to directly Edit current rows in the SPList.

Powerful alternative to making Canvas App from scratch with large complex Patch() function to handle INSERT and UPDATE row in SPList storage. Here we rely open “SubmitForm(SharePointForm1)” function to avoid any Patch() function enumerate all fields one by one. Method which is both tedious and error prone. Smart to leverage DataCard with existing known field wizard in the Canvas App studio to design display. Finally we can provide INSERT and UPDATE all at once with short simple save function “SubmitForm(SharePointForm1)

Cheers

VIDEO

POWERAPPS FUNCTION CODE

ONSTART()ITEM()
Set(FormID, Param(“FormID”));
If(IsBlank(FormID), Set(varFormMode, “New”), Set(varFormMode,”Edit”));
If(IsBlank(FormID),
// Basic SPList user experience
If(IsBlank(SharePointIntegration.Selected),
First([@ExpenseReport]),
SharePointIntegration.Selected),
// Lookup with URL parameter deep link
LookUp(ExpenseReport,ID=Value(FormID))
)

REFERENCES

SCREENSHOTS

XRM Toolbox – Quick Start for M365 Devs (TSQL and FetchXML)

Quick start guide showing step-by-step how to install XRM, configure corporate web HTTP proxy settings, connect to Microsoft 365 Dataverse with Login Control, and run query. Data can be viewed with both SQL 4 CDS and FetchXML tools. NOTE – FetchXML is required by many PowerAutomate (MS Flow) action steps to query MS Dataverse records.

Familiar with TSQL pattern SELECT FROM WHERE? Then SQL 4 CDS will make MS Dataverse table support a breeze. Cheers.

VIDEO

REFERENCES

SCREENSHOTS

WHAT IS FetchXML?

Use a Dataverse-style FetchXML query, which allows more flexibility in building custom queries. These queries can be useful when you work with a table that has multiple related tables, or handling pagination. The following screenshot shows how to use FetchXML.

Type the following in the Fetch Xml Query field.

Report SPPKG usage CSV all site collections and tenant wide

Demo how to report on SPPKG usage to CSV with both (1) tenant app catalog and (2) every site collection app catalog. For example, tenant app catalog may show only 6 SPPKG in SharePoint Admin Center but we really have 15 site collection catalogs with 45 total SPPKG. PowerShell PNP script here gives granular report with full SPPKG app detail. Cheers.

VIDEO

CODE

https://github.com/spjeff/office365/blob/master/SPJeff-Inventory-SPKG-Available.ps1

REFERENCES

Ultra wide Modern SharePoint homepage with CEWP+CSS

Microsoft offers “Full Width Section” with only 3 web parts.

Want to add more? Any web part? To Full Width Section then watch here step by step.

1) PNP add site App Catalog
2) Upload Modern CEWP
3) Apply HTML with CSS selector to reduce left and right blank space

Cheers

Source code at GitHub repo https://github.com/spjeff/office365/tree/master/spo-modern-CEWP-wide-CSS

VIDEO

REFERENCES

Centro 365 Must Have Chrome Extension for M365 Admins

Live demo for “Centro 365” Chrome Extension which gives fast bookmark access to all essential Microsoft 365 cloud endpoint URLs. SharePoint, PowerPlatform, Azure, Entra, Intune, PowerBI, Stream, and more. With so many M365 cloud services memorizing URLs has become challenging and Centro 365 delivers with fast way to jump to favorite administration screens. Cheers.

VIDEO

DOWNLOAD FOR CHROME

https://chrome.google.com/webstore/detail/centro-365/caajbiigelogfdelpmeldfjmanjjafac?hl=en-GB

DOWNLOAD FOR EDGE

https://microsoftedge.microsoft.com/addons/detail/centro-365/ampgmpmlobbbhjoplcbdfcgplbkbmked

DEVELOPER PROJECT

https://seanosullivan.co.uk/projects/centro365/

End User PowerShell – Create SharePoint fields from CSV. Provision schema demo.

Live coding demo for to Create SharePoint fields from CSV. Available to any end user and does not require SharePoint tenant admin, site collection admin, or high level access.

Provision list schema and create fields with DisplayName, InternalName, and Data Type from CSV input.

Cheers.

VIDEO

SOURCE CODE

Return to Top ▲Return to Top ▲