Answered

Displaying Poll Results in a Chart

(0) Share

Report

Posted on by edwardhorton

I have been creating a voting app on Power apps where people simply select out of the 5 options on a radio poll and the votes then go into a share point list. I now would like a screen within the app that shows the amount of votes each option has on a graph - once the have selected their options they will then be taken to this screen to show them the current standings.

Is this possible, and if so is anyone able to help?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @edwardhorton,

That should be possible by leveraging the column chart and group by function.

How does your SharePoint list look like - Is the radio poll linked to a Choice column or is it a text column?
edwardhorton 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for your reply.

It is very simple currently, the SharePoint list is just one text column.
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Ok thanks for the info @edwardhorton ! 😊

You could try the following:

(1) Add a Column Chart control to your Power App

(2) Use the following code in the Items property of the ColumnChart

//Group your records and create a column to display the count AddColumns( GroupBy( //Change LISTNAME and COLUMNNAME to the correct names LISTNAME, "COLUMNNAME", "GroupedRecords" ), "Count", CountRows(GroupedRecords) )

(3) (optional since it may be ok already), select the ColumnChart control, go to the property panel on the right and select 'Advanced'

The Series properties should be set to Count

Labels property should be set to your column name

Since Column Charts are more complex controls I will add some additional resources to help you get started:

Charts (Ms Docs)

Charts tutorial by Shane Young

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
edwardhorton 43 on at

Like
a
(0)

Report
Copy link

Link copied!

I have just added a column chart but when I click on it it does not have the items option in the drop down. In the tree view it gives me these options :
and when I then click on the ColumnChart2 bit, i get the items option in the dropdown however it does not let me type anything into the coding bar.
LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @edwardhorton,

ColumnChart2 should indeed have an Items property. Is there any error you are receiving when trying to type in the Items property? You could try to save & reopen the app in edit mode.

Note: the code should be added via the formula bar in the top header, not via the 'Properties' section of the right property panel.

I hope this helps!
edwardhorton 43 on at

Like
a
(0)

Report
Copy link

Link copied!

It has worked now, thank you for your help!!