SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I have a SharePoint communication site, which contain 16 custom lists and 6 document libraries, but when I tried to create a chart using the modern Charts web part, I only get 3 lists inside the List drop-down:
So which SharePoint lists are eligible for quick charts?
When you select Get data from a SharePoint list on this site option in quick charts web part, SharePoint retrieves lists from current site using below endpoint:
https://tenant.sharepoint.com/sites/SPConnect/_api/web/lists?$filter=(BaseTemplate ne 101) and (BaseTemplate ne 119) and (Hidden eq false)&$select=Id,Title,DefaultViewUrl
That means all the list types except Document library (101) & WebPageLibrary(119) and lists which are not hidden should be shown in List dropdown in quick charts web part.
Reference: ListTemplateType enumeration
Also, I have noticed that dropdown is showing only the lists which has at least one Number/Currency column.
The list should have at least one text and one number or currency type column, else the list will not appear in the dropdown list.
https://tenant.sharepoint.com/sites/SPConnect/_api/web/lists?$filter=(BaseTemplate ne 101) and (BaseTemplate ne 119) and (Hidden eq false)&$select=Id,Title,DefaultViewUrl i will get all the lists.. but inside the "List" drop-down only 3 out of 16 will be shown.. could the reason be that the lists inside the "List" drop-down should have at-least one column of type Number?
Oct 23, 2021 at 9:22