Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Where do I start? PowerApp Building on a list

Good evening!  So here's my dilemma, pretty simple to some of you, but I'm stumped. 


I have a basic spreadsheet with the following tabs:



Specific Room Number in those locations (A, B, C, D,....etc)

Inventory Items:  A list of all the items that should be in an office/classroom

Condition (on a 1-5 scale)


So I want to combine all of this into a list, and build a PowerApp off of it.  A staff member would go into a location, select the location and go through each item on the "Inventory Items" and select the quanity of items, conditions, etc.


I know this seems simple, but I'm getting stumped.  Can someone direct me in the right starting direction?  

Community Support Team
Community Support Team

Re: Where do I start? PowerApp Building on a list

Hi @Gticket,


Then please get start from the aritcle below:

Generate an App from Excel Data

Keep a note for the controls used in the example. like Screen, Gallery, button, dropdown and others.

Then choose the proper one for your data.

Add screen control if necessary.

Then using functions such as Filter, Lookup, search to find the proper data, or records.

Use form controls to deal with single record viewing, editing or adding.

Check the control list if needed:

Controls and properties in PowerApps



Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Power Apps Super User Class of 2020

Check it out!


New Badges

Check it out!


Power Apps Community User Group Member Badge

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


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


Difinity Conference

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

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