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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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, […]
In Power Automate, when you want to connect to a SQL Server and if you have a On-Promise Gateway, then you cannot use the command « Execute a SQL Query » because it will say it’s not currently supported. There is a workaround with « Transform data using Power Query » (ATTENTION: you cannot load it from a flow […]
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, […]
When we follow the guide to build a new smarthome skill, it gives the steps to create a function in the online code editor. But if you prefer to use the ASK CLI, there is some steps to follow… I first create a fake skill with ask new (using the « hello world » and « AWS Lambda » […]