For this post, we’ll be doing work in power query, combine files from multiple folders in our network, desktop, OneDrive, or SharePoint. In this example, we have three CSV files in a folder and the data looks like this: We will be using power query in Excel, which works exactly the same as power query
Tag: SharePoint folder
A document library is always automatically created whenever we create a site in SharePoint. We can customize a library and control how users can view, manage, and create documents, or even track versions of files. In this tutorial, we’ll talk about how we can configure the SharePoint site library settings. A document library in SharePoint
Document library provides a location on our SharePoint site where we can safely store our files, create, update, and share them with other users within our organization. In this tutorial, we’ll discuss the two ways on how to add a new document library in SharePoint. A SharePoint document library helps us manage our files for
The View Formatting feature in Sharepoint allows users to customize how items in SharePoint lists and libraries are displayed. In this tutorial, we’ll talk about creating our own formatting views rule to improve the display of views in SharePoint. When formatting a view, we can highlight or accent certain rows or columns depending on a
Metadata helps keep document libraries organized. We can add metadata to our files by adding new columns. After adding it to our files, we can utilize them to sort, filter, or group our files. In this blog, we’ll discuss how we can do metadata filtering in our SharePoint files and its advantages. Metadata filtering makes