Skip to content
March 1, 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

Category: Power Apps

Power Apps is a platform that looks complex and difficult to learn, but it’s quite the opposite. It provides a simple and straightforward interface that allows you to do advanced apps quite efficiently. I write these articles with step-by-step tutorials to teach you how to build your apps in Power Apps. Once you understand these concepts, you will be able to, develop, and provide rich apps platforms with not a lot of work. You can even, automatically, offer these for mobile usage, desktop, and even web. If you’re a pro, I’m sure you can find something useful and learn something.
Articles will come on Tuesdays at 7 pm once every three weeks since I’m publishing at the same timeline articles about SharePoint and Power Automate. Reference Articles will be published every Friday at 7 pm also every three weeks.

Power Apps: Now Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: Now Function

Manuel Gomesby Manuel GomesJanuary 17, 2020April 3, 20200

The Power Apps Now function will return the current moment’s date, including the time. Power Apps converts the value automatically to the user’s regional settings when …

Power Apps: Round Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: Round Function

Manuel Gomesby Manuel GomesDecember 20, 2019September 3, 20202

The Round function performs the mathematical round of a number to a specific number of decimal places. It uses the rules defined “Half Round-Up” where it rounds …

Power Apps: RoundUp Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: RoundUp Function

Manuel Gomesby Manuel GomesNovember 29, 2019March 14, 20200

The RoundUp function rounds a number to a specific number of decimal places, always to the nearest higher number. The round is still up regardless of …

Power Apps: No more magic numbers
Microsoft / Power Apps

Power Apps: No more magic numbers

Manuel Gomesby Manuel GomesNovember 26, 2019March 14, 20200

When building a Power App, one of the most common items that we use is the Browse Gallery. You can create lists of anything quickly, …

Power Apps: RoundDown Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

Power Apps: RoundDown Function

Manuel Gomesby Manuel GomesNovember 8, 2019March 14, 20200

The RoundDown function rounds a number to a specific number of decimal places, always to the nearest lower number. The round is still down regardless of …

PowerApps: Text Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

PowerApps: Text Function

Manuel Gomesby Manuel GomesOctober 18, 2019September 18, 20190

The Text function is widely used in PowerApps and for a good reason. It converts any value to a text field to display. For numbers …

PowerApps: Formatting user friendly date ranges
Microsoft / Power Apps

PowerApps: Formatting user friendly date ranges

Manuel Gomesby Manuel GomesOctober 15, 2019August 26, 20190

Dates are one of the most common items to display to the user, but we need to be careful doing so. Just showing it is …

PowerApps: Delegable Functions Reference
Microsoft / Power Apps / Reference

PowerApps: Delegable Functions Reference

Manuel Gomesby Manuel GomesSeptember 27, 2019May 5, 20200

By default, PowerApps tries to deal with the information in the client. For a small number of records, the client can quickly deal with operations …

Power Apps: Delegation Issue and workarounds
Microsoft / Power Apps

Power Apps: Delegation Issue and workarounds

Manuel Gomesby Manuel GomesSeptember 24, 2019January 14, 20211

As soon as you start using PowerApps, you understand how powerful they can be, but you’ll find the following alert message quickly. Delegation warning. This …

PowerApps: Switch Function
Microsoft / Power Apps / Power Apps Function Reference / Reference

PowerApps: Switch Function

Manuel Gomesby Manuel GomesSeptember 6, 2019September 18, 20190

The Switch function evaluates a formula and tries to find it in the list of matches defined. It stops in the first match that validates …

Posts navigation

Previous 1 2 3 4 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

Podcast: Big Data

February 27, 2021February 24, 2021

Book: Good Luck? Bad Luck? Who Knows?

February 26, 2021February 24, 2021

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
admin - Power Automate: substring Function

Hi Reindert, There's another function that can help on this. lastIndexOf(, ). Cheers Manuel

Reindert - Power Automate: substring Function

What if you want the startindex to count from the other side (right-side) of a string?

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…

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

Podcast: Big Data

February 27, 2021February 24, 2021

Book: Good Luck? Bad Luck? Who Knows?

February 26, 2021February 24, 2021

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

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