Python Integration with Multiple Data Sources and Tables (Working with Oracle & SQL Server Database )
Python queries to work with multiple instances of Oracle and SQL Server. In this challenge, I had to query Oracle and SQL Server to merge their tables to generate a new SQL Server table. ##0 Import required Python Modules import os import pandas as pd import pyodbc import cx_Oracle importContinue Reading
HackerRank Kangaroo Challenge with JavaScript using VS Code
I have been taking on the code challenges at HackerRank(www.hackerrank.com). I was intrigued by one named “Kangaroo” . This was an opportunity to polish on my JavaScript coding skills. Now, how do I test a solution within Visual Studio Code (VS Code) before submission to HackerRank. How does JavaScript accessContinue Reading
The rise of the citizen developers – IMHO
I am so intrigued and to a certain extent, obsessed with the terminology “citizen developers”. It is the same feeling that I had when Agile became a cliché and everyone starting to profess and adopt a lean methodology. I reckon it’s not a new concept, many attempts have been madeContinue Reading
PowerApps integrating SharePoint Online with Microsoft Teams
Microsoft plans to replace Skype for Business with Microsoft Teams. Hence, it would be interesting to leverage how we can use PowerApps, SharePoint and Microsoft Teams working together seamlessly. Here I have done a simple video that will give you a step by step guide on how I integrated allContinue Reading
Migrating SharePoint Fruit Stall List Into Common Data Service
Common Data Service as per Microsoft’s definition;Common Data Service lets you securely store and manage data that’s used by business applications. Data within Common Data Service is stored within a set of entities. An entity is a set of records used to store data, similar to how a table storesContinue Reading
Creating a simple workflow for Fruit Stall list
Creating workflow with SharePoint Online is easy. I am going to create a simple workflow that will notify you, each time a new item has been added into the Fruit Stall list. You need access to your Office365 email and should have enable “Flow” as part of your Office365 E5Continue Reading
Creating a simple PowerApps mobile application from a SharePoint list
We will be using the same SharePoint list named Fruit Stall to create a simple PowerApps Mobile Application named Fruit Stall Entry. See how easy you can do this with Power Platform and Common Data Services. You can view the entire steps to create this list from the video below.Continue Reading
Creating a simple list named Fruit Stall
Creating list with SharePoint Online is easy. I am going to create a list named Food Stall with the following fields and type. Column 1 Column 2 Column 3 Column 4 Fruit Colour Quantity Price Single line of text Choice Number Currency You can view the entire steps to createContinue Reading
Welcome to SharePointPower.com
SharePoint legacy has been very much my livelihood and passion the last 12 years. Experiencing many facet of SharePoint roles and evolution that began with SharePoint 2007, working as a developer, administrator and program manager. SharePoint online has become a crossroad of some kind for me, time to embrace theContinue Reading