Catégorie : English

How to remove an account / leave an organization in MS Teams?

If in the top right corner of MS Teams, when you click on your profile picture, you see other organizations/accounts and you want to delete them: Go to the MS Teams Settings by clicking on the three dots next to your profile picture Go to Accounts and orgs Turn off or leave the org/account that […]

How to run Android TV 9 on Windows

I used to use Android Studio with the various emulators to test my Android apps, however for Android TV 9 it doesn’t work properly because it doesn’t have Google Play Store on it. To have a good version of Android TV 9: Downlad a VirtualBox image of it – I used the one shared in […]

Connect to SharePoint Online from NodeJS using an impersonate (application) Bearer Token

(duplicate of this StackOverflow answer) Start a new project In a new folder, type npm init to start a new project. Make sure to use a Node >= v14 (I use Node v18 – and Volta can be useful to manage several versions of Node for Windows) Install some dependencies: npm install axios @azure/msal-node uuid […]

Manual Installation of ExplorerPatcher

ExplorerPatcher permits to change the behavior of the Windows taskbar. If for some reasons the automatic install doesn’t work, you can proceed manually: Install it on a computer where the automatic install works On the target computer, download ep_setup.exe from the official website Open a Terminal and extract the files from the setup using the […]

Power Automate: how to verify if a property belongs to an object (apply to SharePoint Date too)

We can use this kind of formula (notice the questionmark): if(empty(variables(‘params’)?[variables(‘fieldName’)]), ‘fieldName is not part of the object params’, variables(‘params’)?[variables(‘fieldName’)]) Then if it either returns « fieldName is not part of the object params » or the value. We can use it to check if a date field is empty in a SharePoint List, because when getting […]

Power Automate returns an error about « InvokerConnectionOverrideFailed » and « header.X-MS-APIM-Tokens »

While calling a « Run a Child Flow » from a Power Automate Flow, you could get an error about « InvokerConnectionOverrideFailed » and « header.X-MS-APIM-Tokens ». After investigating, to resolve this issue you need to open the « details » view of your child flow, and click on the « Edit » button from the « Run only users » card: Then in the Connections Used […]

Search and restore an item from a SharePoint Online Recycle Bin

It might be difficult to search for an item in a SharePoint recycle bin. I was using the end point _api/site/RecycleBin as a Site Collection Administrator, but in some cases it returns an error « The attempted operation is prohibited because it exceeds the list view threshold. ». The solution is to use another end point _api/site/getrecyclebinitems […]

Calculating HMAC SHA-1 in the Browser

If you’re looking for the equivalent of hash_hmac(‘sha1’, ‘string’, ‘secret’); in JavaScript, then here you go: async function hmac_sha1 (str, secret) { // see https://stackoverflow.com/a/47332317/1134119 let enc = new TextEncoder(« utf-8 »); let key = await window.crypto.subtle.importKey( « raw », // raw format of the key – should be Uint8Array enc.encode(secret), { // algorithm details name: « HMAC », hash: {name: […]

Connect to SharePoint Online using an app clientId and clientSecret

Get `clientId` and `clientSecret` (source) You’ll need credentials: `clientId` – required string, client id obtained when registering the addin `clientSecret` – required string, client secret obtained when registering the addin `realm` – your SharePoint Online tenant id. The easiest way to find tenant is to open SharePoint Online site collection, click Site Settings → Site […]

spfx error: No development certificate found. Generate a new certificate manually, or set the `canGenerateNewCertificate` parameter to `true` when calling `ensureCertificateAsync`

When using the command gulp serve, you could receive the below error: No development certificate found. Generate a new certificate manually, or set the `canGenerateNewCertificate` parameter to `true` when calling `ensureCertificateAsync` To resolve, you can type gulp trust-dev-cert.