janhoedt
asked on
SharePoint(?) Approval software to sql?
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
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
ASKER
Please clarify how Powerapps could help here then. Is there a blog which explains a similar scenario?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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
>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
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.
If you need help with that I am more than happy to do it via a live session.
ASKER
Please give an example or blog where this is shown.
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/pow erapps/mak er/canvas- apps/app-f rom-sharep oint
Let me know if you run into a roadblock.
Regards,
Chinmay.
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
Let me know if you run into a roadblock.
Regards,
Chinmay.
ASKER
Thanks, but I do not want to make an app for a phone alone. Target audience is mainly W10 users.
Hi J,
You can select a different layout when you start. The process will remain the same.
Regards,
Chinmay.
You can select a different layout when you start. The process will remain the same.
Regards,
Chinmay.
ASKER
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?
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/art icle/Creat e-a-list-i n-SharePoi nt-0D39741 4-D95F-41E B-ADDD-5E6 EFF41B083
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
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
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
ASKER
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)
>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)
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.
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.
ASKER
Gateway is no option for me
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.
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.