Add data to Chart components

(1) Share

Report

Posted on by ROSEBLACK

205

Hi Everyone,

Following DeepakS topic via https://community.powerplatform.com/galleries/gallery-posts/?postid=da29fe0e-a61d-497d-8190-bb42f724abf1

Can you please show how to add our data to chart?

I have tried but not working.

Regards,

ROSE

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

ROSEBLACK 205 on at

Like (0)

Report

Hi Everyone,
@DeepakS

Would someone help me?

Thanks!
ROSE

Was this reply helpful? Yes No
MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

The errors saying the table which you passed has none of the expected columns (Category / DataValue) can you please correct the datasource.

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

DearMSR@08012015

My datasource is correct. Can you please see below?

Regards,

ROSE

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

Hi all,

DeepakS

MSR@08012015

I would really appreciate if someone could please help me with this issue.

Regards,

ROSE

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

I'm still waiting for solution hope someone can help on this.

Thank a lot!

ROSE

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report
Hi @ROSEBLACK
Try to use Total rather than "Total" first and similarly to other fields. and try.
SortByColumns( AddColumns( GroupBy( DBarChart_1.ChartData, Item, MyGroup ), Total, Sum( MyGroup.DataValue, DataValue ) ), "Total" )

I try my best to give you another example , Suppose I have sample data in a Table1 in Excel file and I save it in OneDrive,

I add this data into the app, and add a button , then OnSelect=

ClearCollect( FormattedData, ShowColumns( Table1, Item,TotalAmount ) )

then I assign FormattedData to CharData., hope it will help you.

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

Dear stampcoin,

Thank you for your helping me on this issue.

You are using an excel file in OneDrive.

I have a SharePoint list name is TEST with columns: Name (Elon Mush, Jeff Bezos, Mark Zuckerberg,...) and ColorColumns (choise: Blue, Red Yellow, ...)

Can you please share with me how to use the code?

in the video: https://www.youtube.com/watch?v=QcTJ8dkcglY&t=149s

SharePoint list name: ChartSampleList

Total column

Change to Units column

I have tried to create the same the SharePoint list but facing the error after connect it.

Thanks a lot!

ROSE

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

Hi @ROSEBLACK,

I think the name of the field is the problem.

when you check the ChartSampleList, please click it see my screen shot.

Then it gives you the overview of the list table, and also the column name.

field2 column, on my sharepoint is Item, but here is different.

in the ChartGropedData, specify the column name refers to the list table view.

You are almost there. :)

good luck.

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

Dear stampcoin

It's showing the SharePoint list name is correct.

But it's showing the error below:

ChartSampleList = There is an error in this formula. Try revising the formula and running it again. Data type: Table

Your advises pls.

Thanks a lot!

ROSE

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

@ROSEBLACK Hi,

Have you tried to re-connect your list ? if not please try to delete it and add it back.
one more thing, did you add the control in a screen ?

Was this reply helpful? Yes No