SOLVED

Automate SharePoint 2016 Custom Form

%3CLINGO-SUB%20id%3D%22lingo-sub-356157%22%20slang%3D%22en-US%22%3EAutomate%20SharePoint%202016%20Custom%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356157%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20automate%20the%20approval%20of%20a%20HR%20related%20business%20process%20using%20SharePoint%202016%20but%20without%20using%20Infopath%20(As%20i%20am%20used%20to%20do).%3C%2FP%3E%3CP%3EThe%20process%20consists%20of%204%20levels%20of%20approval%20where%20approvers%20are%20dynamically%20assigned%20based%20on%20the%20submitting%20employee.%3C%2FP%3E%3CP%3EMoreover%2C%20the%20form%20includes%20information%20that%20should%20be%20retrieved%20from%20custom%20SQL%20data%20tables%3B%20and%20on%20approval%2C%20other%20data%20should%20be%20saved%20to%20SQL%20data%20tables%20too.%3C%2FP%3E%3CP%3EAny%20idea%20how%20this%20can%20be%20done%20using%20SharePoint%202016%20with%20Power%20Apps%2FFlow%3F%20I%20used%20to%20complete%20the%20above%20using%20SharePoint%202013%20and%20Infopath%20managed%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-356157%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356702%22%20slang%3D%22en-US%22%3ERe%3A%20Automate%20SharePoint%202016%20Custom%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356702%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F138334%22%20target%3D%22_blank%22%3E%40Federico%20Porceddu%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3ESince%20it%20should%20be%20reachable%20from%20the%20internet%2C%20PowerApps%20is%20no%20longer%20an%20option%20for%20me.%3C%2FP%3E%3CP%3ECan%20i%20still%20use%20SharePoint%202016%20to%20benefit%20from%20the%20tasks%20management%2C%20but%20instead%20of%20InfoPath%20forms%20maybe%20use%20ASP.net%20pages%20or%20web%20parts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356230%22%20slang%3D%22en-US%22%3ERe%3A%20Automate%20SharePoint%202016%20Custom%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356230%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F290662%22%20target%3D%22_blank%22%3E%40NewUser2020%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3Eyes%20you%20can%20user%20PowerApps%20with%20SharePoint%202016%2C%20obviously%20it%20must%20be%20reachable%20from%20the%20internet.%3C%2FP%3E%3CP%3EThere%20are%20also%20others%20requirements%3A%3C%2FP%3E%3COL%3E%3CLI%3EAccess%20to%20download%20and%20install%20the%20On-Premises%20data%20gateway%20on%20a%20server.%3C%2FLI%3E%3CLI%3EAccess%20to%20a%20SharePoint%202013%20or%202016%20environment.%26nbsp%3B%3C%2FLI%3E%3CLI%3EAlready%20have%20a%20subscription%20set%20up%20with%20PowerApps%20and%20Flow%3C%2FLI%3E%3C%2FOL%3E%3CP%3EHere%20you%20can%20find%20(quick%20goolge%20search)%20a%20really%20good%20article.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F35244.sharepoint-gateway-powerapps-and-flow.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2Fwiki%2Fcontents%2Farticles%2F35244.sharepoint-gateway-powerapps-and-flow.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAbout%20SQL%2C%20I%20would%20put%20it%20on%20Azure%2C%20but%20you%20can%20put%20already%20on%20premises%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FPowerApps-with-SQL-server-on-premises-Using-the-Gateway-Part-One%2Fba-p%2F18029%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FPowerApps-with-SQL-server-on-premises-Using-the-Gateway-Part-One%2Fba-p%2F18029%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EFederico%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

I need to automate the approval of a HR related business process using SharePoint 2016 but without using Infopath (As i am used to do).

The process consists of 4 levels of approval where approvers are dynamically assigned based on the submitting employee.

Moreover, the form includes information that should be retrieved from custom SQL data tables; and on approval, other data should be saved to SQL data tables too.

Any idea how this can be done using SharePoint 2016 with Power Apps/Flow? I used to complete the above using SharePoint 2013 and Infopath managed code.

 

Many thanks,

2 Replies
Highlighted
Solution

Hi @NewUser2020 ,

yes you can user PowerApps with SharePoint 2016, obviously it must be reachable from the internet.

There are also others requirements:

  1. Access to download and install the On-Premises data gateway on a server.
  2. Access to a SharePoint 2013 or 2016 environment. 
  3. Already have a subscription set up with PowerApps and Flow

Here you can find (quick goolge search) a really good article.

https://social.technet.microsoft.com/wiki/contents/articles/35244.sharepoint-gateway-powerapps-and-f...

 

About SQL, I would put it on Azure, but you can put already on premises https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/PowerApps-with-SQL-server-on-premises-U...

 

Cheers,

Federico 

Highlighted

Hi @Federico Porceddu ,

 

Thank you for your reply.

Since it should be reachable from the internet, PowerApps is no longer an option for me.

Can i still use SharePoint 2016 to benefit from the tasks management, but instead of InfoPath forms maybe use ASP.net pages or web parts?

 

Regards,