cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?)

Example.PNG 

Any advise or help would be appreciated as always.

 

Regards

P

3 REPLIES 3
Highlighted
Super User III
Super User III

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

Highlighted
Helper I
Helper I

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 :'(

Highlighted
Helper I
Helper I

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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,760)