What is our primary use case?
The one that we currently have is only to SharePoint Online as we want to be able to have analysts be able to maintain data, and we want a graphical user interface, a GUI front end, to do that. Especially if it's interfaced with PowerBI, it allows analysts to have a research tool to identify what data needs to be updated right there, and to then be able to do that through PowerApps is a huge benefit. Right now, we're only able to write back to SharePoint Online.
How has it helped my organization?
Right now, it's only write-back to a SharePoint Online list, however, I have proof of concepts. I've got a business case that I'm currently trying to get pushed through. I've got other services within our organization that I need to get buy-in from so that we can get this business case approved and get the funding.
What is most valuable?
The write-back capability right now is just SharePoint Online, however, hopefully, we'll get the funding and subscriptions so that we can get write-back to our SQL server database. Of course, this is for our analysts within business architecture so that they can maintain the metadata, the relationships, and the mappings. Those are the biggest things that we need to have analysts able to do - the research, analysis to identify what data needs to be updated for those relationships and giving them a front end, a form to go in and edit, either create rows or modify existing, whatever needs to be done to the table.
What needs improvement?
We're one of the administrations within a governmental organization and I wish that they would make it and just provide it to those environments that are still on-premise for their relational databases, which we are. We're stuck on this on-premise environment, however, we don't have the premium connectors subscriptions for those. It's something we require.
As far as dealing with SharePoint, it'll allow you to ha manage up to 2000 rows, however, performance-wise, they're recommending that you just keep it at the default of 500 rows. Beyond that though, I don't know too much about its limitations. Having to do export and import from SharePoint Online and then in the SQL server, the solution is obviously there, if you can get the premium connection.
I'd much rather have the gallery set in a tablet or a normal computer, more of a landscape setting than what you would think you would see for a cell phone.
For how long have I used the solution?
We just started pursuing the solution with our write-back capability. We have not used it for more than three months. We've actually put a proof of concept together.
What do I think about the stability of the solution?
The solution works great and is stable. My obstacle is being able to demonstrate it and show its value to other leaders within the organization. I don't have issues with it crashing or freezing, for example.
What do I think about the scalability of the solution?
While we're still in the early days and need to develop it more, I'll be asking for 30 subscriptions initially. Within business architecture here, we're probably going to be somewhere between 10 to 15 analysts. Right now, we may only have ten as we are still building the business case.
It's unlimited where you can implement this. The scalability just depends. With the continued support within an in-house setup, you can make it what you want. It's my understanding that the scalability is really unlimited.
How are customer service and support?
We have an office within OIT and they have office hours. They've got a site, however, it's specifically for PowerBI. I don't know that there has been a whole lot of movement to get support for PowerApps, maybe since the value hasn't been realized we haven't really explored support options.
If more people saw how you could utilize PowerApps integrated with PowerBI to maintain data, we might have more questions and need more support.
BISL is the name of the support group we use. They have weekly meetings and office hours and are more focused on PowerBI. They've got a contract with Microsoft personnel that support this BISL team and specifically PowerBI. I don't know if they're going to expand that level of support and also include PowerBI. I would hope so.
Which solution did I use previously and why did I switch?
We used asp.net. The main platform we are using has asp.net, Cascading Style Sheets, CSS, Hypertext Markup Language, HTML5, jQuery, and JavaScript Library. It's a high code solution. Having to put an IIS web and app server and develop all this and HTML and C# and all these other languages that you would end up having to learn, it's a huge learning curve compared to putting something together in PowerApps. The learning curve for PowerApps for whatever you're trying to do is going to be under two weeks, whereas trying to learn ASP.net, that environment and all the other suite of stuff that you have to have and get resources too and all that, you're talking months. There are a lot of costs involved when it's so high code, and a lot of time. Using PowerApps would save time and money. There's also the risk that if the person you assign a task to goes away, you lose all of their work or cannot continue it.
How was the initial setup?
There's a learning curve with any new tool, so it's going to be somewhere between a three and a four out of five in terms of ease of setup. It just depends on the person's experience and working with these types of tools, as to how well they understand and are able to work through that.
Once you have a concept of what to do, I'd say it takes less than two weeks to implement. With that initial building out of your very first PowerApps set of forms to accomplish what you're trying to do, you're going to tweak and enhance in the end. I just put this filter or search capability and sort capability on a couple of columns. Implementing new features and adding additional buttons, et cetera, will be something you are going to be doing along the way. You're going to continue to enhance it when you discover new capabilities you want to implement. It's a work in progress to roll it out and it's continual. That said, for the initial rough draft of something, from concept to actually putting it together, it's going to be just a week to maybe two weeks to do.
There is a learning curve for the initial cost of doing it. That said, I would definitely consider this a low-code job. It's definitely not high code. There's low to mid-level coding involved.
We're very limited in terms of users for deployment and maintenance. Staff within my office that would actually develop the PowerApps forms and implement and train up the other analysts are only going to be somewhere between three and four. They are program analysts themselves. They aren't IT.
What about the implementation team?
We handled the initial setup ourselves in-house. We didn't use any outside assistance.
What was our ROI?
We have not yet witnessed any ROI. It is early days. Not until we're really up and running with it will we be able to look at that aspect.
That said, if I were to compare it to other solutions, I'd rate the potential for ROI five out of five. The workload and what you save on manpower will likely be impressive.
What's my experience with pricing, setup cost, and licensing?
We're a federal entity, so we've got a government rate, and this is per user, which is unlimited apps for PowerApps.
Typically, it's $20 per user, per month, commercial. For the government, on a per user basis, what we were looking at is $11.23 per month.
I'd rate the pricing five out of five in terms of affordability. It's way cheaper than the commercial price. That said, I know if that's just an introductory price to get you into it. Then they're going to boost the price up. It won't stay at $11.23.
I'm not aware of any other costs above and beyond the licensing.
What other advice do I have?
We are a customer and end-user.
We're likely using the latest version. We just started using the product a few months ago and then we likely also have the IT team keeping everything up to date.
I'd advise new users to not be in an on-premise environment; be in the Azure Government Cloud.
I'd rate the solution ten out of ten.
If you're looking for a GUI front end to maintain your data, that interfaces with PowerBI, this has to be up there in terms of best options. And the learning curve is low. It is very compatible with whatever you're doing in the Power Platform environment.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.