Chart from sharepoint list

(0) Share

Report

Posted on by chhe

140

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report

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".

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
chhe 140 on at

Like (0)

Report
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?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No