Gerald Magno
01.
Summary
Developer with more than 10 years of professional experience in Web, Sharepoint and Microsoft 365.
My Digital Contact
Generate a personal QR code (business card) that you can download and share with colleagues. A Sharepoint Framework (SPFX) app that consumes Microsoft Graph API - Users endpoint to get current user's title, mobile number, work address, M365 user profile photo etc.
Power automate step is failing due to delay in reflecting newly created MS Teams
In this power automate flow I am automating the creation and request of MS Teams however when I need to do the step of adding users into the newly created Teams which was successful I am getting a resource not found. In this blog post I have investigated the issue and how I went about it.
SPFX - paging in sharepoint rest calls using $skiptoken
One of the must-have optimizations is the use of paging when fetching data from sharepoint. In this gist I have demonstrated how I normally consume a Sharepoint REST API with SkipToken and other query string for your sharepoint querying needs.
Unified Teleworking - PowerApps
Developed and designed a PowerApps Canvas app for requesting teleworking schedule. Saving data to a Sharepoint list and also uses Power Automate for sending email notification to a set of users on a SP group when a request is approved, rejected, canceled. Power automate flow for pre-filling the last teleworking address for the logged user.
Survey Monkey data transformation
Transforming Survey monkey raw data from wide format to long format using Excel and python.
Development containers in SPFx a life saver
Oh wow this thing is just a life saver especially having experienced the nightmares of maintaining different sharepoint apps that have different node/spfx versions. See the compatibility matrix for reference here.
Definitely saves you ton of hours and grey hair.
PnP Powershell - automate adding a list of users to a Sharepoint group
The script is created to automate the process of adding a list of users from a CSV file to a Sharepoint group and also creates log file for troubleshooting.