SharePoint(?) Approval software to sql?

janhoedt
janhoedt used Ask the Experts™
on
Hi,

I have a sql database in which I have at table with users and their specific packaging request,
 f.e. User01, date, requestforfirefox  version 65, currentversioncompany is 60, topackage yes, status

The status can be new, packaging etc but also approved or not approved (f.e. Firefox 65 does not start)

Specifically the approved or not approved part,I d like to have a web interface, SharePoint(?)

So the Sharepoint(?) would show only the requests of the user. He could then click ok/nok and if not ok mention why not ok.
This would write in the table of the database.

How to approach.
Please advise.
J
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Hi janhoedt,

I know you are asking question very specific to SharePoint but we have recently deployed a PowerApps solution which handles complex Approval workflow for our customer.

If your customers are already having an Office license, you might want to explore PowerApps for this situation.

Regards,
Chinmay.

Author

Commented:
Please clarify how Powerapps could help here then. Is there a blog which explains a similar scenario?
Chief Technology Ninja
Distinguished Expert 2018
Commented:
PowerApps let you build a low code app that your users can use (assuming the users are part of the organization), All you need to do is connect to the SQL database and you are good to go.

Here is a getting started guide: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase

Once you have connected the datasource, it will immediately create a basic CRUD app for you. You can then modify it OR create one from scratch to fit your needs.

PS: If you want to keep it short, you can instead try to connect with an excel file stored in a SharePoint site to get the idea how PowerApps work.

Regards,
Chinmay.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Shaun VermaakSenior Consultant
Awarded 2017
Distinguished Expert 2018

Commented:
Why SharePoint? A very basic .NET page can do this. Write or get someone to write you an MVC page for this table.
You can probably get someone on Freelancer to write it for $20-50 once off. PowerApps and SharePoint is a recurring fee

If you really want to use SharePoint rather create the table as a list in SharePoint directly

Author

Commented:
Because we have SharePoint and we do not have any .net guy or budget to hire one to make a .net page or/and maintain it.

>rather create the table as a list in SharePoint directly

No clue, there is a SharePoint guy, but he hasn't time right now so wanted to figure out myself but have no SharePoint knowledge
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
If you already have SharePoint just create the list and directly connect it to a PowerApps. Depending upon the  license you have, it might not cost you anything extra.
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
If you need help with that I am more than happy to do it via a live session.

Author

Commented:
Please give an example or blog where this is shown.
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Hi J,

I was planning to share a video showing you the exact steps but my current commitments are keeping me occupied.
For now, please refer to this link for the steps: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/app-from-sharepoint

Let me know if you run into a roadblock.

Regards,
Chinmay.

Author

Commented:
Thanks, but I do not want to make an app for a phone alone. Target audience is mainly W10 users.
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Hi J,

You can select a different layout when you start. The process will remain the same.

Regards,
Chinmay.

Author

Commented:
So it can also be used for w10 then? Where is such a power app hosted, how do I create a SharePoint list and link it to sql, can the power app be ad integrated so I can catch the user, can the power app execute powershell so I can uploaded a file then query the extension etc?
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Wew...

1. So it can also be used for w10 then? - Yes
2. Where is such a power app hosted? - In Microsoft Azure Cloud, linked to your O365 subscription
3. How do I create a SharePoint list? - Check : https://support.office.com/en-us/article/Create-a-list-in-SharePoint-0D397414-D95F-41EB-ADDD-5E6EFF41B083
4.and link it to sql, (You will have to migrate data from SQL to SharePoint)
5. can the power app be ad integrated so I can catch the user - It is by default designed in that way. You can check current user with User() function.
6. can the power app execute powershell so I can uploaded a file then query the extension etc? - No

Author

Commented:
So I guess then it is no option for me after all.
>You will have to migrate data from SQL to SharePoint
Not an option. The data can be linked to sql, not migrated. The sql is local, not on Azure.
Also I need to query sql when entering a user request. The user input has to be validated to sql then inserted into sql. The user needs to be able to upload one or multiple files (software, MB to GB)
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
It is supported to query On Premise SQL but that will require Gateway configuration https://blogs.msdn.microsoft.com/suvidha/2017/01/03/powerapps-with-sql-server-on-premises-using-the-gateway/

The screens might differ a bit but process remains the same.

You can query data with PowerApps but uploading a file in GBs - I won't recommend that with PowerApps.

Author

Commented:
Gateway is no option for me
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
In that case you will have to engage in to some kind of development. What do you choose will depend on your complete business requirements.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial