Category: Niveau intermédiaire

Power Automate Flow: force a file deletion and force a file replacement

To force a file to be deleted in a SharePoint Document Library, using a Power Automate Flow, we can call the action “Send an HTTP Request to SharePoint“, with the below: Method: POST Uri: _api/web/Lists/GetByTitle(‘Document Library Name’)/GetItemById(@{variables(‘ItemID’)})/recycle Headers: Prefer: bypass-shared-lock To force a file to be replaced with new content in a SharePoint Document Library, […]

Set People Picker field in a SharePoint List Item using Microsoft Graph

When we want to use MS Graph to add an item into a SharePoint List that contains a People Picker, then here what needs to be done: Retrieve the Site ID for the root site collection, using https://graph.microsoft.com/v1.0/sites/[CORP].sharepoint.com:/sites/MySiteCollection Retrieve the Site ID for the target end website, using https://graph.microsoft.com/v1.0/sites/[CORP].sharepoint.com:/sites/MySiteCollection/MyParentSiteWeb/MyTargetWebsite/ Use the user’s email address to […]

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>” ), […]

Remove lazy loading for a custom SPFx webpart

SharePoint Online is doing lazy loading when we hit a page with webparts. If you created a SPFx webpart, and if it’s not visible right after the page load, then it will only be loaded once the user scrolls to it… To remove this behavior, and load the webpart as soon as possible, you must […]

Determine an element `height` and `width` in CSS only and reuse it within another CSS rule

I found this technic on https://frontendmasters.com/blog/how-to-get-the-width-height-of-any-element-in-only-css/ – it only works on modern browsers (mainly Chrome and Edge) Let’s define the properties: @property –_x { syntax: “<number>”; inherits: true; initial-value: 0; } @property –_y { syntax: “<number>”; inherits: true; initial-value: 0; } @property –w { syntax: “<integer>”; inherits: true; initial-value: 0; } @property –h { syntax: […]

Envoie d’email et spam (via OVH)

Si on envoie des emails depuis notre propre serveur, avec notre propre domaine, certaines mailbox (comme Gmail) pourraient vous détecter comme du spam ! Pour éviter cela, il faut prendre quelques précautions. Type “SPF” Tout d’abord, il faut ajouter une entrée SPF via le gestionnaire de domaine d’OVH. Le wizard va aider à composer la […]

Émuler Raspberry Pi sous Windows

Depuis que j’ai fait assistant-plugins, j’ai plusieurs utilisateurs qui m’ont demandé comment l’installer sur leur Raspberry. Ce système est censé être similaire à une Debian, cependant ils semblent y avoir des différences… J’ai donc cherché à émuler cet OS sous mon Windows 10. Sources : https://blogs.msdn.microsoft.com/iliast/2016/11/10/how-to-emulate-raspberry-pi/ https://enavarro.me/emuler-un-raspberry-pi-avec-qemu.html Voici les étapes : Télécharger la dernière version […]

Overwrite the Created field for a Sharepoint list item

Sharepoint provides automatic fields, like “Created” that contains the creation date of a list item. It’s a readonly field. You could use a webservice to change the ReadOnly property in order to overwrite its value. Using SharepointPlus the code is: // don’t change the below information // the details about this field are found using […]

Classic ASP to get a remote page with NTLM authenticate

It’s very frustrating to have to work with ASP again, after so many years… I wanted to use an ASP page to get a remote page. However I needed to pass some NTLM authenticate to it. After a few searches I found this solution: <% ‘ I want this page to be accessible for Cross […]