SharePoint: IF Function
by “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 …
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: The balance between choice and lookup
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
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
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
“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
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 …
SharePoint: Properly translate your list column names
A while ago, I wrote an article a while describing my SharePoint’s best practices, but one thing I failed to mention was proper localization of …
Power Automate: Save multi-choice Microsoft Forms
The team ran into this issue while parsing multi-choice Microsoft Forms elements into SharePoint using Power Automate. The problem is described correctly in the Power Automate …
SharePoint: REPT Function
“REPT function” will return a text value that has a specific string repeated X number of times. Usage It follows a simple pattern. String to …
SharePoint: Now Function
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 …