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
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
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
Fausto Capellan, Jr 