Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

AxioWorks Newsletter March 2021: Our first!

We have just sent out our first newsletter and, being it our first one, we thought we dedicate a post to it. All future ones will go out just by email so, if you find this one interesting, please do subscribe!!!

First of all, thank you to all of our current subscribers! We hope you will find this content interesting, We are new at this and very excited about it.

Our plan is to make it a monthly issue and include updates about our company and products, interesting and relevant articles, and anything else we think you may find interesting like – in this issue – the winner of the Logitech C930-E Business Webcam prize draw!

So, let’s start. What has AxioWorks been up to?

We have just released a new update for SQList 6 (version 6.2.1.0). It had been a while since we released the last update, it was back in April 2020 and a lot has happened since! This new release includes two very important additions:

  1. we changed the way SQList handles SharePoint Online throttling;
  2. we added a filter to the event log.

Check out our blog article New version of AxioWorks SQList released (6.2.1.0) for all the details. So that you know, we are already working on the next release, it is our intention to release updates more frequently now. There are endless improvements that can be made to SQList 6.

We are also expanding our sale network and looking for sales agents and resellers. If you are interested in adding SQList to your product portfolio or integrate it with your current solution, please check this opportunity’s details here: Grow with Us : An Opportunity to Work with AxioWorks.

We also started this newsletter! So that you know, at the end you will find a couple of feedback links; please use them to let us know what you think about it, we would really appreciate that.

Focus blog entry: Generate Power BI Charts from live MS Lists data

Every month we will nominate the “Focus blog entry”: an article chosen from our blog that we’d like to bring to your attention. This month’s choice is Generate Power BI Charts from live MS Lists data.

Check it out, we use Microsoft Lists to create an issue tracking solution using an out of the box template and SQList to synchronise data from Microsoft Lists into SQL Server tables. Finally, we use Power BI to generate charts on live data from the issue tracking lists connecting the the SQL tables, hence avoiding all the limitations and poor performance that a direct connection to the SharePoint lists would bring.

SQList feature of the month: Export attachments

Did you know that you can use SQList to export attachments from SharePoint lists and libraries? Watch this short video on how to Export SharePoint Attachments to SQL Server; you can export the list of attachments as well as download the actual document and store it as a BLOB in the table.

Featured articles

How to personalize SharePoint for users

Quite a common request among many organizations using SharePoint is the ability to personalize SharePoint for users/employees. In other words – surface up content on a SharePoint Site/Page based on the user logged in. In this article, I would like to explain all the available options available up to date.
Read more…

Home Site vs. SharePoint Start Page vs. Hub Site vs. Root Site

With all the new terminology and new features Microsoft releasing in SharePoint Online, it is quite easy to get lost and confused. Don’t worry, that’s why I am here to help you with your SharePoint journey. Today, I want to explain a difference between a few pieces of terminology that users find most confusing: Home Site, SharePoint Start Page, Hub Site, and the Root Site. They all mean totally different things, so let me break it down for you.
Read more…

How to combine Filtered and Keyword search in a SharePoint Document Library

In case you are using metadata in place of folders in your document library – Mazel Tov! This means you have additional means to sort, group, and filter your documents. But what if you want to filter by metadata while also searching by a keyword? You know, just like on Amazon.com® – you type some keywords into the search box and then filter the results by specific criteria. Today I want to explain how you can combine filtered and keyword search in a SharePoint Document Library.
Read more…

And the winner of the WebCam Prize Draw is?

Congratulations mx*****a@****kr.edu.pl! You are the winner of the fabulous Logitech C930-E Business Webcam!

If that is your email address, email us at info@axioworks.com indicating your full name and address to claim your prize. Important: to claim the prize you must contact us from the same email address entered into the draw, we will not contact you first.

What did you think of our first newsletter?

  • I liked it!
  • It was ok, but you can do better.
  • Sorry, I did not like it.

We are looking forward to hearing from you!

Latest articles

What went down at MS Ignite 2021: Power Automate and Power Virtual Agent Edition

14 Jan 2022

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

What went down in MS Ignite 2021 : Power Apps Edition

30 Dec 2021

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

AxioWorks Newsletter December 2021: How has 2021 been for you?

28 Dec 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

AxioWorks Newsletter November 2021: What has AxioWorks been up to?

03 Dec 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

What went down in MS Ignite 2021 : Power BI Edition

30 Nov 2021

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only we get a view of all their product […]
[read article]

AxioWorks Newsletter October 2021: Focus on customer service and a webinar on its way

01 Nov 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Gain valueable Insights into your PowerApps using Application Insights

25 Oct 2021

Power Platform provides a great way for citizen developers to develop Apps using low-code /no-code tools like PowerApps, PowerAutomate, and PowerBI. […]
[read article]

AxioWorks Newsletter September 2021: Focus on our sales effort

18 Oct 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Why use SQList to generate Power BI reports from SharePoint lists, rather than using the Power BI native connector to SharePoint?

18 Oct 2021

The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it […]
[read article]

SharePoint Online List vs SQL Server as Data Source in Power-BI

15 Sep 2021

Lists are primarily used as a source of data storage in the world of SharePoint and in most scenarios these lists can grow really fast especially if […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*