Skip to content
February 25, 2021

Manuel T. Gomes

Welcome to my website, where I go deep into Microsoft’s technology and show you what I’ve learned over time.

  • Home
  • Microsoft
    • Power Automate
    • SharePoint
    • Power Apps
    • Microsoft Forms
    • Microsoft Teams
    • Microsoft Planner
  • Reference
    • Power Automate Function Reference
    • SharePoint List Function Reference
    • Power Apps Function Reference
    • PowerApps: Delegable Functions Reference
  • Template Archive
    • Power Automate
  • Recommendations
    • Books
    • Podcasts
    • Tools
  • Bargain bin
  • Speaking
  • Blog
  • About
  • Home
  • Microsoft
    • Power Automate
    • SharePoint
    • Power Apps
    • Microsoft Forms
    • Microsoft Teams
    • Microsoft Planner
  • Reference
    • Power Automate Function Reference
    • SharePoint List Function Reference
    • Power Apps Function Reference
    • PowerApps: Delegable Functions Reference
  • Template Archive
    • Power Automate
  • Recommendations
    • Books
    • Podcasts
    • Tools
  • Bargain bin
  • Speaking
  • Blog
  • About

Tag: Function Day

Function Day is where I’ll explore the basics of some functions and provide some recommendations on how to use them. I’ll focus on Microsoft Flow, SharePoint, and PowerApps since there’s a lot to explore there, but there may be other references showing up in the future.
Please don’t expect an exhaustive list of all functions. You can find that on Microsoft’s excellent reference. I’ll focus on the most common ones and build from there, but I want to make Function Day a thing on this site.
Articles will come out every Thursday, always 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate, SharePoint, and Power Apps articles, every three weeks. Time permitting I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.

Power Automate: replace Function
Microsoft / Power Automate / Power Automate Function Reference / Reference

Power Automate: replace Function

Manuel Gomesby Manuel GomesSeptember 24, 2020September 23, 20200

The “replace” function is one that shows up frequently in every programming language. The usage is simple but extremely powerful. Usage It follows a simple …

Power Apps: StartsWith Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: StartsWith Function

Manuel Gomesby Manuel GomesAugust 28, 2020June 19, 20200

The StartsWith is a handy function that allows you to check if a text string starts with another. Usage It follows a simple pattern. Text …

Power Automate: join Function
Microsoft / Power Automate / Power Automate Function Reference / Reference

Power Automate: join Function

Manuel Gomesby Manuel GomesAugust 21, 2020August 21, 20202

The join function is handy although I, don’t see many people using it. It converts an array in a string with a delimiter. At first, …

Power Automate: int Function
Microsoft / Power Automate / Power Automate Function Reference / Reference

Power Automate: int Function

Manuel Gomesby Manuel GomesJuly 31, 2020July 29, 20200

The int Function does something super simple. Convert a string into an integer value. That’s it. But, as always, we need to be careful while …

Power Apps: Trim Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: Trim Function

Manuel Gomesby Manuel GomesJuly 24, 2020June 19, 20200

The Trim function is one handy function that most don’t understand the proper usage since it only serves one purpose. It is removing spaces. It …

SharePoint: Choose Function
Microsoft / SharePoint / SharePoint List Function Reference

SharePoint: Choose Function

Manuel Gomesby Manuel GomesJune 26, 2020July 10, 20200

“Choose function” will return the value for a specific index. For example, if you have a set of values like “banana,” “orange,” and “apple,” the …

Power Apps: TrimEnds Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: TrimEnds Function

Manuel Gomesby Manuel GomesJune 19, 2020June 19, 20200

The TrimEnds function is one handy function that is often confused by the Trim function since it works closer to the way developers are used …

SharePoint: IF Function
Microsoft / SharePoint / SharePoint List Function Reference

SharePoint: IF Function

Manuel Gomesby Manuel GomesMay 22, 2020March 27, 20200

“IF function” will return something if the first value is “true” and something else if the second is false. The “If function” is the most …

Power Apps: Filter Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: Filter Function

Manuel Gomesby Manuel GomesMay 15, 2020May 15, 20200

The filter function searches in a collection for one or more conditions and removes all items that don’t fit that condition. Usage It follows a …

Power Automate: split Function
Microsoft / Power Automate / Power Automate Function Reference / Reference

Power Automate: split Function

Manuel Gomesby Manuel GomesMay 8, 2020May 5, 20200

The split Function breaks down your string into an array of strings using the delimiter that you defined. Think of the delimiter as a border. …

Posts navigation

Previous 1 2 3 … 6 Next

Power Automate: How to parse a CSV file

August 3, 2020January 13, 2021
Power Automate: How to access Excel with a dynamic path

Power Automate: Access an Excel with a dynamic path

January 21, 2020September 8, 2020

Power Automate: Save multi-choice Microsoft Forms

February 11, 2020February 11, 2020

Power Automate: How to create an ics calendar event

August 18, 2020August 24, 2020

Power Automate: Convert Excel Number to Date

July 28, 2020July 29, 2020

Power App: Count Function

February 25, 2021February 24, 2021

Tools: Grammarly

February 24, 2021February 24, 2021

Power App: Don’t need controls? Hide them!

February 23, 2021February 23, 2021

Microsoft Planner: Filtering for Optimal Performance

February 22, 2021January 30, 2021

Podcast: The Chronicles of Now

February 22, 2021
Manuel Gomes - Power Automate: How to parse a CSV file

Hi Laura, Well done!!!! Almost there!! 😀 The \r is a strange one. Can I ask you to send me…

Manuel Gomes - Power Automate: How to create an ics calendar event

Awesome!!! Nice, it all worked. You're welcome. Always happy to help 😀 Manuel

Jay Lindell - Power Automate: How to create an ics calendar event

Your approach got me thinking and I figured it out 😊. I also dissected the Outlook-created ICS file and was…

Laura - Power Automate: How to parse a CSV file

Thank you! I was actually (finally) able to grab the file from OneDrive, pull it through this process and populate…

Jay Lindell - Power Automate: How to create an ics calendar event

Hi, Manuel, Thanks. Is this what you mean? (see http://jaylindell.com/ICS/ScreenShot_3.png and http://jaylindell.com/ICS/ScreenShot_3a.png). As you can see, it still doesn't work…

Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Investigative journalism Music New Habit News Overview Personal Development Privacy Problem Solved Productivity Security Technology Templates Tutorial Writing

Recent

Power App: Count Function

February 25, 2021February 24, 2021

Tools: Grammarly

February 24, 2021February 24, 2021

Power App: Don’t need controls? Hide them!

February 23, 2021February 23, 2021

Microsoft Planner: Filtering for Optimal Performance

February 22, 2021January 30, 2021

Podcast: The Chronicles of Now

February 22, 2021

Video of the Day

Tags

Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Investigative journalism Music New Habit News Overview Personal Development Privacy Problem Solved Productivity Security Technology Templates Tutorial Writing
Copyright © 2019 Manuel T. Gomes
  • Privacy Policy

Add Manuel T. Gomes to your Homescreen!

Add