When I work on projects and I need to play around with existing data, I always like to create a temporary table with the same structure as the existing table in question. This helps me prevent any issues or discrepancies or any data loss. If you are familiar with Microsoft SQL, you may be wondering… Read More Power Platform + MS SQL: How to Create SQL Table from Existing Table and Import Its Data
In this post, I will show you how to format an Excel date column from integer to date using Power Automate. For this example, the flow is manually triggered, but it can be created using any other trigger, such as a schedule or an automated trigger from any connector. Scenario:When entering data in a Microsoft… Read More How-To #9: Convert Excel Date from Integer to Actual Date Using Power Automate
Have you ever wondered have to add new values to a SharePoint Choice column without having to go into the settings of the respective list? Have you thought about letting users take care of this, but you are not keen about them messing around in the list settings? Well, I present you a way you… Read More How-To #8: Add New Values to SharePoint Choice Column Using Power Automate
One question that has come up too many times is how do you create a SharePoint Document Set using Power Automate. Well, there’s a Basic and an Advanced approach, but in this post I will discuss the Basic approach. Ready? Let’s get started!!! If you don’t have a Document Set content type created, let’s walk… Read More How-To #7: Create SharePoint Document Set Using Power Automate (Basic)
I was recently working on an app to display items from a SharePoint list in a gallery. This list, let’s call it Teachers, has 2 columns: Title and Grade. The Title column is a Single line of text column and the Grade column is a Choice column that allows multiple selections. Displaying the records in… Read More How-To #6: Display Multi-Select Choices in Power Apps Label
In this post, I will show you how to format links in the Create HTML table and Send an email actions in Power Automate. Scenario:When adding an link to one of the columns in the Create HTML table action, the link is expected to only show the respective title of the link with an underline,… Read More How-To #5: Format Links Sent via Email in Power Automate
Updated 11/24/2023 In this post, I will show you how to delete empty folders in SharePoint Document Libraries using Power Automate. This flow is manually triggered, but it can be created using any other trigger, such as a schedule or an automated trigger from any connector. Scenario:Scan a SharePoint Document Library and delete all folders… Read More How-To #4: Delete Empty Folders in SharePoint Document Libraries Using Power Automate – Updated
I was recently having a conversation with a friend about getting items from a SharePoint list, but these items must be filter based on the first day of the week. I know for some folks, the first day of the week is Sunday and for others is Monday, but for this scenario, the first day… Read More How-To #3: Get First Day of the Week using Power Automate
I was recently working on a Power Apps project and I usually create a screen to store all the styles and configurations, such as colors, font weight and size, among other things. For this project, I decided to store all the colors in a SharePoint list with the following columns: Color Name (This is the… Read More How-To #2: Add Transparency to Hex Colors in Power Apps
Note: all the actions below are used to describe the process in a simple way to facilitate learning. I will have a separate blog post to show an advanced method. Solution:To create the Flow, follow the steps outlined below: Click on New and select Automated — from blank. In the next screen, you can enter… Read More How-To #1: Rename Email Attachments using Microsoft Flow
Fausto Capellan, Jr 
You must be logged in to post a comment.