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
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 that don’t… Read More How-To #4: Delete Empty Folders in SharePoint Document Libraries Using Power Automate
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
In this post, I will discuss all the Logical functions that can be used in Microsoft Flow. Function Description if This function returns a specified value based on whether the expression resulted in true or false. This function requires three parameters: the expression to check; the value to return if the expression is true; and… Read More Express Yourself: Logical Functions in Microsoft Flow
In this post, I will discuss all the Collection functions that can be used in Microsoft Flow. These functions generally work with Arrays, Strings, and Dictionaries. Function Description contains This function checks if a collection has a specified item. This function requires two parameters: the collection to check and the value of the item to… Read More Express Yourself: Collection Functions in Microsoft Flow
This page contains additional examples of all the Collection functions available in Microsoft Flow. This page will be updated periodically to include more examples created by the community. contains length empty intersection union first last take skip join
In this post, I will discuss all the String functions that can be used in Microsoft Flow. As the name implies, the functions covered in this post only apply to String data type. Function Description concat This function combines any number of strings together. It requires 2 or more parameters in the form of strings… Read More Express Yourself: String Functions in Microsoft Flow
This page contains additional examples of all the String functions available in Microsoft Flow. This page will be updated periodically to include more examples created by the community. concat Example 1 This example concatenates the value from 2 columns located in different SharePoint lists: concat(triggerBody()?[‘Address_x0020_email’],triggerBody()?[‘Email_x0020_main_x0020_by’]?[‘Value’]) Source: Example 1 Example 2 This example concatenates the string… Read More Express Yourself: String Functions Examples
