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
- https://pnp.github.io/powershell/articles/connecting.html
- https://pnp.github.io/powershell/articles/authentication.html
- https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/register-pnpazureadapp?view=sharepoint-ps
- https://portal.azure.com/#blade/Microsoft_AAD_IAM/ActiveDirectoryMenuBlade/RegisteredApps
- https://mmsharepoint.wordpress.com/2018/12/19/modern-sharepoint-authentication-in-azure-automation-runbook-with-pnp-powershell/
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
- https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-param
- https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration
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
- https://www.xrmtoolbox.com/documentation/for-users/install-xrmtoolbox
- https://www.xrmtoolbox.com/documentation/for-users/xrmtoolbox-settings
- https://www.xrmtoolbox.com/plugins/MarkMpn.SQL4CDS
- https://www.xrmtoolbox.com/plugins/Cinteros.Xrm.FetchXmlBuilder
- https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows?tabs=classic-designer
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.
M365 login MFA without Phone. Two click Chrome Extension ONLY.
Step by step demo how to enroll Microsoft 365 Multi Factor Authentication (MFA) with Google Chrome web browser extension to (1) scan QR code enroll and (2) generate 6 digit MFA login. Only two clicks. No phone needed. Cheers.
DOWNLOAD MICROSOFT AUTHENTICATION – CHROME EXTENSION TOOLBAR
https://chromewebstore.google.com/detail/authenticator/bhghoamapcdpbohphigoooaddinpkbai
VIDEO
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
- https://spjsblog.com/modern-cewp/
- https://www.c-sharpcorner.com/blogs/how-to-create-a-fullwidth-section-in-a-sharepoint-online-page
- https://techcommunity.microsoft.com/t5/sharepoint/unable-to-create-full-width-section/m-p/3946577
- https://learn.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/basics/use-web-parts-full-width-column
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
End User PowerShell – Create Quick Launch left Navigation with code
Live coding demo for to Create Quick Launch left Navigation. Available to any end user and does not require SharePoint tenant admin, site collection admin, or high level access. Cheers.
VIDEO
REFERENCES
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
ULS Correlation ID self service PowerShell email CSV for SharePoint Server 2013/2016/2019/SE
Live coding demo how to automate Correlation ID lookup and email CSV results with PowerShell automation and SPList request item. Reduce administration effort and provide faster CSV results to customers.
Cheers.
