web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Inventory management app
Power Apps
Answered

Inventory management app

(0) ShareShare
ReportReport
Posted on by 71

Hello all,

I would need some help please. I'm trying to create an inventory management app. I'm stuck with building the part for adding new inventory on different locations. 

I have a few warehouse locations, which have different number of printers - I need the vendor, model, serial number and status information of each printer. I would like to build the app the way that I could enter the number of printers for the location, then the app would open up a form with that many empty entries to fill in. All of the data could be stored either on sharepoint or in Excel. Maybe it would be less messy with an Excel file instead of SP (I assume every printer would be a SP list by itself - resulting in a huge number of lists...). Thanks for any advice.

 

BR, Dean

Categories:
  • Verified answer
    v-zhoqian-msft Profile Picture
    Microsoft Employee on at

    Hi, @MrC00per 

     

    According to your description, it may not be necessary to create a list for each printer. It seems that there should be many records in a list, and each record is a printer. The list has vendor, model, serial number, status information and location fields. Then the gallery in the app can be filtered according to the location.

     

     

     

    Best Regards,

    Habsburg Qian

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • MrC00per Profile Picture
    71 on at

    Thank you. I managed it with one Excel file with multiple sheets containing tables for each equipment (printers are only one of them). Have now the overview of all the Excel data in a gallery. Now I would like to build a form to add equipment to this inventory - I'm looking for a way to enter the number of ie. Computers I want to add and the form would open with that number of predefined fieldsets to enter all the data (pc name, model, year...). One of the fields in each fieldset would be preset with item name and number (Computer 1, Computer 2...) all the other fields should be empty for the user to enter the information. Note that the number of items is a variable (some places will have 3, others will have 7 computers...). Hope I'm not askong too much. Thank you in advance.

     

    BR, Dean

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard