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 import
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 made
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 all
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 stores
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 E5
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.
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 create
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 the