How-To #4: Delete Empty Folders in SharePoint Document Libraries Using 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

November 30, 2020 Fausto Capellan Jr2 Comments

How-To #3: Get First Day of the Week 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

June 16, 2020June 16, 2020 Fausto Capellan JrLeave a comment

How-To #2: Add Transparency to Hex Colors in Power Apps

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

June 1, 2020 Fausto Capellan JrLeave a comment

How-To #1: Rename Email Attachments using Microsoft Flow

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

July 15, 2019 Fausto Capellan Jr32 Comments

Express Yourself: Logical Functions in 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

June 14, 2018June 14, 2018 Fausto Capellan Jr1 Comment

Express Yourself: Collection 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

May 1, 2018 Fausto Capellan JrLeave a comment

Express Yourself: Collection Functions Examples

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

May 1, 2018 Fausto Capellan JrLeave a comment

Express Yourself: String Functions in Microsoft Flow

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

May 1, 2018May 1, 2018 Fausto Capellan Jr18 Comments

Express Yourself: String Functions Examples

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

May 1, 2018May 22, 2018 Fausto Capellan JrLeave a comment

Express Yourself: Data Types References

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

March 5, 2018March 6, 2018 Fausto Capellan JrLeave a comment

Fausto Capellan, Jr

Power Automate, Power Apps, Office 365, SharePoint, Azure and other things

Category: Office 365