I'm hoping to get some high-level help: We would like to build a self-service portal where employees can make and manage requests like vacation requests, absence reports, travel requests, etc. Requests would be routed to supervisors and/or other departments according to business rules. Supervisors would see only the requests from their own employees which they would approve or decline. Backoffice users would perform further processing of requests (for example, purchase plane tickets on another platform and then update the request with the details in the service portal). We would like to integrate with our HR and Finance systems through REST APIs, csv file import/export and/or direct SQL connections.
Some requests would be simple, single record forms, while others would span multiple tables with parent-child relationships. Some forms will display data from backend systems, for example, a vacation request form would show the number of vacation days remaining in the employee’s bank. We would require a feature-rich interface, with cascading drop downs, show/hide fields based on rules, etc.
We are considering two platforms for this project: Service Now and the Microsoft Power Platform. Service Now does everything this project requires, but we are already firmly implanted in the Microsoft ecosystem so it would make more sense to go this way. In terms of the Microsoft solution, from what I understand, we have three options:
Sharepoint Lists
PowerApps / Common Data Service
Dynamics 365
Thanks, @timl , I'm still struggling with the idea of using canvas apps in a browser. Yesterday I was trying to do a simple app for browser desktop, one screen which lists all the records in a datatable control and another screen that shows the details of the record. The datatable lacks basic features of a similar control, for example sorting. I also couldn't figure out how to put Navigate on the selected item so that i could send the user to the detail screen. This is straightforward in the gallery control but not in data table (but the gallery controls are clearly for mobile devices, doesn't make sense for browser). I ended up using a Sharepoint list instead of the Powerapp.
To create web forms that are designed for desktops, we would still use the canvas app designer.
As you say, these apps are by default targeted at phone and tablet devices. What we can do however, is to increase the canvas size of an app through the settings. We can then choose a smaller font size for the controls, and that will result in an app that renders much better on a desktop computer.
Thanks, @timl for your detailed reply. One thing I'm having trouble wrapping my head around: If we were to go with the PowerApps CDS solution, what would be the tool for creating web forms for requestors ? For example, if I wanted to create a web form for a vacation request that would be used exclusively by people on desktops with browsers. The PowerApps canvas apps are mobile-centric... you can run them in a browser but it just looks like a workaround to me. The model apps are more the look and feel I would expect, but they don't seem to be designed to build front end forms with. Hope that makes sense.
It's great that you're considering the Power Platform. There are lots of people here that would be happy to help you.
To answer some of your questions...
One point about SharePoint is that there is less support for delegable queries. This makes it more difficult to return accurate data when a SharePoint list contains lots of records, typically above 2000. If you search these forums for the word 'delegation', you can find out more.
Hopefully, that answers most of your questions. Feel free to post back if you need any further clarification.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,083
Most Valuable Professional