Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

PowerApp Chart pulling data from SharePoint but results based on two dropdown help

Hello All,

Been trying to sort this query out on my own via the normal routes but facing issues.


What i have already is a App thats collecting data and saving it to a large SharePoint list, which is working fine.

Now i am trying to create like a mini dash board that i can use to get data back from items save on the SP List in a form of a graph or table.


How i am trying to get it to work is by having two dropdowns (Date and Zone) then once i have selected these items then for the graph/table to populate.


Below is a pivot chart i created in excel using the same type of data to show what i am trying to create, but wouldn't require the pivot table. (hope that makes sense?)


Any advise or help would be appreciated as always.




Super User III
Super User III

I been watching that youtube video for 3 days now and only got a bad head from it :'(

Helper I
Helper I


Hi All,

I have manged to produce a graph showing zones and costs against them, but its showing multiple zones.

Think this is due to costs being entered on different dates.

What i want to know is it possible for the two drop downs to control the graph so if a certain date and zone are selected then the graph would show the information based on those two drop downs?


Ive added a screen shot below to show what i am currently getting





Screenshot 2020-02-16 at 10.01.00.png

Helpful resources


Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users


We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (26,072)