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
Microsoft Flow works with several different data types, and for you to have a better understanding of what they are, I have compiled this post with all the data types, along with their definition and examples. Please enjoy! Data Types A data type determines what type of value an object can have and what operations… Read More Express Yourself: Data Types References
I’m happy to announce I will be working on a Microsoft Flow series titled Express Yourself: Building Expressions with Microsoft Flow. The first part of the series, which is this post, is dedicated to introduce the audience to Expressions in Microsoft Flow. Without further ado, here is the first post of the series. Enjoy! Introduction… Read More Express Yourself: Building Expressions with Microsoft Flow
