Sign in with your Microsoft 365 account to view live SharePoint data and manage IT asset movements.
A complete solution for monitoring IT asset movements — Single or Bulk, IN or OUT — powered by Microsoft Forms, SharePoint, and Power Automate.
Log assets individually or upload an Excel template for batch processing. Supports New and Repaired unit conditions.
Track outbound assets with Pull Out Repair or New condition, routed to Department, Warehouse, Store, or Vendor.
Every IN entry generates a unique Asset ID like SH-042026-L-1001 with auto-incrementing sequence numbers.
Current on-hand inventory updates automatically — every OUT deducts from the total. Always accurate.
Fully automated flow handles routing, ID generation, Teams notifications, and SharePoint logging.
Automatic email confirmations sent after every submission. Teams channel notifications for bulk entries.
| Asset ID | Entry Type | Movement Type | Movement Date | Location | Department | Store Name | Recipient | Asset Type | Brand/Manufacturer | Model | Serial No. | Vendor | PO Invoice No. | Condition | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||||||
| Segment | Value | Description | Example |
|---|---|---|---|
| Company | SH | Shakey's prefix — fixed | SH |
| Date | MMYYYY | Month & year the asset was logged IN | 042026 |
| Device | L / M / D / K | First letter of asset type | L |
| Sequence | 1001+ | Starts at 1001, auto-increments per entry | 1001, 1002… |
User selects Single or Bulk, then IN or OUT. Single entries fill out asset details; Bulk entries upload an Excel template.
Flow fires on form submission, reads the movement type, retrieves respondent details, and branches into the correct condition.
For every IN entry, a unique ID is composed — SH + date + device letter + auto-increment — and written to SharePoint.
All asset details logged in AssetMovementLiness. OUT entries flag the record so on-hand count is deducted.
Email confirmations go to the recipient. Bulk entries post a message to the Teams channel.
New form response submitted
Respondent info & answers retrieved
Single vs Bulk · IN vs OUT
Asset ID created for IN entries
Record written to SharePoint list
Email & Teams message sent