Search

Tracy van der Schyff

Facilitating The Evolution of Human Capabilities

#Microsoft365 Day 238: Validate length and number only with Column Validations in #SharePoint

In this example, I would like to validate the length of the ID number as well as that it only contains numbers. Of course if it must be numbers, just use a number column, but if it's meant for ID,... Continue Reading →

#Microsoft365 Day 237: Validate Email Addresses in #SharePoint with Column Validations

Using a single line of text for email addresses are tricky, as there's no checks. If you use column validation it can at least do a couple of checks for you. See how we can validate whether an address includes... Continue Reading →

#Microsoft365 Day 236: Validate dates in #SharePoint with List Validations

Here's another great OTB function in SharePoint, that allows you to validate the data in your list, which gives the user an error on the form. In this example I'll show you how to validate that a delivery date must... Continue Reading →

#Microsoft365 Day 235: Exclude Apps from Search results in #SharePoint

Another great OTB function in SharePoint is to exclude libraries and lists from Search results. You might be wondering why on earth you'd do that - but in the example I've excluded a Document Types Lookup list. Even though everyone... Continue Reading →

#Microsoft365 Day 234: Enforce Unique Values for Metadata in #SharePoint

The Enforce Unique Values is a great OTB SharePoint functionality which allows you to set a list or library, to not allow items with the same value. This of course can cause a lot of trouble if that was not... Continue Reading →

#Microsoft365 Day 233: Limit the people you can pick from in a Person or Group Picker in #SharePoint

This is a nifty way to limit the group of people that users can select from when using the Person or Group Picker. You might have an Capex Approver Group and want to limit the selections to that group.  ... Continue Reading →

Up ↑