The purpose of this post is to highlight the table schema that I’ll be using henceforth, in my upcoming posts, targeting Microsoft PowerApps and Microsoft Flow. The table schema design is based on the Product Table from AdventureWorks. Here, I have highlighted all the fields used and their types. Some of the fields are custom so as to suit my case scenario.
Read More »
Just like we have SharePoint Foundation for on-premise, Microsoft issues a free 1 year developer license for SharePoint Online as well. Even better, we get a full SharePoint Online experience here unlike SharePoint Foundation where, a lot of enterprise features were blocked.
In this post, I’ll demonstrate
- how to setup your free 1 year developer account for Office 365 and then,
- how to activate full features of SharePoint Online by assigning the adequate product licenses.
In one of my previous post I had demonstrated how to, Download Large Files from SharePoint Online. While the file download is working perfectly fine, but, I was constantly getting the following error while trying to load/access it’s properties,
Value was either too large or too small for an Int32
In this blog post, I’ll show how to use SharePoint REST API, in a C# console application i.e., .NET server side, to fetch ListItems from a SharePoint Online List.
Read More »
I have this application, in CSOM, which used to get the entire ListItems of a SharePoint List at one go to perform certain operations. All was well and good, until, I exported a brand new SharePoint List from Excel. The List had around 5400 items (>5000). When I tried to fetch all of its items, in the same way, I received the following error:
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator
In the above screenshot, I have applied a GroupBy setting on a SharePoint View. I needed the same exact values in my application through JSOM. However, all of the online examples, that I came across, were of retrieving all the ListItems of a SharePoint List. You can either retrieve all the items at once or in batches, but there seems to be no provision of applying grouping or aggregation on the ListItems through code!
Somehow, I wasn’t convinced of this and was vehemently against this idea of pulling all the data on client-side first, thereafter applying grouping and aggregations.
