SharePoint List Formatting
Back to view formats
View formattingSharePoint Online

Current User's Rows (Using a Multi-Person Column)

Highlights the entire row for any list items where one of the assigned to users is the current user (the user viewing the list view, not the author of the format). You can easily adjust this to use a different person column by changing the `[$AssignedTo]` portion of the expression.

Get this format View on GitHub

Shared by Chris Kent
Updated Jan 29, 2019

Current User's Rows (Using a Multi-Person Column) formatting preview
Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

1 definition

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

View formatting
Download JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "additionalRowClass": "=if(indexOf(join([$AssignedTo.email],';'), @me) != -1, 'ms-bgColor-themeLight ms-bgColor-themeLighterAlt--hover', '')"
}
View sourceLink to this definitionmulti-person-currentuser-rowclass.json
Schema compatibility review notes

This historical definition differs from the pinned Microsoft schema. This may indicate an unsupported pattern or a schema limitation. Check the original requirements and test in your tenant before use.

  • /additionalRowClass must be object

From the contributor

How to use this sample

Summary

Highlights the entire row for any list items where one of the assigned to users is the current user (the user viewing the list view, not the author of the format). You can easily adjust this to use a different person column by changing the [$AssignedTo] portion of the expression.

By using the Office UI Fabric color classes for themes, we can ensure our format looks good in all themes including both light and dark as well as custom themes.

screenshot of the sample

View requirements

  • This format expects a person column with an internal name of AssignedTo to be part of the view. This column can be single or multi-select.

Sample

Solution Author(s)
multi-person-currentuser-rowclass.json Chris Kent

Version history

Version Date Comments
1.0 January 29, 2019 Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Additional notes

This sample works for both single and multi-select person fields.However, an additional sample is available intended for use with single-select person fields: person-currentuser-rowclass. It is a simpler sample intended to show how to use the @me operator.