How to make Absence Attendance mobile apps with feature GPS location in 2 days – Power Apps

There are 2 version languages available for this article.

Indonesia Version :

Ignite 2021 ini, saya tertarik dengan salah satu presentasi dan demo mengenai Power Apps.

Demo dari perusahaan itu dan ide mereka dimana membuat aplikasi-aplikasi kecil dalam membantu digitilasi dan automisasi perusahaan. Pada saat itu mereka juga menjelaskan berapa antusiasnya para user-user mereka menggunakan aplikasi itu dan mulai mengembangkan aplikasi-aplikasi lainnya untuk kebutuhan lainnya.

Dari situ saya berpikir, wah saya juga ingin mencoba membuatnya dan berpikir bahwa aplikasi yang cepat siap saji, cepat dalam development dan implementasi itu akan mempercepat produktifitas perusahaan itu sendiri.

Kebetulan saya juga akan membawakan webinar untuk tanggal 25 Maret 2021 mengenai “Leverage your Work from Home Level Now” maka mencoba membuatkan aplikasi menggunakan Power Apps tersebut, dengan data berita perusahan saya ambil dari internal Sharepoint Online dan penyimpanan data absen itu menggunakan excel file yang di taruh di onedrive microsoft office 365.

Berikut requirementnya:

Sebagai HRD dan Company

  • Applikasi yang mudah dibuat, tidak perlu ribet development dan implementasi
  • Dapat dengan mudah melakukan rekap Absen karena menggunakan Excel File
  • Bisa sharing kegiatan-kegiatan perusahan yang bisa dibaca oleh Karyawan
  • Aman, hanya bisa diakses oleh karyawan
  • Dapat memberikan Posisi (GPS) dimana karyawan berada. Itu dapat membantu bila ada informasi terkait Covid 19 di wilayah tersebut

Sebagi User / Employee

  • Dapat diakses mudah dan aman
  • UI yang simple dan informatif
  • Karyawan bisa mudah melihat history absen yang sudah di submit.
  • Karyawan bisa mengetahui berita seputar perusahaan.

Okay 🙂 Setelah requirement diatas maka mari kita persiapkan dan buat aplikasinya :

  1. Siapkan data source Events untuk berita-berita perusahan. Disini kita cukup menggunakan list dengan tipe calendar

2. Siapkan data source Excel, yang nantinya data absen akan disimpan kesana

Sheet1

Sheet 2, master data pada drop down menu nantinya.

3. Mari buat dengan Power Apps setelah point 1 dan 2 diatas sudah kita siapkan

Total screen yang akan kita buat adalah 6 (enam), yaitu :

  • Home Screen

Submit Attendance Click ini akan Navigate(EditAttendanceScreen,ScreenTransition.None)

My Attendance List ini akan Navigate(MyAttendanceScreen, ScreenTransition.Fade)

Company News ini akan Navigate(NewsListScreen, ScreenTransition.Fade)

  • NewsListScreen

  • MyAttendanceScreen
  • DetailAttendanceScreen
  • EditAttendanceScreen

Power Apps form sudah selesai, maka siap di publish dan share ke user-user yang di organisasi anda yang akan menggunakan aplikasi ini.

—————————————

English Version :

Past month ago, there was a Microsoft Event Ignite 2021. I was interested with one presentation and demo about the Power Apps.

That demo was about from one of company at Indonesia. They are have briliant idea to build small and simple application – application for their company to help the compay on digitalisation and automitation process. At that presentation, the speaker was also explained how enthusiastic their employee to use the application and began to develop other applications for other needed.

After that presentation i was thought, wow i am also want to try to build the application like that. The application with fast to serve, fast in to development and also implementation it will accelarate the productivity of the company itself.

25 March 2021, i am also have a webinar with title “Leverage your Work from Home Level Now” and i am also as speaker there. For that event, i tried to make an application on top Power Apps. With company news data that I take from internal Sharepoint Online and store the absent data using excel file that is placed on OneDrive Microsoft Office 365.

Here are the requirement detail as follow :

As Human Resources Department and Company

  • The application has to be simple. Easy to development and Implementation
  • Easy to do absense recap, because it using Excel Files.
  • Able to share company events to employee
  • Safe and Secure and only able to access by its employee.
  • Can provide Position (GPS) where employees are located. That can help if there is information related to Covid 19 in the area

As Employee

  • Application it is easy to used and secure
  • User Interface simpel and informatif
  • Employee with ease to see their absence history was submitted
  • Employee can read information about event around company.

Okay 🙂 Regarding the requirement above then we can prepare and start to build the application :

  1. Prepare the Events data source for company news. Here we just need to use a list with a calendar type

2. Prepare the Excel data source, which later the timesheet will be saved there

Sheet 1

Sheet 2

3. Let’s cook it after point 1 and 2 above we have prepared

The total screen that we will create is 6 (six), namely:

  • EditAttendanceScreen

All complete, so it’s ready to publish and share with users in your organization who will use this application.

Happy Sharepoint-ing

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.