CUSTOM HOME INVENTORY SERVICES HOW TO
CUSTOM HOME INVENTORY SERVICES SERIAL
CUSTOM HOME INVENTORY SERVICES UPDATE
CUSTOM HOME INVENTORY SERVICES SOFTWARE
CUSTOM HOME INVENTORY SERVICES CODE

You may notice that the Item Image is not included this is because I will be adding this later in the series when I start using the phone. On all screens, cancel, save, and delete actions return to the previous screen.

If the user creates or edits an item, they use the same screen they can also create new Item Types and Manufacturers from this screen. When a user views an item, they can delete it or edit it. From the Items screen, a user can view or create a new Item. Here, users can search, sort, and scroll through items in the system. The user interface below begins with the Items screen. Additionally, the mockup below does not include the Item Image library, as I will cover it in a separate post. As data gets added to the system, I will do this because I may discover challenges and new ideas.

Below is the resulting data model summary.įor the user interface, I will begin with the phone app and develop the administration app later. Due to requirements in the Microsoft Dataverse, I will need to add a Name column to the Image table I will want to handle this name’s generation when I implement the Item Images part of the application. Using the database model above, I can create custom tables for the system in the Microsoft Dataverse. Master Bedroom, Living Room, etc.), and an ItemType (ex. Each Item will also have a lookup to a Manufacturer (ex. Each Item record may have 0 or more Image records. There is an Item table that contains most of the data. Using the requirements above, I can derive a simple database model.

AI – While this is a tall order, it would be neat to take a picture of an item and have it recognized what kind of item it is, perhaps even determine its Item Type.

Photo of Receipt – item would be a nice feature to include a picture of the receipt for proof-of-purchase and returns.

CUSTOM HOME INVENTORY SERVICES SERIAL

This could be for serial numbers, model numbers, or even UPC for the entire item.

CUSTOM HOME INVENTORY SERVICES CODE

Bar code Scanner – for items with a bar code, it would be helpful to scan these automatically.

In addition to the requirements, there are some future enhancements or “nice to haves” that I can investigate adding to the system later, for example:

The system should allow Admins to export the inventory.

CUSTOM HOME INVENTORY SERVICES UPDATE

Admin App should provide the ability to create, update and delete Manufacturers.

Admin App should provide the ability to create, update and delete Locations.

Admin App should provide the ability to create, update and delete Item Types.

Phone and Admin Apps should provide the ability to create Locations.

Columns: Name, Support URL, and Support Phone.

Phone and Admin Apps should provide the ability to create Manufacturers.

Phone and Admin Apps should provide the ability to create Item Types.

Users should be able to add an Item Image.

Location will look up from the Locations table.

The manufacturer will look up from the Manufacturers table.

Item Type will look up from the Item Types table.

Required columns: Name, Model Number, Item Type, Manufacturer, Location, and Image.

Columns: Name, Description, Item Type, Manufacturer, Serial Number, Model Number, Location, Date Purchased, and Approx.

Phone and Admin Apps should provide the ability to create, update and delete Items.

The system should include a phone app for data entry and a web interface for administration.

The requirements of the initial system are straight forward: I set out designing my home inventory system using the Power Platform with these things in mind. I want to use my phone and its many capabilities for data entry instead of walking back-and-forth to the computer. “having a list or a visual reminder of your belongings can make a big difference in how much your homeowners’ insurance will pay, and thus how well you’ll recover financially.”Īt the time, I purchased Quicken Home Inventory Manager, which was adequate at the time however, advancements in technology have made it obsolete. I wondered what would happen if I were robbed, had a fire, or some other disaster and found myself wondering if my insurance would cover all my technical assets? According to Consumer Reports: Several years ago, I started considering the number and value of technical assets I had obtained over the years.

CUSTOM HOME INVENTORY SERVICES SOFTWARE

You have knowledge of software development fundamentals.

You have a Power Apps tenant with administrative privileges.

This post concludes with a review of the User Interface mockup. It takes time to explain the database model and how it translates into tables in the Microsoft Dataverse. It then takes the reader over the requirements of the system, including potential future enhancements. It begins by explaining why we would want to create a home inventory system. Readers should know software development fundamentals.

CUSTOM HOME INVENTORY SERVICES HOW TO

This blog series is for anyone trying to learn how to use the Power Platform.

Custom home inventory services