Skip to content
April 13, 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 Action Reference
    • Power Automate Function Reference
    • OData Reference
    • SharePoint List Function Reference
    • Power Apps Function Reference
    • PowerApps: Delegable Functions Reference
  • Cookbook
    • Power Automate
    • Expressions
  • 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 Action Reference
    • Power Automate Function Reference
    • OData Reference
    • SharePoint List Function Reference
    • Power Apps Function Reference
    • PowerApps: Delegable Functions Reference
  • Cookbook
    • Power Automate
    • Expressions
  • Recommendations
    • Books
    • Podcasts
    • Tools
  • Bargain bin
  • Speaking
  • Blog
  • About

Category: Power Apps Function Reference

This Power Apps function reference has two main objectives. First, to explore the fundamental concepts and understand them better. The second is to provide some feedback on how to use them efficiently.
I don’t want this Power Apps function reference to replace the excellent Microsoft reference, but I want to augment it with some information that you only find once you use the tools.
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 App: Len Function
Microsoft / Power Apps / Power Apps Function Reference / Recommendations

Power App: Len Function

Manuel Gomesby Manuel GomesApril 8, 2021February 27, 20210

The Len function is highly versatile and super useful. It is also a function used in all programming languages that I know since it serves …

Power App: Table Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power App: Table Function

Manuel Gomesby Manuel GomesMarch 18, 2021February 27, 20210

Not all data lives in data sources and, once in a while; it’s useful to generate a table of objects that lives in your App. …

Power App: Count Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power App: Count Function

Manuel Gomesby Manuel GomesFebruary 25, 2021February 24, 20210

There are several count functions in Power Apps, and all of them draw inspiration from Excel. I will detail them all in this reference but, if …

Power App: SortByColumns Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power App: SortByColumns Function

Manuel Gomesby Manuel GomesFebruary 4, 2021February 3, 20210

Sorting is essential for any app’s good navigation, but most of the time, we want to define a column to be the “default” sorting column. …

Power Apps: Concat Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: Concat Function

Manuel Gomesby Manuel GomesJanuary 14, 2021January 15, 20210

It’s funny that there are two functions to perform concatenation of “stuff.” Some people get confused when thinking about using one or the other, but …

Power Apps: Concatenate Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: Concatenate Function

Manuel Gomesby Manuel GomesSeptember 17, 2020September 13, 20200

Every programming language has a variation of the “concatenate function,” but I like a lot the Power App’s implementation of it. Concatenation means creating a …

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 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 …

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 …

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 …

Posts navigation

1 2 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: replace Function

September 24, 2020September 23, 2020

Microsoft Teams: How to be a presentation master?

April 12, 2021April 12, 2021

OData: And Operator

April 9, 2021April 9, 2021

Power App: Len Function

April 8, 2021February 27, 2021

Power Automate: Run Child Flow Action

April 7, 2021April 6, 2021

Power Apps: Provide more information with color

April 6, 2021April 6, 2021
Manuel Gomes - Power Automate: Convert Excel Number to Date

Hi Howard, The number 443852 looks like something that Excel would return. You're trying to use that number to convert…

Manuel Gomes - Power Automate: Add attachment to e-mail dynamically

Hi John, Yes, you can. You can even do it automatically. You can use the "When a file is created"…

Howard - Power Automate: Convert Excel Number to Date

G'day Manuel Can you help with this error whereby the date does not seem to be recognised as a “‘String/date'”?…

John DeBias - Power Automate: Add attachment to e-mail dynamically

well, short and simple question here. Can I drop a file in my one drive, at any time and have…

Manuel Gomes - Ulysses: How to fix the WordPress login error

Hi Sam, That's awesome. I'll give it a shot and publish the findings here. Thanks a lot Manuel

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

Recent

Microsoft Teams: How to be a presentation master?

April 12, 2021April 12, 2021

OData: And Operator

April 9, 2021April 9, 2021

Power App: Len Function

April 8, 2021February 27, 2021

Power Automate: Run Child Flow Action

April 7, 2021April 6, 2021

Power Apps: Provide more information with color

April 6, 2021April 6, 2021

Video of the Day

Tags

Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Ignite Into The Weeds Investigative journalism Music New Feature 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