After receiving many comments from two previous posts based on Vacation Trackers in SharePoint, one such area of interest is around automating the calculation of time off that includes factoring in weekends and holidays. This is
Intro In a previous blog post I created a Vacation tracker in a SharePoint List and in this post, I’ll be adding enhancements to the list. These enhancements are fairly straight forward and will improve the
In the previous post I imported 100,000 rows of data from Excel into a SharePoint List using Power Automate. In this post, I will export a large amount of filtered data out of the same SharePoint
In this blog post, I discuss how to import 100,000 rows and 56 columns (5.6m data points) into a SharePoint List (Microsoft Lists) from a Microsoft Excel csv file using Power Automate. I downloaded a 1.8
Every day, while running the Supply-Chain at Cuisine Solutions for one of our plants, our 3rd party warehouse emailed me a copy of the daily raw material inventory report within an Excel file. I’d manually save
Power Automate can help with moving email attachments from an email account to SharePoint. In Part 1 of this 4 part series, we are going to walk through the steps on how to setup a Microsoft
Moving content from one Excel file to another is a common task that Power Automate can do rather effectively. In Part 2 of this 4-part series, we are going to go through the steps on how
Power BI can connect to many data sources including Excel. In the previous parts of this 4 part series, we setup the automation to populate an Excel master data file in SharePoint. Next part is to
Now that the Excel file is connected to the Power BI Service, it should be automatically be setup to refresh the report data every hour but to confirm or make changes review the steps below: Step
