Category: Debug

Make a field ReadOnly in SharePoint List

We can make a field readonly or editable in SharePoint using REST API. I usually use it when I want to update a bunch of SharePoint List Items without changing their Modified date and Editor details. Below is an example to make “Editor” readonly again (you’ll first need to get the Digest Token): fetch(`${siteUrl}/_api/web/lists/getByTitle(‘${listName}’)/fields/getbyinternalnameortitle(‘Editor’)`, { […]

Mise à jour d’un serveur Kimsufi (OVH) depuis Debian 11 (Bullseye) vers Debian 12 (Bookworm)

Cette mise à jour est similaire à ce qui a pu être fait précédemment. Je vais essayer d’expliquer brièvement les étapes à suivre. D’abord s’assurer de la version actuelle de Debian avec la commande suivante : lsb_release -a On vérifie les problèmes liés à la mise à jour. Il est recommandé d’utiliser le programme /usr/bin/script […]

AndroidManifest.xml from ADB

It’s possible to find the AndroidManifest.xml file for an app using its APK (e.g. from APKMirror) and then with the help of a tool like jadx, but we can also connect to the Android device using adb connect, and then we use adb shell dumpsys package PACKAGE_NAME (e.g. “com.netflix.ninja” is the package name for Netflix). […]

Power FX: Dynamically access an object property with a variable

I’m kind of new with Power Apps, and it’s been very difficult to find how to access an object property using a variable. In a nutshell, here are to access it: With( { tempData: ParseJSON(JSON(ThisItem, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes)) }, Concat( ForAll( ColumnArray As ColumnName, ColumnName.Value & “=>” & Column( tempData, ColumnName.Value ) & “<br>” ), […]

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 […]

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 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 the […]

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 […]

Deploy a PCF NodeJS app as a scheduled task

I have a NodeJS app that runs as a process and that executes a task every 15 minutes using node-schedule. We first need a manifest.yml file that contains: — applications: – name: APP-NAME buildpack: nodejs_buildpack no-route: true health-check-type: process env: OPTIMIZE_MEMORY: true The no-route parameter is true so that we don’t get a route assigned, […]

Pass an URL parameter to a SharePoint Online form’s field

The only way to pass a URL parameter to a SharePoint Online (modern design) form’s field is to use PowerApps (at least, if you cannot add any JS on your website!). Important warning: when you use PowerApps to manage your form, all edits to the list settings won’t reflect to the PowerApps form. For example, […]