web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : UMWwFPw/1UVXlxOUk3klIL
Power Apps - Building Power Apps
Answered

how to create column chart from SP list

Like (0) ShareShare
ReportReport
Posted on 3 Apr 2023 07:02:31 by

i have sharepoint with 30 columns, some column contains people/group where user details avaible.

when i try to connect List to column chart Data: it is not displaying some column in Labels, Series1,2,3,4...

how to get the remaining coloumn there?

Categories:
  • Verified answer
    v-jefferni Profile Picture
    on 04 Apr 2023 at 08:29:07
    Re: how to create column chart from SP list

    Hi @venky232 ,

     

    It depends on the data structure. Basically, you can add a column like the person column and use it to count how many employees each company includes. However, the two scenarios (group by companies or managers) cannot be implemented in a single column chart. You must understand how a column chart works, and this is why I recommended you read the blog, especially need to understand the list structure:

    vjefferni_2-1680596862981.png

    vjefferni_1-1680596747629.png

     

    Best regards,

  • venky232 Profile Picture
    on 04 Apr 2023 at 08:00:56
    Re: how to create column chart from SP list

    this code is working ,but i want to add one more additional column which is choice column (Company).

    how to do this?

  • v-jefferni Profile Picture
    on 04 Apr 2023 at 06:52:30
    Re: how to create column chart from SP list

    Hi @venky232 ,

     

    Column Chart is used for displaying the numbers of each column, so what effect do you want to express with a column chart? Is it how many employees is each manager responsible for? If so, you will need to count the employees that takeover by each manager. Please try below formula in Items of the chart:

    AddColumns(GroupBy(AddColumns(SPList, "manager", ThisRecord.Manager.DisplayName),"manager","EmployeesEach"),"EmployeeSum",CountRows(ThisRecord.EmployeesEach)

     

    X-axis set to the custom "manger" column and the chart will show the number of employees that each manager responsible for.

     

    Best regards,

  • venky232 Profile Picture
    on 04 Apr 2023 at 06:32:01
    Re: how to create column chart from SP list

    i have 2 columns

     column1 : Employees (100 Employees)  & Column2:Manager( contains 10 managers)
    i plotted column chart ,where in X i kept manager ,so it is showing same manager name repeatedly.

  • v-jefferni Profile Picture
    on 04 Apr 2023 at 06:18:13
    Re: how to create column chart from SP list

    Hi @venky232 ,

     

    Could you please share any sample data to describe your list data source? For multiple series column chart, same values are common. 

     

    Below is a blog about creating column chart in PowerApps, for your reference:

    PowerApps charts (Column, Line and Pie Chart) - SPGuides

     

    Best regards,

  • venky232 Profile Picture
    on 04 Apr 2023 at 06:05:39
    Re: how to create column chart from SP list

    it repeating same value in chart

  • v-jefferni Profile Picture
    on 04 Apr 2023 at 06:03:59
    Re: how to create column chart from SP list

    Hi @venky232 ,

     

    Distinct function returns a single column table, so I don't think it should be used for creating the data of a chart.

     

    Best regards,

  • venky232 Profile Picture
    on 04 Apr 2023 at 05:50:41
    Re: how to create column chart from SP list

    its not working if i add distinct

     

    Clearcollect(Coll,AddColumns(Distinct(SPList, "Person1", ThisRecord.PersonColumn.DisplayName,  ThisRecord.PersonColumn1.DisplayName,"Person2"))

  • v-jefferni Profile Picture
    on 04 Apr 2023 at 03:42:38
    Re: how to create column chart from SP list

    Hi @venky232 ,

     

    Could you please share more details about your scenario? What columns would you like to display as series in a Column Chart?

     

    If you would like to use special columns as series, please try and use the AddColumns function to reinforce the table structure, then use these custom columns as chart series:

     

    AddColumns(SPList, "Person1", ThisRecord.PersonColumn.DisplayName, "Person1", ThisRecord.PersonColumn1.DisplayName,"Person2", ThisRecord.PersonColumn2.DisplayName,"Person3", ThisRecord.PersonColumn3.DisplayName)

     

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete