AYE CHAN OO - IT Executive

Built with Microsoft Power Apps Managing construction and engineering projects efficiently requires timely updates and seamless collaboration. To address this need, the Field Mobile App was developed using Microsoft Power Apps. This app empowers site engineers to update project statuses on the go while ensuring accuracy and accountability. Why the Field Mobile App? The app streamlines the process of tracking project progress and managing site activity photos, which are automatically stored in SharePoint folders. It is designed to keep information up-to-date in real time while minimizing manual errors. 1. Login Screen The app automatically recognizes users logged into their company account on Power Apps, eliminating the need for a separate login process. 2. View Active Sites The second screen displays a list of today’s active sites, with data sourced from Excel files on OneDrive. On-Site Updates Only: Engineers can only edit sites within a 5 km radius of their curren...

Managing IT assets efficiently is a critical task for any organization, ensuring accountability, transparency, and streamlined operations. To address this need, I developed an IT Asset Management System using Power Apps. This system is designed to simplify IT asset tracking and create a seamless experience for both administrators and users.   Key Features of the IT Asset Management System   1. Role-Based Access Control Login Page : The system begins with a login page where users are assigned one of two roles: Admin : Full access to manage and track all IT assets and accessories. Normal User : Limited access to view only the assets issued to them by the IT department. This role-based access ensures security and provides tailored functionalities based on the user’s role. 2. Comprehensive Dashboard Admin Dashboard : Displays an overview of all IT assets, including issued items and current stock levels. Admins can monitor real-time updates and maintain inventory efficiently. User...

In today’s fast-paced workplace, a reliable and efficient Helpdesk system is essential for resolving issues quickly and maintaining smooth operations. To address this need, I built a Helpdesk Ticket System using Power Apps, designed to provide an intuitive experience for both users and administrators. This application includes three primary pages: Login, Dashboard, and Create Ticket. 1. Login Page The system begins with a login page offering two roles: • Login as User • Login as Admin By selecting their role, users are directed to the corresponding dashboard with features tailored to their needs. 2. Dashboard The second page is the Dashboard, which offers different functionalities based on the user’s role: For Admins: Admins have access to a comprehensive overview of all tickets submitted by users. The dashboard categorizes tickets into three statuses: • Not Started • In Progress • Complete Admins can view the total count of tickets for each status, mak...

The Attendance System I built using Power Apps is designed to simplify and enhance the tracking of employee attendance for both office staff and site engineers. This app features three distinct pages, each serving a critical function in the workflow: 1. Login Screen The system automatically logs in users through their Microsoft Office account , eliminating the need for manual credential input. This seamless integration ensures ease of access and links attendance records directly to the respective user, maintaining accuracy and accountability. 2. Adding Records The second page is the core of the app, where employees can log their attendance. Users can select from three status options: Arrive Exit On the Way Work from Home Additionally, they can specify their location by choosing Office or Site . For those selecting "Site," a Site ID field is required for precise tracking. ...

This guide explains how to create multiple folders using Excel and the CONCAT function to automate the process with a batch file. By following these steps, the ' md '  (make directory) command can be combined with folder names from Excel for efficient folder creation. 1) Prepare Folder Names in Excel Enter the folder names in Column A . In Column B , use the CONCAT function to combine the ' md ' command with the folder names from Column A.         2) Copy and Save as a Batch File After the ' md ' commands are generated in Column B , copy the entire Column B . Open Notepad or any text editor and paste the copied commands. Save the file as CreateFolders.bat . Ensure the file is saved with the .bat extension by selecting All Files in the "Save as type" dropdown.              3)  Run the Batch File Navigate to the folder where the batch file ( CreateFolders.bat ) was saved. Double-click the batch fil...

When working with Excel, especially with large datasets, the ability to efficiently find and retrieve data is crucial. Two common lookup tools are VLOOKUP and INDEX-MATCH . While both can achieve similar results, they differ significantly in terms of functionality, flexibility, and performance. Let's break down the key differences to help you choose the right one for your tasks. Feature VLOOKUP INDEX-MATCH Basic Function Searches for a value in the first column and returns a value in the same row from another column. Uses the combination of INDEX (returns a value from a specific row and column) and MATCH (finds the position of a value in a range). Syntax =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) =INDEX(range, MATCH(lookup_value, lookup_range, [match_type])) Direction of Lookup Left to right only. Flexible: left to right, right to left, or vertical. Column Inde...

For connecting to external devices, you can use the Win + K shortcut to open the "Connect" pane. However, if you often forget this key combination, you can create a more accessible shortcut to open the device discovery settings directly. 1) Create a New Shortcut Right-click on your Desktop. Select New > Shortcut . 2) Type the location of the item      % windir%\explorer.exe ms-settings-connectabledevices:devicediscovery 3) Name the Shortcut 4) Customize the Shortcut Icon (Optional) Right-click on the newly created shortcut and choose Properties. Click on the Shortcut tab and then click Change Icon. Select an icon that suits your preference or browse for a custom one. Now, you can double-click the shortcut on your desktop to quickly access the "Connect to a Wireless Display" feature.