Forum Discussion
Json modern sharepoint list
Dear community,
I would want to make some customizations to modern sharepoint list like. I want to display 5 years of data in tabular form. This should add a new year each next year. Is it possible using json and out of the box. Each year I would wanthe amount to be added and should in tabular form.
Thanks
Hi vaibhavk665
i understand that you want to transpose your list and that you want to display the list rows als columns and the list columns as rows.
This is not really possible with list formatting alone, but you can kind of simulate that.
If you have a list "Amounts"then you can switch the view to gallery mode
And you get thisNow we display all list items as cards next to each other. If you add another year, then the new card will be added on the right. But if there is not enough space, then the card will be pushed to the next row. So we cannot add an endless number of years there.
But we can style these cards using json formatting to make them look more like a transposed table.
But if you want to be able to add an endless number of years to the list and they all must be displayed as columns (and not flow into the next row) then this is not possible with list formatting. You should create a Power BI Report in that case and embed that on your SharePoint Site.
Best Regards,
Sven
2 Replies
Hi vaibhavk665
i understand that you want to transpose your list and that you want to display the list rows als columns and the list columns as rows.
This is not really possible with list formatting alone, but you can kind of simulate that.
If you have a list "Amounts"then you can switch the view to gallery mode
And you get thisNow we display all list items as cards next to each other. If you add another year, then the new card will be added on the right. But if there is not enough space, then the card will be pushed to the next row. So we cannot add an endless number of years there.
But we can style these cards using json formatting to make them look more like a transposed table.
But if you want to be able to add an endless number of years to the list and they all must be displayed as columns (and not flow into the next row) then this is not possible with list formatting. You should create a Power BI Report in that case and embed that on your SharePoint Site.
Best Regards,
Sven- Thanks SvenSieverding, to maintain this one, should i add a new year column for each new year? This is something new to learn. Requirement is to pass or select initial year and then subsequent 4 years should get added.
