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

Category: SharePoint List Function Reference

This SharePoint List Function Reference has two main objectives. The first is 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 for this SharePoint List 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 Automation, SharePoint, and PowerApps 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.

SharePoint: Now Function
Microsoft / Reference / SharePoint / SharePoint List Function Reference

SharePoint: Now Function

Manuel Gomesby Manuel GomesDecember 27, 2019November 1, 20190

The SharePoint Now function will return the token serial number of the current date and time. Dates are stored internally as sequential serial numbers to enable …

SharePoint: Today Function
Microsoft / Reference / SharePoint / SharePoint List Function Reference

SharePoint: Today Function

Manuel Gomesby Manuel GomesDecember 6, 2019November 1, 20190

The SharePoint Today function will return the number of elapsed days since a reference date, in this case, December 31, 1899 (serial number 1). These are …

SharePoint: DateDif Function
Microsoft / Reference / SharePoint / SharePoint List Function Reference

SharePoint: DateDif Function

Manuel Gomesby Manuel GomesNovember 15, 2019November 1, 20190

“DateDif function” will return the difference between two dates based on the unit supplied. The units can be: Y(ear) M(onth) D(day) M(onth)D(day) Y(ear)M(onth) Y(ear)D(ay) Please note …

SharePoint: OR Function
Microsoft / Reference / SharePoint / SharePoint List Function Reference

SharePoint: OR Function

Manuel Gomesby Manuel GomesOctober 25, 2019March 28, 20200

Welcome to Function Friday. This week we’ll explore Microsoft’s SharePoint List Function “OR” function. This function will return Yes if any of the arguments are True. If any of …

SharePoint: Len Function
Microsoft / Reference / SharePoint / SharePoint List Function Reference

SharePoint: Len Function

Manuel Gomesby Manuel GomesOctober 4, 2019October 4, 20190

“Len function” will count the number of provided characters in the parameter. It will count them all, including spaces. Usage To use it, it’s quite simple. …

SharePoint: AND Function
Microsoft / Reference / SharePoint / SharePoint List Function Reference

SharePoint: AND Function

Manuel Gomesby Manuel GomesSeptember 13, 2019October 25, 20190

Welcome to Function Friday. This week we’ll explore Microsoft’s SharePoint List Function “AND” function. This function will return “Yes” if all arguments are “true”. If any of them are …

Posts navigation

Previous 1 2

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