cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Posfog
Level: Powered On

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?)

Example.PNG 

Any advise or help would be appreciated as always.

 

Regards

P

3 REPLIES 3
eka24
Level 10

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

Posfog
Level: Powered On

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

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

Posfog
Level: Powered On

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

 

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

 

Regards

 

 

Screenshot 2020-02-16 at 10.01.00.png

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,347)