Unanswered

Help Creating Column Chart from Choice

(0) Share

Report

Posted on by Community Power Pla...

Hi Everyone,

I am trying to create a column chart that displays the number lab test submissions that request a particular test. This information is being pulled from a column in Sharepoint called TestNeeded that is a choice field that allows multiple options to be selected. Below is the code that I am using in the Items section for the bar chart but doesn't seem to be working. I get an error stating "Expected a text, numeric, boolean, or date/time value". Any ideas on what I might be doing wrong?

AddColumns(GroupBy(AddColumns(QualityLabDashboard,"SelectedTest",TestNeeded.Value),"SelectedTest","TestNeededList"),"TestNeeded",CountRows(TestNeededList))

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yutliu-msft on at

Like (0)

Report
Hi @Anonymous ,

The reason why you met this problem is that:

TestNeeded that is a choice field that allows multiple options .

Since it allows multiple options, one TestNeeded will represents a table.

So "TestNeeded.Value" will represent a table instead of a value.

Try this formula:

AddColumns( GroupBy( AddColumns( QualityLabDashboard,"SelectedTest",Concat(TestNeeded,Value&",") ), "SelectedTest","TestNeededList" ),CountRows(TestNeededList))

The key point is to use "Concat(TestNeeded,Value&",")" to represent the value in TestNeeded field.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @v-yutliu-msft,

Thank you for your advice! Your code helped out a lot! It didn't work immediately because of an error with count rows but it was just missing the "Test Needed" before the CountRows function. Adding that and it worked perfectly!
AddColumns( GroupBy( AddColumns( QualityLabDashboard,"SelectedTest",Concat(TestNeeded,Value&",") ), "SelectedTest","TestNeededList" ),"Test Needed",CountRows(TestNeededList))

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

Like (0)

Report

Hi @Anonymous ,

Yes, I forgot that parameter!🤣

Do you have any other problem?

If not, could you mark my answer as your solution?

Thanks!

Best regards,

Was this reply helpful? Yes No