0

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:

enter image description here

So which SharePoint lists are eligible for quick charts?

1 Answer 1

1

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.

3
  • thanks for the reply... when i run the url 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?
    – John John
    Commented Oct 23, 2021 at 9:22
  • Yes, I was about to mention this >> see my updated answer. Commented Oct 23, 2021 at 9:45
  • Please mark this as an Answer if it helped you in any way. It will help others with similar question in future to find the correct answer easily. Commented Oct 23, 2021 at 12:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.