Our blog

In our previous article on MS Lists, we did a detailed introduction including some of the great features which can help any business in implementing use cases like issue tracking and inventory management. In this blog, we will use MS Lists to create an issue tracking solution using an out of the box template and then we will use SQList to synchronize data between MS Lists and SQL Server database. Finally, we will use Power BI to generate charts. AxioWorks SQList continuously export SharePoint […]
[read article]

08 Nov 2020 | Share:

by Danish Ali Detho | O365 & Power Platform Solution Architect

Introduction Organizations all over the world are trying to find new ways of automating their business processes in order to reduce redundancies, minimize manual data entry and human error. Artificial intelligence plays a significant role when it comes to improving the business process by taking automation to the next level where the process is not only automated but smart and self-sufficient as well. Microsoft Power Automate provides businesses the capability to automate their business […]
[read article]

29 Sep 2020 | Share:

by Danish Ali Detho | O365 & Power Platform Solution Architect

Introduction Virtual agents and bots have become an essential part of customer support in every business. It provides the fastest way to provide the information a customer is looking for without waiting for a customer support agent or searching through a website. They can cover large no of use-case scenarios including providing product information, helping with flight/hotel bookings, or tracking orders. Today we will take a look at how easy it is to create a Power Virtual Agent and integrate […]
[read article]

30 Aug 2020 | Share:

SharePoint Lists has played a pivotal role in building customised solutions on top of SharePoint making SharePoint not just a CRM or DMs but a development platform for developing solutions delivering a wide range of business scenarios. Every SharePoint developer/end-user have used lists in one way or another whether it’s just for creating announcements/tasks or storing complex relational data for an application. But when it comes to list-based scenarios that include share, track and view […]
[read article]

28 Jun 2020 | Share:

In the real-world, reporting often includes master/detail scenario in which a master list item is selected in order to get more details about the entity. In SharePoint, master data will be stored in a list that contains a lookup column of detail list/s, and getting data from multiple lists would require multiple data sources and then modelling their relationships in Power BI. In this blog, I will show you how easy it is to achieve a master-detail scenario on live data coming from SharePoint […]
[read article]

25 May 2020 | Share:

A new version of SQList: version 6.2.0.0 is out today! We haven’t blogged about new releases for years, why we don’t know. We’ve been notifying all our users of SQList, been publishing support articles, but not a mention on our website. Silly strategy you may think…and so do we! But it has not been a strategy as much as a negligence on our part, and today we’re putting an end to it! AxioWorks SQList continuously export SharePoint lists and libraries as normalised […]
[read article]

30 Apr 2020 | Share:

In this blog, we will go through essential steps on how to generate a report and chart in Google Data Studio using data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to replicate data from SharePoint Lists to SQL Server database which will later be used in Google Data Studio to generate a chart and to finish things off, we will look at how to display the report in SharePoint. Scenario Create […]
[read article]

22 Mar 2020 | Share:

In this blog, We will take an in-depth look into how SQList transforms SharePoint lists into SQL tables and how it stores data into each column. We will also look at how all changes made in SharePoint are continuously synchronized into their corresponding SQL Server tables. Scenario Replication of SharePoint lists data into SQL Server database and analysis of the columns created in SQL table for the respective SharePoint list columns of various types, including choice, currency, single-lookup, […]
[read article]

29 Feb 2020 | Share: