SharePoint List Formatting
Back to view formats
View formattingSharePoint Online

Video Gallery

A gallery view of video stored in SharePoint with a card layout showing rich metadata such as title, description, people, tools topics covered, social sharing options like yammer, share and like.

Get this format View on GitHub

Shared by Anand Ragav
Updated Nov 23, 2021

Video Gallery 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/tile-formatting.schema.json",
  "height": 400,
  "width": 280,
  "hideSelection": true,
  "hideColumnHeader": true,
  "formatter": {
    "elmType": "div",
    "attributes": {
      "class": "ms-borderColor-neutralLight"
    },
    "style": {
      "box-sizing": "border-box",
      "width": "100%",
      "border-width": "2px",
      "box-shadow": "0px 1.6px 3.6px 0 #00000024, 0px 0.3px 0.9px 0 #00000024",
      "border-style": "solid",
      "padding": "0 0 0 0px",
      "margin-bottom": "2px",
      "display": "flex",
      "flex-direction": "column"
    },
    "children": [
      {
        "elmType": "div",
        "attributes": {
          "class": "ms-fontSize-s"
        },
        "style": {
          "width": "100%",
          "line-height": "1.5em",
          "padding": "4px",
          "padding-left": "16px",
          "background-color": "=if([$Track] =='Keynote', '#0fc373', if([$Track] =='Product Roundtables', '#ff8c0a',  if([$Track] =='Breakout', '#af78d2' '#0082f0')))",
          "color": "white",
          "font-size": "13.5px"
        },
        "txtContent": "[$Track]"
      },
      {
        "elmType": "div",
        "style": {
          "width": "100%",
          "flex": "0px 1px 1px",
          "display": "flex",
          "align-items": "center"
        },
        "children": [
          {
            "elmType": "img",
            "attributes": {
              "src": "[$Image.serverRelativeUrl]"
            },
            "style": {
              "float": "left",
              "width": "100%"
            }
          }
        ]
      },
      {
        "elmType": "div",
        "style": {
          "flex": "0 0 0px",
          "display": "flex",
          "flex-wrap": "wrap",
          "flex-direction": "column"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "flex": "0 0 0px",
              "box-sizing": "border-box",
              "padding": "10px"
            },
            "children": [
              {
                "elmType": "div",
                "attributes": {
                  "class": "ms-fontSize-xl"
                },
                "style": {
                  "border": "0",
                  "padding": "4px",
                  "color": "white",
                  "position": "absolute",
                  "left": "10px",
                  "top": "40px",
                  "background-color": "transparent",
                  "cursor": "pointer"
                },
                "txtContent": "[$Session]",
                "customRowAction": {
                  "action": "defaultClick"
                }
              },
              {
                "elmType": "div",
                "attributes": {
                  "class": "ms-fontSize-m"
                },
                "style": {
                  "line-height": "1.5em",
                  "margin-bottom": "8px",
                  "padding-top": "6px"
                },
                "customCardProps": {
                  "openOnEvent": "hover",
                  "directionalHint": "rightCenter",
                  "isBeakVisible": true,
                  "beakStyle": {
                    "backgroundColor": "#3c3c3c"
                  },
                  "formatter": {
                    "elmType": "div",
                    "style": {
                      "color": "white",
                      "background-color": "#3c3c3c",
                      "width": "300px",
                      "padding": "10px"
                    },
                    "txtContent": "[$About]"
                  }
                },
                "txtContent": "=if(indexOf([$About] + '|', '|' ) > 180, substring([$About], 0, 180) + '...', [$About])"
              },
              {
                "elmType": "div",
                "attributes": {
                  "class": "sp-row-listPadding"
                },
                "style": {
                  "position": "absolute",
                  "left": "10px",
                  "top": "320px",
                  "font-size": "13px"
                },
                "txtContent": "=if([$Age] <=1, 'Today', [$Age] + ' days ago')"
              },
              {
                "elmType": "span",
                "style": {
                  "background-color": "white",
                  "border-radius": "10%",
                  "position": "absolute",
                  "left": "12px",
                  "top": "165px",
                  "display": "flex",
                  "flex-direction": "row"
                },
                "children": [
                  {
                    "forEach": "choiceIterator in [$Tool]",
                    "elmType": "div",
                    "attributes": {
                      "class": "ms-bgColor-themePrimary ms-fontColor-white ms-fontSize-xl",
                      "title": "=[$choiceIterator]",
                      "iconName": "=if([$choiceIterator] == 'Teams', 'TeamsLogo' , if([$choiceIterator] == 'Forms', 'OfficeFormsLogo' , if([$choiceIterator] == 'SharePoint', 'SharepointLogo' , if([$choiceIterator] == 'Whiteboard', 'WhiteboardApp32' , if([$choiceIterator] == 'Stream', 'StreamLogo' , if([$choiceIterator] == 'Office', 'OfficeLogo' , if([$choiceIterator] == 'Computer', 'System' , if([$choiceIterator] == 'PowerApps', 'PowerApps' ,  if([$choiceIterator] == 'Power Automate', 'MicrosoftFlowLogo' , if([$choiceIterator] == 'Mobile', 'CellPhone' , if([$choiceIterator] == 'Outlook', 'OutlookLogo' ,  if([$choiceIterator] == 'Planner', 'PlannerLogo' ,  if([$choiceIterator] == 'To-Do' ,'ToDoLogoInverse', if([$choiceIterator] == 'Security' , 'LaptopSecure', 'SharePointLogo')))))))))"
                    },
                    "style": {
                      "background-color": "white",
                      "border-radius": "100%",
                      "width": "25px",
                      "height": "20px",
                      "text-align": "center",
                      "padding": "2px",
                      "margin": "1px",
                      "color": "=if([$choiceIterator] == 'Teams', '#6264a7',  if([$choiceIterator] == 'SharePoint', '#036C70', if([$choiceIterator] == 'Forms', '#007F70', if([$choiceIterator] == 'Outlook', '#0078D4', if([$choiceIterator]== 'Stream',  '#BC1948', if([$choiceIterator] == 'PowerApps', '#752875', if([$choiceIterator] == 'Mobile', '#0E41B1', if([$choiceIterator] == 'Computer', '#73276C', if([$choiceIterator] == 'Power BI', '#EDBF2C', if([$choiceIterator] == 'Whiteboard', '#1E8EE5', if([$choiceIterator] == 'To-Do' , '#175BBD', '#252423' )))))))))"
                    }
                  }
                ]
              }
            ]
          },
          {
            "elmType": "div",
            "attributes": {
              "class": "ms-bgColor-transparent sp-css-borderColor-neutralLight"
            },
            "style": {
              "position": "absolute",
              "right": "8px",
              "top": "150px"
            },
            "children": [
              {
                "elmType": "div",
                "attributes": {
                  "class": "sp-card-previewColumnContainer"
                },
                "children": [
                  {
                    "elmType": "div",
                    "style": {
                      "display": "flex"
                    },
                    "children": [
                      {
                        "elmType": "p",
                        "attributes": {
                          "class": "sp-card-userEmptyText"
                        },
                        "txtContent": "=if(length([$Responsible]) == 0, '–', '')"
                      },
                      {
                        "forEach": "personIterator in [$Responsible]",
                        "elmType": "a",
                        "attributes": {
                          "class": "=if(loopIndex('personIterator') >= 5, 'sp-card-userContainer', 'sp-card-userContainer sp-card-keyboard-focusable')"
                        },
                        "style": {
                          "display": "=if(loopIndex('personIterator') >= 5, 'none', '')"
                        },
                        "children": [
                          {
                            "elmType": "img",
                            "defaultHoverField": "[$personIterator]",
                            "attributes": {
                              "src": "=getUserImage([$personIterator.email], 'S')",
                              "title": "[$personIterator.title]",
                              "class": "sp-card-userThumbnail"
                            },
                            "style": {
                              "display": "=if(length([$Responsible]) > 5 && loopIndex('personIterator') >= 4, 'none', '')",
                              "border-radius": "50%",
                              "padding": "-1px"
                            }
                          },
                          {
                            "elmType": "div",
                            "attributes": {
                              "class": "ms-bgColor-neutralLight ms-fontColor-neutralSecondary sp-card-userOthers"
                            },
                            "style": {
                              "display": "=if(length([$Responsible]) > 5 && loopIndex('personIterator') == 4, '', 'none')",
                              "border-radius": "50%"
                            },
                            "customCardProps": {
                              "formatter": {
                                "elmType": "div",
                                "attributes": {
                                  "class": "sp-card-personCallout"
                                },
                                "children": [
                                  {
                                    "forEach": "personIterator in [$Responsible]",
                                    "elmType": "div",
                                    "attributes": {
                                      "class": "sp-card-userContainer sp-card-userCustomCard"
                                    },
                                    "style": {
                                      "display": "=if(loopIndex('personIterator') < 4, 'none', '')",
                                      "border-radius": "50%"
                                    },
                                    "children": [
                                      {
                                        "elmType": "img",
                                        "defaultHoverField": "[$personIterator]",
                                        "attributes": {
                                          "src": "=getUserImage([$personIterator.email], 'S')",
                                          "title": "[$personIterator.title]",
                                          "class": "sp-card-userThumbnail"
                                        }
                                      }
                                    ]
                                  }
                                ]
                              },
                              "openOnEvent": "hover"
                            },
                            "children": [
                              {
                                "elmType": "span",
                                "txtContent": "='+' + toString(length([$Responsible]) - (4))"
                              }
                            ]
                          }
                        ]
                      }
                    ]
                  }
                ]
              }
            ]
          },
          {
            "elmType": "span",
            "style": {
              "flex": "0px 10px 0px",
              "display": "flex",
              "flex-direction": "row"
            },
            "children": [
              {
                "elmType": "span",
                "children": [
                  {
                    "elmType": "button",
                    "customRowAction": {
                      "action": "defaultClick"
                    },
                    "style": {
                      "position": "absolute",
                      "left": "-1px",
                      "top": "350px",
                      "width": "60px",
                      "margin-left": "10px",
                      "display": "span",
                      "background-color": "transparent",
                      "border-radius": "4px",
                      "border-color": "#0082f0"
                    },
                    "txtContent": "Watch",
                    "attributes": {
                      "class": "sp-row-button ms-borderColor-blue sp-row-button ms-bgColor-purpleDark--hover ms-fontWeight-semibold ms-fontColor-black"
                    }
                  }
                ]
              },
              {
                "elmType": "span",
                "children": [
                  {
                    "elmType": "a",
                    "customRowAction": {
                      "action": "defaultClick"
                    },
                    "style": {
                      "position": "absolute",
                      "left": "110px",
                      "top": "348px",
                      "width": "40px",
                      "margin-left": "10px",
                      "display": "span",
                      "background-color": "transparent",
                      "border-radius": "4px"
                    },
                    "attributes": {
                      "title": "Join the conversation",
                      "class": "sp-row-button sp-row-button ms-bgColor-purpleDark--hover ms-fontWeight-semibold ms-fontColor-black",
                      "href": "=if([$Yammer] == '', 'https://web.yammer.com/main/topics/eyJfdHlwZSI6IlRvcGljIiwiaWQiOiI2NzYwNDM4OTg4OCJ9/all', [$Yammer])",
                      "target": "_blank"
                    },
                    "children": [
                      {
                        "elmType": "span",
                        "style": {
                          "color": "#0082f0",
                          "align-content": "center",
                          "padding": "6px",
                          "padding-left": "12px",
                          "white-space": "normal"
                        },
                        "attributes": {
                          "iconName": "YammerLogo",
                          "class": "ms-font-xl"
                        }
                      }
                    ]
                  }
                ]
              },
              {
                "elmType": "span",
                "children": [
                  {
                    "elmType": "button",
                    "customRowAction": {
                      "action": "setValue",
                      "actionInput": {
                        "User": "=if(indexOf([$User.email] , @me) > -1 , removeFrom([$User.email] , @me) , appendTo([$User.email] , @me))"
                      }
                    },
                    "style": {
                      "position": "absolute",
                      "right": "45px",
                      "top": "350px",
                      "width": "40px",
                      "margin-left": "10px",
                      "display": "span",
                      "background-color": "transparent",
                      "border-radius": "4px"
                    },
                    "attributes": {
                      "class": "sp-row-button sp-row-button ms-bgColor-purpleDark--hover ms-fontWeight-semibold ms-fontColor-black"
                    },
                    "children": [
                      {
                        "elmType": "span",
                        "style": {
                          "color": "#0082f0",
                          "align-content": "left",
                          "justify-content": "left",
                          "padding": "4px",
                          "white-space": "normal"
                        },
                        "attributes": {
                          "iconName": "=if(indexOf([$User.email] , @me) > -1 ,'LikeSolid', 'Like')",
                          "class": "ms-font-xl"
                        }
                      }
                    ]
                  },
                  {
                    "elmType": "div",
                    "attributes": {
                      "class": "sp-row-listPadding"
                    },
                    "style": {
                      "position": "absolute",
                      "left": "230px",
                      "top": "358px",
                      "font-size": "18px"
                    },
                    "txtContent": "=if(length([$User]) > 0, length([$User]), ''"
                  }
                ]
              },
              {
                "elmType": "span",
                "children": [
                  {
                    "elmType": "button",
                    "customRowAction": {
                      "action": "share"
                    },
                    "style": {
                      "position": "absolute",
                      "left": "150px",
                      "top": "350px",
                      "width": "40px",
                      "margin-left": "10px",
                      "display": "span",
                      "background-color": "transparent",
                      "border-radius": "4px"
                    },
                    "attributes": {
                      "title": "Share it",
                      "class": "sp-row-button sp-row-button ms-bgColor-purpleDark--hover ms-fontWeight-semibold ms-fontColor-black"
                    },
                    "children": [
                      {
                        "elmType": "span",
                        "style": {
                          "color": "#0082f0",
                          "align-content": "left",
                          "justify-content": "left",
                          "padding": "4px",
                          "white-space": "normal"
                        },
                        "attributes": {
                          "iconName": "Share",
                          "class": "ms-font-xl"
                        }
                      }
                    ]
                  }
                ]
              },
              {
                "elmType": "span",
                "children": [
                  {
                    "elmType": "a",
                    "customRowAction": {
                      "action": "defaultClick"
                    },
                    "style": {
                      "position": "absolute",
                      "left": "70px",
                      "top": "348px",
                      "width": "40px",
                      "margin-left": "10px",
                      "display": "span",
                      "background-color": "transparent",
                      "border-radius": "4px"
                    },
                    "attributes": {
                      "title": "Join the conversation",
                      "class": "sp-row-button sp-row-button ms-bgColor-purpleDark--hover ms-fontWeight-semibold ms-fontColor-black",
                      "href": "[$Learning]",
                      "target": "_blank"
                    },
                    "children": [
                      {
                        "elmType": "span",
                        "style": {
                          "color": "#0082f0",
                          "align-content": "center",
                          "padding": "6px",
                          "padding-left": "12px",
                          "white-space": "normal"
                        },
                        "attributes": {
                          "iconName": "D365TalentLearn",
                          "class": "ms-font-xl"
                        }
                      }
                    ]
                  }
                ]
              }
            ]
          }
        ]
      }
    ]
  }
}
View sourceLink to this definitionvideo-gallery.json

From the contributor

How to use this sample

Summary

A gallery view of video stored in SharePoint with a card layout showing rich metadata such as title, description, people, tools topics covered, social sharing options like yammer, share and like.

screenshot of the sample

View requirements

Column Name Type
Title Single Line Text
Description Multi Line Text
Track Choice
Session Single Line Text
About Multi Line Text
Responsible Person or Group
Image Image
Learning Hyperlink
Yammer Hyperlink
User Person or Group
Age Calculated (=DATEDIF(Created,TODAY(),"d"))
Tool Choice

Sample

Solution Author(s)
video-gallery.json Anand Ragav

Version history

Version Date Comments
1.0 November 23, 2021 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

Keep exploring

More formats like this

Key Dates Timeline Checklist

A modern horizontal timeline view that displays key dates or milestones as monthly columns.

Explore format

Sports Card

This SharePoint JSON view formatting sample transforms list items into vertical sports trading cards with header bar, country badge, player silhouette, name band, star rating and three stat bars.

Explore format

Credit / Loyalty Card

Transforms list items into realistic credit / loyalty cards with a brand name, tier pill, EMV chip, contactless symbol, embossed card number, cardholder, expiry, and network logo. The card colour is driven by the Tier value.

Explore format