SOLVED

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

Copper Contributor

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"

                }

              }

            ]

          }

        ]

      }

    ]

  }

}

 

1 Reply
best response confirmed by Peki72 (Copper Contributor)
Solution

@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 best response

Accepted Solutions
best response confirmed by Peki72 (Copper Contributor)
Solution

@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.

View solution in original post