Skip to content
March 8, 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: SharePoint

SharePoint is a platform that evolved a lot in the past few years. It provides a simple and straightforward interface that allows you to do advanced operations quite efficiently. I write these articles with step-by-step tutorials to teach you how to build your sites in SharePoint. Once you understand these concepts, you will be able to, develop, and provide rich collaboration platforms with not a lot of work. These can give document version control, document collaboration, and even store organized data. 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 Power Apps and Power Automate. Reference Articles will be published every Friday at 7 pm also every three weeks.

SharePoint: Color-code your columns
Featured / Microsoft / SharePoint

SharePoint: Color-code your columns

Manuel Gomesby Manuel GomesSeptember 29, 2020September 27, 20200

I already wrote some articles on SharePoint but none on customization. This week I’ll talk about color-code your columns. Since SharePoint is aware of types …

Microsoft Forms: Format Submitted Data
Microsoft / Microsoft Forms / Power Automate / SharePoint

Microsoft Forms: Format Submitted Data

Manuel Gomesby Manuel GomesJuly 10, 2020July 10, 20200

I want to show you today something that makes some people confused. When you create a form, you can define that a field is a …

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 …

When to use OneDrive vs SharePoint Sites Libraries
Featured / Microsoft / Microsoft Planner / Microsoft Teams / SharePoint

When to use OneDrive vs SharePoint Sites Libraries

Manuel Gomesby Manuel GomesJune 24, 20202

As we work more and more from home and use Office 365’s collaboration tools, we use things like OneDrive, SharePoint, Word, Excel, etc., but most …

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 …

SharePoint: The balance between choice and lookup
Microsoft / SharePoint

SharePoint: The balance between choice and lookup

Manuel Gomesby Manuel GomesMay 19, 2020June 2, 20200

SharePoint Lists have incredibly handy options called choice and lookup. I’m going to oversimplify each of them because the point of this article is not …

SharePoint: ISERROR Function
Microsoft / SharePoint / SharePoint List Function Reference

SharePoint: ISERROR Function

Manuel Gomesby Manuel GomesApril 17, 2020March 27, 20200

Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that you don’t display to the user …

SharePoint: Different View for the same data
Microsoft / SharePoint

SharePoint: Different View for the same data

Manuel Gomesby Manuel GomesMarch 10, 2020June 2, 20200

We’ve touched a little bit on this in the topic of my last posts as the notion that you can display the information that you …

SharePoint: CONCATENATE Function
Microsoft / SharePoint / SharePoint List Function Reference

SharePoint: CONCATENATE Function

Manuel Gomesby Manuel GomesMarch 6, 2020February 26, 20200

“CONCATENATE function” will group a series of values into a unique string. I like the concatenate function since you can use more than strings. Usage …

SharePoint: Create a list based on folders
Microsoft / SharePoint

SharePoint: Create a list based on folders

Manuel Gomesby Manuel GomesMarch 3, 2020June 2, 20200

Imagine the following situation. You have a department that controls the events of your company. Each place (gym, hotel, etc.) is free to book their …

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

September 24, 2020September 23, 2020

Microsoft Forms: Integrate with Microsoft Teams

March 8, 2021March 7, 2021

Podcast: The Happiness Lab with Dr. Laurie Santos

March 7, 2021March 7, 2021

Book: Sapiens: A Brief History of Humankind

March 5, 2021February 24, 2021

Power Automate: length Function

March 4, 2021February 23, 2021

Tools: Skitch

March 3, 2021March 3, 2021
JCL - Power Automate: replace Function

You can find it here: powerusers.microsoft.com/t5/Building-Flows/RSS-filtered-Array-item-replace/m-p/849735#M119013 Thanks in advance!

Manuel Gomes - Power Automate: replace Function

Hi JCL, Don't worry. We'll get your Flow working. Cheers Manuel

Manuel Gomes - Power Automate: replace Function

Hey JCL, I think you're in the right way, but I need to see your Flow to see where it…

JCL - Power Automate: replace Function

Any help? thanks in advance... I've tried everywhere for guidance already.

Eric - Flow: Issues loading images in email

This is perfect. I was looking for this solution because I had the same problem, and this worked amazingly. Thanks!

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

Recent

Microsoft Forms: Integrate with Microsoft Teams

March 8, 2021March 7, 2021

Podcast: The Happiness Lab with Dr. Laurie Santos

March 7, 2021March 7, 2021

Book: Sapiens: A Brief History of Humankind

March 5, 2021February 24, 2021

Power Automate: length Function

March 4, 2021February 23, 2021

Tools: Skitch

March 3, 2021March 3, 2021

Video of the Day

Tags

Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Ignite 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