Forum Discussion

Peki72's avatar
Peki72
Copper Contributor
Aug 16, 2023
Solved

Sharepoint list with JSCON code in default listview does not display all the rows?

Dear Community,

I have a SharePoint list in default listview with JSCON code to format the view.

It works perfect only Sharepoint does not display all the rows. I have 4500 records

and only 40 are displayed. What can i do about this?

 

{

  "$schema": https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json,

  "hideSelection": true,

  "hideListHeader": true,

  "rowFormatter": {

    "elmType": "div",

    "style": {

      "float": "left",

      "display": "flex",

      "flex-wrap": "wrap",

      "flex-direction": "column",

      "align-items": "center",

      "justify-content": "space-around",

      "min-width": "300px",

      "min-height": "286px",

      "border-radius": "8px",

      "margin-right": "10px",

      "margin-bottom": "10px",

      "box-shadow": "2px 2px 4px darkgrey"

    },

    "attributes": {

      "class": "ms-bgColor-neutralLighterAlt ms-bgColor-neutralLight--hover ms-fontColor-themePrimary--hover"

    },

    "customRowAction": {

      "action": "defaultClick"

    },

    "children": [

      {

        "elmType": "div",

        "children": [

          {

            "elmType": "img",

            "style": {

              "display": "block",

              "border-radius": "50%"

            },

            "attributes": {

              "src": "=getUserImage([$FotoE.email], 'M')"

            }

          }

        ]

      },

      {

        "elmType": "div",

        "style": {

          "text-align": "center"

        },

        "children": [

          {

            "elmType": "div",

            "style": {

              "font-weight": "500",

              "font-size": "1.0rem"

            },

            "txtContent": "[$field_1]"

          },

          {

            "elmType": "div",

            "style": {

              "font-weight": "500",

              "font-size": "1.1em",

              "overflow": "hidden",

              "max-width": "280px",

              "white-space": "nowrap"

            },

            "txtContent": "[$field_4]"

          },

          {

            "elmType": "div",

            "style": {

              "font-weight": "500",

              "font-size": "1.1em",

              "overflow": "hidden",

              "max-width": "280px",

              "white-space": "nowrap"

            },

            "txtContent": "[$field_5]"

          }

        ]

      },

      {

        "elmType": "div",

        "children": [

          {

            "elmType": "span",

            "style": {

              "height": "2rem",

              "width": "2rem",

              "font-size": "2em",

              "cursor": "pointer",

              "margin": "0px 5px",

              "vertical-align": "text-bottom"

            },

            "children": [

              {

                "elmType": "a",

                "style": {

                  "cursor": "pointer"

                },

                "attributes": {

                  "class": "ms-bgColor-neutralLighterAlt ms-bgColor-neutralLight--hover ms-fontColor-themePrimary--hover",

                  "iconName": "OutlookLogo",

                  "href": "='mailto:' + [$field_6]",

                  "title": "Email"

                }

              }

            ]

          },

          {

            "elmType": "span",

            "style": {

              "height": "2rem",

              "width": "2rem",

              "font-size": "2em",

              "cursor": "pointer",

              "margin": "0px 5px",

              "vertical-align": "text-bottom"

            },

            "children": [

              {

                "elmType": "a",

                "style": {

                  "cursor": "pointer"

                },

                "attributes": {

                  "class": "ms-fontColor-magentaLight",

                  "iconName": "TeamsLogo",

                  "href": "='https://teams.microsoft.com/l/chat/0/0?users=' + [$field_6]",

                  "title": "Teams"

                }

              }

            ]

          }

        ]

      }

    ]

  }

}

 

  • Peki72 Try adding below at line no. 4 in your above JSON: 

     

    "fillHorizontally": true,

     


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 Reply

  • Peki72 Try adding below at line no. 4 in your above JSON: 

     

    "fillHorizontally": true,

     


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.