PowerApp Build

(0) Share

Report

Posted on by AliciaDG

Hi,

I have been trying unsuccessfully to build an APP where i pull the following data

I have an excel table already set up.

Trying to get an overview so that if a person picks a certain location it tallies up all the data of how many people where there on a specific date.

i want it to be two fold a generic view of total but also if i want to drill down more it will show me the specifics of that location.

can someone point me in the right direction?

Some of the fields i have are:

Date:

Which location are you from

How many adults

How many kids

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

rimatos Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AliciaDG ,

You can make something similar to this:

In here I'm using a gallery to display my data from the Excel file, and use a Dropdown box to select which city I want to filter from. The filter I use is the one bellow:

If(!IsBlank(Dropdown1),

Filter(Table1_1, Location in Dropdown1.Selected.Location ),Table1_1)

It will only filter by location if there is any selected from the dropdown.

Hope this helps!

Regards,

Ricardo
AliciaDG 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Ricardo, this has definetly pointed me in the right direction.

couple more questions in the image you have at the bottom is that set out as a table that displays the adults etc. or is that a gallery as well?

I am not sure what i have done but it doesnt seem to pull the data

Hoping you can help me one step further.

is there a way to connect the date so that when you pick the date and the location it pulls the data i want ie. adult and kids numbers.

My other question if i pulled that data to another page could it work out a tally for me of how many adults and kids attended one session?

Sorry i am getting very confused with all the different youtube clips i am watching 🙂

Thank you
rimatos Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
no problem @AliciaDG !

The image in bellow is a Table that I inserted into the canvas app, and the table is extracting data from the Excel file.

You can add the excel file as a data source either from the Excel connector (if it is stored locally on your computer), or with the OneDrive connector (to access a file that is stored online). If ou are pulling from oneDrive take into account it may take a little while for the data to properly sync

As for the other questions:

is there a way to connect the date so that when you pick the date and the location it pulls the data i want ie. adult and kids numbers.

You would need to perform some changes to the formula but it should be possible, you only need to compare the data that was selected and add it to the formula to compare to the value that is present in the excel file

My other question if i pulled that data to another page could it work out a tally for me of how many adults and kids attended one session?

Yes, you would need to extract that information and store it into a variable using the "Set" function. then you would display the value of the function.

Regards,

Ricardo
AliciaDG 93 on at

Like
a
(0)

Report
Copy link

Link copied!

i have entered the data as suggested but i keep getting errors so not sure what i have done wrong.

the data on the table just wont connect
rimatos Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
In the screenshots it throws some errors on the columns. What do they say?

Additionally, kindly show me the following:

Data source list (showing which is the connection to your table)

Data Table fields

Data Source

Items formula

Selected fields

Regards,

Ricardo
AliciaDG 93 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @rimatos,

Thanks for your response, see below

Here is the data source the item formula i am adding it to the data table section

Thanks

Ali