IT Asset Inventory Verification System

Question

I am attempting to build a solution to take the burden off of conducting annual inventories in my organization. We have ~500 assets that must be tracked by serial number across our facility. We have a master inventory list and now have a barcode reader. The reader will spit out a CSV file of all scanned items' serial numbers. The goal is to somehow upload this and utilize SharePoint to compare the two lists and show us what serial numbers have not been scanned yet, so we know if we missed a device or have one potentially missing. We cannot bring any wireless devices such as cell phones into the area so that eliminates the Barcode Power App template.

The most I have been able to do is to get an excel spreadsheet that turns cells red or green based on duplicate values but I am trying to build this into a SharePoint list or Power Automate somehow. Any help would be appreciated.

Answer 1

Hi @Shawn Kesinger,

Thank you for posting in this community.

You can upload your master inventory list and the scanned CSV file into SharePoint as two lists. All we have to do is determine which ones have not been scanned by comparing the items' serial numbers in the two lists.

1.You can choose to create the list via excel sheet or CSV files. In this test I am creating two list tables Master Inventory List and Scan List for example.

2.You can refer to this article to use Power Automate flow to compare the differences between the two lists: Compare two SharePoint Lists.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.