web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Count ColumnChart

Power Apps

Unanswered

Count ColumnChart

(0) Share

Report

Report

Posted on by MiniMax92

151

Hey ho,

i need a "ColumnChart" with singel datas.

My formular is:

CountA( Table( Distinct(SharepointList;Location)))

But it is underline in Red with failure massage: "Table Value needed"

Heeelp :D

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

D_D 107 on at

Like (0)

Report

Hi,

do you try to use the Formula as your Items of the Column Chart?
CountA returns a number, but you need to pass a table as items. This is what the failure message says.
You can try Items = Table(Distinct(SharepointList;Location)) and view the resulting chart.

--------------------------------------------------------------------------------------
If this helps you or solved your question, please like or mark this as an answer.
Best regards, David

Was this reply helpful? Yes No
MiniMax92 151 on at

Like (0)

Report

Thx for your reply,

i try it but now I no longer have an error message, but no columns are displayed. Although there is data in the column. The aim is to count how many are in Location 1 and how many are in Location 2 and so on. And Distinct filters the same locations, that works great too but somehow it doesn't count them.

As you can see in the picture, the names also overlap with each other.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report
Hello, Distinct function return a table with one column. Have you tried to use only the distinct function with the Table function?

CountA(Distinct(SharepointList;Location))

Was this reply helpful? Yes No
MiniMax92 151 on at

Like (0)

Report

Hey,
Yes. The Formular is in Items and your Formular is the same result with no Chart :(

Was this reply helpful? Yes No

Join the conversation