Setup Power Apps Integration with Sharepoint Server On-Premise (Infopath replacement)

InfoPath as we know it will no longer be used in next version of Sharepoint Server. In fact, since several years ago, Microsoft has announced this. But until now in version of Sharepoint 2019, Infopath service is still remain but with no longer any improvement features at all in Infopath.

Infopath itself is one of the best tools from Microsoft Sharepoint that has long been used by Sharepoint Developers to be able to make applications easier, faster and very user friendly in an interface.

Now Microsoft offers a new Technology that is Power Apps. Similar with Infopath, Power Apps also help users to design their application easily, quickly and user friendly. But it is not limited to Sharepoint or SQL Server data sources only, but can access other data sources as well like One Drive, Google Drive, Drop Box, and many more

Power Apps is a Cloud Centrix Application, where the application is in Microsoft Cloud, and until this article was published Power Apps cannot be installed on On Premises Environment.

Powers Apps can also intergrated with our Microsoft Sharepoint On Premises atau SQL Server On Premises.

Here are the steps for integrating Microsoft Sharepoint 2019 On Premise with Power Apps.

  1. Register an Power Apps account at https://make.powerapps.com
  2. Download Power Apps Studio and Power Apps On-Premises Data gateway
This image has an empty alt attribute; its file name is image-4.png

3. Install On-Premises Data Gateway on our Server Sharepoint 2019 On Premise

The steps are as follows:

  • Type your email addrress that you was registered at Power Apps portal.
  • Register a new gateway on this computer
  • Type Gateway Name, and Recovery Key
  • The gateway result configration we can see on Power Apps Portal.

3. Create a new SharePoint Connector and Connect to Gateway that we have been created.

  • Choose Connect Using on-premises data gateway dan type Username and Password is needed,
x 
SharePoint 
Microsoft 
SharePoint helps organizations share and collaborate with colleagues, partners, 
and customers. You can connect to SharePoint Online or to an on-premises 
SharePoint 2013 or 2016 farm using the On-Premises Data Gateway to manage 
documents and list items. 
How do you want to connect to your data? 
C) Connect directly (cloud-services) 
@Connect using on-premises data gateway O 
Authentication Type 
Windows 
Username 
Cancel 
Create
SharePoint 
Microsoft 
Windows 
Username 
Password * 
Choose a gateway 
Agusto 
If you don't see a gateway, or want a new one, you can install one 
*hic lic. 
Cancel 
x 
CD

4. Installation are done!!! 🙂 yippe. Now we able to use it on Power Apps to create our application

In Indonesia Version

InfoPath seperti yang kita ketahui tidak akan digunakan lagi di versi Sharepoint Server berikutnya.

Padahal, sejak beberapa tahun lalu, Microsoft sudah menyinggung hal ini. Namun hingga saat ini di versi Sharepoint 2019, layanan Infopath masih tetap ada namun tidak ada lagi peningkatan/pembaharuan fitur sama sekali di Infopath.

Infopath itu sendiri adalah salah satu tools terbaik dari Microsoft Sharepoint yang sudah lama dipakai oleh para Developer Sharepoint untuk bisa membuat aplikasi lebih mudah, cepat dan sangat user friendly secara interface.

Sekarang Microsoft menawarkan technology baru yaitu Power Apps. Sama dengan Infopath, Power Apps juga membantu user untuk mendesign aplikasi mereka dengan mudah, cepat dan user friendly. Tetapi tidak dibatasi hanya dengan data sources Sharepoint atau SQL Server saja, tetapi bisa mengakses datasource lainnya seperti One Drive, Google Drive, Drop Box, dll.

Power Apps ini juga adalah bagian dari Power Platform yang pernah saya jelaskan di article saya sebelumnya https://agustox21.wordpress.com/2021/01/20/microsoft-power-platform

Power Apps ini adalah aplikasi Cloud Centrix, dimana aplikasi ada di Microsoft Cloud dan sampai saat artikel ini dibuat Power Apps tidak bisa diinstall di On Premise Environment.

Power Apps juga bisa diintergrasikan dengan Microsoft Sharepoint 2019 On Premise atau SQL Server On Premise kita.

Berikut adalah langkah-langkah mengintergrasikan Microsoft Sharepoint 2019 On Premise dengan Power Apps.

  1. Membuat Akun Power Apps di https://make.powerapps.com/
  2. Download Power Apps Studio dan Power Apps On-Premises Data gateway

3. Install On-Premises Data Gateway di Server Mesin Sharepoint 2019 On Premise

Langkah-langkah sebagai berikut :

  • Masukkan alamat email Akun Power Apps / Azure yang ada
  • Register a new gateway on this computer
  • Masukkan Gateway Name, dan Key
  • Hasil gateway tersebut bisa kita lihat di Power Apps Portal

3. Buat Connector SharePoint dan Connect ke Gateway yang sudah kita buat

  • Plih Connect Using on-premises data gateway dan masukkan Username dan Password yang dibutuhkan
x 
SharePoint 
Microsoft 
SharePoint helps organizations share and collaborate with colleagues, partners, 
and customers. You can connect to SharePoint Online or to an on-premises 
SharePoint 2013 or 2016 farm using the On-Premises Data Gateway to manage 
documents and list items. 
How do you want to connect to your data? 
C) Connect directly (cloud-services) 
@Connect using on-premises data gateway O 
Authentication Type 
Windows 
Username 
Cancel 
Create
SharePoint 
Microsoft 
Windows 
Username 
Password * 
Choose a gateway 
Agusto 
If you don't see a gateway, or want a new one, you can install one 
*hic lic. 
Cancel 
x 
CD

4. Installasi sudah selesai dan kita sudah bisa menggunkan Power Apps untuk aplikasi yang kita inginkan.

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.