• March 7, 2022

MS Teams – Clear Cache

Wanted to share automation to clear the Microsoft Teams desktop client folder and restart application. Might help when troubleshooting dropped calls, slow client, and performance issues. Cheers

Source Code

• https://github.com/spjeff/spadmin/blob/master/MS-Teams-Clear-Cache.ps1

Screenshots

References

• https://stackoverflow.com/questions/9725521/how-to-get-the-parents-parent-directory-in-powershell
• https://techibee.com/active-directory/powershell-search-for-a-user-without-using-ad-module/2872
• https://social.technet.microsoft.com/Forums/windows/en-US/5388624d-73d1-46d5-9944-d9143af50ca2/unable-to-find-type-systemwindowsmessagebox-runs-in-ise-but-not-from-powershell?forum=winserverpowershell
• https://www.itnator.net/clear-empty-microsoft-team-cache/?lang=en

• March 7, 2022
• No Comments
• Uncategorized

• February 15, 2022

VIDEO – Query Dataverse Tables With HTTP POST

Step-by-step live demo of how to create Azure App Registration and query Microsoft Dataverse tables over HTTP POST to the CRM Dynamics 365 endpoints. Key steps include:

1. Create Azure App Registration with Client Secret
2. Grant delegated Azure App API permission “Access Common Data Service as organization users”
3. Grant same Azure App GUID permission in PowerApps Admin Center
4. Grant “Service Reader” for target PowerApps Environment
5. Execute login HTTP POST to gain “access_token”
6. Execute query HTTP POST to gain JSON Dataverse table rows

Cheers

VIDEO

CODE

• https://github.com/spjeff/Query-Dataverse-Tables-With-HTTP-POST

SCREENSHOTS

REFERENCES

• https://giangpham.io/blog/acquiring-an-oauth-access-token-from-dynamics-365-crm-online/
• https://community.dynamics.com/365/f/dynamics-365-general-forum/317299/dynamics-365-oauth-for-webapi

• February 15, 2022
• No Comments
• Uncategorized

• February 13, 2022

VIDEO – Fully Automatic Page Translation with SPO, Azure Fn, PNP, and Cognitive Services

Wanted to share video demo of the configuration, testing, and debug for ASPX Page Translation of “flat” text modern content leveraging SharePoint Online (SPO), Azure Functions (Fn), PowerShell PNP, and Azure Cognitive Services.

Now users create Modern SPO pages with embedded text and simply click Microsoft “convert” to languages button. Background job handles Translation API for text updates.

Key technical design components are:

1. SPO Modern page source text
2. SPO site settings > Enable multi-language
3. Azure Translation API
4. Azure Function PowerShell
5. MS Flow to automatically execute Azure Function

Comments and suggestions always welcome. Cheers.

VIDEO

SCREENSHOT

CODE

• https://github.com/spjeff/spo-page-translation

AZURE FUNCTION KUDU

# This file enables modules to be automatically managed by the Functions service.
# See https://aka.ms/functionsmanageddependency for additional information.
#
@{
    # For latest supported version, go to 'https://www.powershellgallery.com/packages/Az'. 
    # To use the Az module in your function app, please uncomment the line below.
    # 'Az' = '7.*'
    
    'PNP.PowerShell' = '1.*'
}

MS FLOW COMPOSE

replace(replace(triggerBody()?['{Path}'], 'SitePages',''),'/','')

MS FLOW COMPOSE2

{
  "siteURL": "https://spjeff.sharepoint.com/sites/portal",
  "language": "@{outputs('Compose')}",
  "pageTitle": "@{triggerOutputs()?['body/{Name}']}"
}

REFERENCES

• https://tech.nicolonsky.ch/azure-functions-powershell-modules/
• https://michalsacewicz.com/automatically-translate-news-on-multilingual-sharepoint-sites/
• https://support.microsoft.com/en-us/office/create-multilingual-communication-sites-pages-and-news-2bb7d610-5453-41c6-a0e8-6f40b3ed750c
• https://docs.microsoft.com/en-us/azure/cognitive-services/translator/reference/v3-0-reference
• https://stackoverflow.com/questions/61061357/azure-tranlate-api-call-is-returning-and-40100

• February 13, 2022
• No Comments
• Uncategorized

• January 23, 2022

VIDEO – PNP Site Directory JSON expanded with AzureAD site owner

Demo how to create JSON inventory of full tenant SPO site collections. Lookup Site Owner in Azure AD and expand JSON with AD properties such as user, manager, department, and more. Cheers.

CODE

https://github.com/spjeff/office365/blob/master/office365-site-directory/PnP-Site-Directory-JSON.ps1

VIDEO

SCREENSHOTS

REFERENCE

• https://www.spjeff.com/2021/12/24/pnp-connect/
• https://ilovepowershell.com/2019/11/18/ultimate-guide-to-using-powershell-add-member-cmdlet/
• https://docs.microsoft.com/en-us/powershell/module/azuread/get-azureadusermanager?view=azureadps-2.0

• January 23, 2022
• No Comments
• Uncategorized