Chart from sharepoint list

[chhe]

Hello,

I want to create a circular chart from a sharepoint list. I have a task list, in this list there a different colums, but I only need 3 for my chart:

AssignedTo (Person/Group Column)

Title (one line text)

time (number column)

I want to create a separate chart for each person. In this chart there should be all Items for the person with Title and time. Could you please help me?

[v-bofeng-msft]

Hi @chhe :

Could you tell me:

Do you want to get a dashboard like this?

Does your “AssignedTo” field allow multiple selections?

I’ve made a test for your reference:

I assume the “AssignedTo” field does not allow multiple selections.

Here is my data source :list4

Step1:add a gallery and set it’s items property to :

GroupBy(ForAll(list4,{AssignedTo:AssignedTo.DisplayName,Title:'Title',time:time}),"AssignedTo","Image") /*image is a new column name created by groupby function*/

Step2:add a pie chart control into this gallery and set it’s text property to:

ThisItem.AssignedTo

Set it’s Items property to :

ThisItem.Image

Set it’s Items property to (This formula should be filled automatically):

ThisItem.Image.Title

Then you will get the result.

Best Regards,

Bof

[chhe]

Yes, this dashboard looks good.

I don't know where I can change the gallery item property. I have filled it in in the "Items = fx" field.

Is that correct? At my gallery there appears a little red "X"? My list name is "Testkachel".

[v-bofeng-msft]

Hi @chhe ：

Firstly,You can change the gallery's item property by following the steps I marked.

Secondly,could you show me more detials about the warning?Screenshots are better.

In addtion ,using app checker is a good way to looking for problems.

Best Regards,

Bof

[chhe]

Okay, then I have filled the code correctly.

I have 5 errors (two different types).

First error:

unexpected character

Second error:

invalid number of arguments

[v-bofeng-msft]

Hi @chhe ：

Sorry I can't recognize your screenshot well due to language.

I have two suggestions：

• Did you quote the field names in the formula correctly?
• In some region, “;” represent “,”, “;;”, represent “;”,maybe you can try:

GroupBy(ForAll(list4;{AssignedTo:AssignedTo.DisplayName;Title:'Title';time:time});"AssignedTo";"Image") 

Best Regards,

Bof

[chhe]

Okay, I restarted the app editor and now it works.

Is it possible to show the time value in the charts? And to create separate charts for each assignedTo Person?

[v-bofeng-msft]

Hi @chhe ：

Q1：Is it possible to show the time value in the charts?Yes！

Q2：create separate charts for each assignedTo Person.

try this code

Filter(ForAll(list4,{AssignedTo:AssignedTo.DisplayName,Title:'Title',time:time}),AssignedTo="username")

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-pie-chart

Best regards,

bof

[chhe]

Q1:

I mean the title value and time value both. So that I can see which task has taken how much time.

Q2:

For the separat charts I used these expression:

Filter(ForAll(Testkachel;{AssignedTo:AssignedTo.DisplayName;Title:Title;Planzeit:Planzeit});AssignedTo="NAME")

But then I get as many equal charts as persons I have under "assignedTo". I only want to have one chart for this person.

I have already read the help under you link, but that didn't help so much. Is there another manual for charts in powerApps? 

[v-bofeng-msft · Accepted solution]

HI @chhe :

Q1:

I think this link will help you a lot.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Pie-Chart-percentages/m-p/26305

Q2:

Can you tell me:

Do you mean you get a lot of pie charts after using that code?

Did you put this code in the items attribute of the gallery?

If this is the case, I think you should add a separate pie chart first ,then add the code in it,s items property.

Best Regards,

Bof