❌

Vue lecture

Il y a de nouveaux articles disponibles, cliquez pour rafraîchir la page.
✇Ganesh Sanap Blogs

SharePoint JSON formatting: Check if date & time column is blank/empty

SharePoint JSON formatting is a great way to customize how columns/fields are displayed in SharePoint list/library views. Many times you want to customize SharePoint list columns (like Status or Expiry of list item) based on other date & time columns in your list. While doing so, when you try to check if date & time column is blank/empty using below expression, it won’t work as expected:

"txtContent": "=if([$DueDate]) == '', '', [$DueDate])"

So, to check if date & time column is blank/empty using SharePoint JSON formatting, you have to use either of below workarounds:

Using Number() function

You can use Number(DateTimeColumn) == 0 to check if the date & time column is blank or not.

Example
{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "=if(Number([$DueDate]) == 0, 'Blank Date', if([$DueDate] < @now, 'Expired', 'Active'))",
    "attributes": {
        "class": "=if(Number([$DueDate]) == 0, 'sp-field-severity--warning', if([$DueDate] < @now, 'sp-field-severity--blocked', 'sp-field-severity--good'))"
    }
}

Where [$DueDate] is an internal name of your SharePoint date and time column.

Output
SharePoint JSON formatting - Check if date and time column is blank or empty
SharePoint JSON formatting – Check if date and time column is blank or empty

You can also find above JSON at list formatting samples on GitHub: Formatting a column when a date column is blank

Using toString() function

You can use toString(DateTimeColumn) == '' to check if the date & time column is blank or not.

Example
{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "=if(toString([$DueDate]) == '', 'Blank Date', if([$DueDate] < @now, 'Expired', 'Active'))",
    "attributes": {
        "class": "=if(toString([$DueDate]) == '', 'sp-field-severity--warning', if([$DueDate] < @now, 'sp-field-severity--blocked', 'sp-field-severity--good'))"
    }
}

Simplest way

You can also check if date & time column is blank/empty using below JSON:

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "=if(@currentField, @currentField, 'Blank Date')",
    "attributes": {
        "class": "=if(@currentField, 'sp-field-severity--good', 'sp-field-severity--warning')"
    }
}
Output
SharePoint JSON formatting - Check if date and time column is blank or empty
SharePoint JSON formatting – Check if date and time column is blank or empty

Learn More

✇Office 365 for IT Pros

Bookable Time Coming to OWA

Driving Usage for the Bookings with Me App

The January 12 announcement that bookable time is coming to Outlook (OWA) is no more than a Microsoft attempt to drive usage of the Bookings with Me app. There’s nothing wrong with that tactic, even if it might make some people think that the announcement brings news of a brand new feature.

Microsoft also refers to bookable time as “Bookings in Outlook” and asserts that the apps helps to reduce “the back and forth in scheduling while helping you [to] maintain control of your calendar.” Bookable time in Outlook is available to users with the following licenses:

  • Office 365: A3, A5, E1, E3, E5, F1, F3 
  • Microsoft 365: A3, A5, E1, E3, E5, F1, F3, Business Basic, Business Standard, Business Premium 

The Magic of Controlled Scheduling

This magic happens through uses creating a personal bookings page where they publish slots where they are available to meet people who care to make a booking through the page. The control Microsoft mentions comes about by the user establishing a schedule of available time slots when the user will accept 1:1 meetings (Figure 1).

Figure 1: Setting up appointment slots for Bookings with me

Microsoft’s documentation for Bookings with Me explains the various settings.

It’s important to emphasize that bookings are regular Outlook meetings that show up in a user calendar alongside other events. There’s absolutely nothing different between a meeting scheduled in the normal way and one created using Bookings with Me. The intelligence in the Bookings with Me app is entirely in the user interface to define available slots and the processing that publishes those slots and allows people to make bookings. Users can edit the settings of their booking pages by going to the Booking app.

Not everyone will want to or be interested in Bookings with Me. Within a company, it’s a facility that people like HR consultants might use to allow employees to easily set up meetings to seek advice, Externally, people need an Azure AD account (school or work account) to book an appointment using Bookings with Me. The calendar owner remains in full control at all time and can reschedule or cancel appointments made with them at any time. Those who request meetings can also cancel or reschedule appointments (with the calendar owner’s assent).

Publishing and Using a Booking Page

When the schedule is ready, the user can publish (share) their availability for meetings. If the user hasn’t published a booking schedule before, the app generates a URL that the user can share with people who might want an appointment (Figure 2). For instance, they could include the URL in their email signature or publish it in their Teams status.

Getting a shareable link for a Bookings with me page
Figure 2: Getting a shareable link for a Bookings with me page

Clicking the link displays the user’s personalized booking page and exposes the available time slots based on the schedule established by the user (Figure 3).

Scheduling an appointment with Bookings with me
Figure 3: Scheduling an appointment with Bookings with me

Bookings and Bookings with Me

Some are confused between Bookings with Me and Microsoft Bookings. The differences are straightforward:

  • Bookings with me is for personal use and deals with 1:1 meetings only. It is an Outlook feature that can schedule Teams online meetings. All events are in the user’s calendar.
  • Microsoft Bookings is a separate application with its own (scheduling) mailboxes intended for use by a group or other entity.

Whether the advent of bookable time in OWA will convince more people to create Bookings with Me pages to allow others to schedule meetings with them remains to be seen. If you need a feature like this, it’s nice to have Bookings with Me. If not, it’s very safe to ignore bookable time.

So much change, all the time. It’s a challenge to stay abreast of all the updates Microsoft makes across Office 365. Subscribe to the Office 365 for IT Pros eBook to receive monthly insights into what happens, why it happens, and what new features and capabilities mean for your tenant.

❌