SharePoint List Vacation Time Off Tracker that Removes Weekends and Holidays
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 what we are going to tackle in this post. The two previous vacation tracker posts are below:SharePoint Team Vacation […]
Populate a SharePoint Document Library’s Metadata Using JSON and Power Automate
Intro In this blog post, I discuss how to save a PDF document to a SharePoint Document Library, with some of its content previously extracted via AI, and saved in a JSON file, that will populate multiple Document Library columns using Power Automate. Imagine we receive these documents and possibly other files via email from […]
5 Big Enhancements to a SharePoint Vacation Tracker in Microsoft Lists
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 vacation tracker’s functionality. I’ve received several comments on my Vacation Tracker YouTube video with viewers asking for additional features […]
Directly Query a Power BI Dataset Using Power Automate and Save it to Excel in SharePoint
Intro: I received a request from one of my viewers for help in developing a Power Automate flow and after completing the flow decided to do a blog post and YouTube video on it. The Request: I decided to take it one step further by removing the need for the Power BI Export button and […]
How to Export a Large Filtered SharePoint List into a CSV File Using Power Automate
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 List and into a CSV file using Power Automate. Within Power Automate, I’m just using a manual trigger and […]
How to Import a Large Excel Dataset into SharePoint Using Power Automate
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 GB csv dataset from Kaggle with 495,000 rows and 89 columns and transformed the data into two 50 MB […]
How to Set Up a Data Gateway in Power Automate
In this blog post, you’ll learn how to setup a data gateway in Power Automate using a premium power automate subscription. Setting up a Data Gateway in Power Automate is fairly straight forward. Start by going to Data and then Gateways from the main page in Power Automate. You can also see the step-by-step instructions […]
Cloud Data Pull Using JSON HTTP Request in Power Automate
This post reviews the process of setting up a Scheduled Cloud Flow to pull data from the cloud to a local SQL Server using an HTTP request. The pulled data comes in the form of a JSON file and will need to be parsed in order to be received by SQL Server. You will also […]
Using Power Automate to Move and Rename Excel Files and Copy its Content to Another Excel File-Series Summary
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 the file to a SharePoint document library, rename it, copy its contents, and append the data to a master […]
Copy Email Attachment Excel Content to SharePoint and Rename Using Power Automate-Series 1 of 4
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 Outlook rule to move an email with an attachment to a specific folder in Outlook, copy its contents to […]