Pengembangan Sistem Otomatisasi Pengelolaan Data Excel Berbasis Microsoft Power Apps
Abstract
Transformasi digital menjadi kebutuhan penting suatu pekerjaan untuk meningkatkan efisiensi operasional, namun sering terkendala oleh kesenjangan digital sumber daya manusia dan ketergantungan pada sistem manual berbasis Excel. Penelitian ini dilakukan untuk mengevaluasi implementasi sistem Enterprise Resource Planning (ERP) berbasis Low-Code Development Platform (LCDP) sebagai solusi digitalisasi proses pelaporan dan otomatisasi data Excel. Studi ini dikembangkan menggunakan ekosistem Microsoft Power Platform, khususnya Power Apps dan Power Automate, yang terintegrasi dengan SharePoint Lists sebagai basis data dan OneDrive sebagai penyimpanan berbasis cloud. Proses pengembangan dilakukan tanpa memerlukan keahlian pemrograman mendalam, sehingga memungkinkan partisipasi langsung dari pengguna non-teknis atau yang disebut citizen developers. Melalui pendekatan ini, sistem yang dibangun tidak hanya menekan biaya dan mempercepat waktu implementasi, tetapi juga mampu mengotomatisasi alur kerja pelaporan secara efektif. Hasil pengujian menunjukkan peningkatan efisiensi operasional serta kemudahan akses lintas perangkat. Penelitian ini menyimpulkan bahwa penerapan LCDP dalam pengembangan ERP merupakan metode efektif untuk mendukung transformasi digital pekerjaan, khususnya dalam mengatasi tantangan integrasi data dan meningkatkan produktivitas organisasi secara keseluruhan.
Downloads
References
Berardinelli, L., Colantoni, A., Ruscio, D. D., Khorram, F., Indamutsa, A., Ibrahimi, I., Pierantonio, A., & Sahay, A. (2020). Low-Code Engineering Repository Architecture Specification (Deliverable No. D4.1). University of L’Aquila, Lowcomote Project. https://www.lowcomote.eu/
Boppana, V. R. (2025). Automation Using Power Platform. SSRN Electronic Journal. https://doi.org/10.2139/ssrn.5134991
Kakolu, S., & Faheem, M. A. (2023). Revolutionizing industries through digitization: The strategic importance of mobile application automation. International Journal of Science and Research Archive, 8(1), 973–987. https://doi.org/10.30574/ijsra.2023.8.1.0276
Khaidir K.N., L., Nuragustin, N., Aldina, S. A. F., Noviyana, N., & Nurbaiti, N. (2024). Transformasi Bisnis di Era Digital: Peran Teknologi Internet dalam Mengembangkan E-Bisnis. Musytari : Jurnal Manajemen, Akuntansi, dan Ekonomi, Vol. 11 No. 6 (2024): Musytari : Neraca Manajemen, Akuntansi, dan Ekonomi, 130–140. https://doi.org/10.8734/musytari.v11i6.8141
Martinez, E., & Pfister, L. (2023). Benefits and limitations of using low-code development to support digitalization in the construction industry. Automation in Construction, 152, 104909. https://doi.org/10.1016/j.autcon.2023.104909
Microsoft. (2025a). Overview of Power Apps. What is Power Apps? https://learn.microsoft.com/en-us/power-apps/powerapps-overview
Microsoft. (2025b). Types of flows in Power Automate. What is Power Automate? https://learn.microsoft.com/en-us/power-automate/flow-types
Moon, H. (2020). Implementation of a Mobile Business Application Built in Microsoft Power Platform [Bachelor’s Thesis, Haaga-Helia University of Applied Sciences]. https://www.theseus.fi/handle/10024/339880
Murdiani, D., & Sobirin, M. (2022). PERBANDINGAN METODOLOGI WATERFALL DAN RAD (RAPID APPLICATION DEVELOPMENT) DALAM PENGEMBANGAN SISTEM INFORMASI. Jurnal Informatika Teknologi dan Sains, 4(4), 302–306. https://doi.org/10.51401/jinteks.v4i4.2008
Phalake, V., & Joshi, S. (2021). Optimized Low Code Platform for Application Development. International Journal of Contemporary Architecture, Vol. 8, No. 2. https://www.researchgate.net/publication/362519472_Optimized_Low_Code_Platform_for_Application_Development
Putri, I. A., & Munawaroh. (2025). Pemanfaatan Teknologi dalam Membangun Sumber Daya Manusia di Era Bisnis Digital: Mengetahui Tantangan dan Solusinya. Profit: Jurnal Manajemen, Bisnis dan Akuntansi, 4(1), 147–156. https://doi.org/10.58192/profit.v4i1.2967
Razak, S. F. A., Ernn, Y. P., Yussoff, F. I., Ali Bukar, U., & Yogarayan, S. (2024). Enhancing Business Efficiency through Low-Code/No-Code Technology Adoption: Insights from an Extended UTAUT Model. Journal of Human, Earth, and Future, 5(1), 85–99. https://doi.org/10.28991/HEF-2024-05-01-07
Utama, R. P., & Wardana, R. S. (2022). Utilization of Low Code Framework Tool for Knowledge Management in Well Service. Proceedings of the IATMI 2022 Conference. https://journal.iatmi.or.id/index.php/ojs/article/view/302/309
Copyright (c) 2025 Satriya Adhi Pradana
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Jurnal allows anyone to compose, correct, and do derivative works, even for commercial purposes, as long as they credit for the original work. This license is the freest. It is recommended for maximum distribution and use of licensed material.
The submitted paper is assumed not to contain any proprietary materials that are not protected by patent rights or patent applications; The responsibility for technical content and protection of proprietary materials rests with the authors and their organizations and not the responsibility of journal or its editorial staff. The primary (first/appropriate) author is responsible for ensuring that the article has been viewed and approved by all other authors. The author's responsibility is to obtain all necessary copyright waivers to use any copyrighted material in the manuscript before submission.
Jurnal Pendidikan, Sains dan Teknologi allows the author(s) to hold the copyright without restrictions and allow the author(s) to retain publishing rights without restrictions. Jurnal Pendidikan, Sains dan Teknologi CC-BY-SA or an equivalent license as the optimal license for the publication, distribution, use, and reuse of scholarly work. Jurnal Pendidikan, Sains dan Teknologi allows the author(s) to hold the copyright without restrictions and allow the author(s) to retain publishing rights without restrictions. Jurnal Pendidikan, Sains dan Teknologi CC-BY-SA or an equivalent license as the optimal license for the publication, distribution, use, and reuse of scholarly work.
In developing strategy and setting priorities Jurnal Pendidikan, Sains dan Teknologi recognize that free access is better than priced access, libre access is better than free access, and libre under CC-BY-SA or the equivalent is better than libre under more restrictive open licenses. We should achieve what we can when we can. We should not delay achieving free in order to achieve libre, and we should not stop with free when we can achieve libre.
Jurnal Pendidikan, Sains dan Teknologi is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
You are free to:
- Share a copy and redistribute the material in any medium or format
- Adapt a remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
