Forum Discussion
JohnHollis
Jun 21, 2022Copper Contributor
How far can Power Automate go?
Hello All,
When I'm reading the solutions that Power Automate can solve they seem to be small problems but applied in large organisations so that the small efficiency applied on a huge scale is extremely beneficial to that firm. For my small business the effort of learning Power Apps and Power Automate wouldn't really benefit me for a small problem such as automatically sending an email when a task is complete.
Where it could be beneficial, if possible, would be to use it as my main software as the tech I have at the minute is very poor. As a Mortgage Adviser in the UK I'd like to use Forms (or any other app) to complete the Fact-Find / initial survey and for this to generate other documents automatically. I would produce a Fact Find document and Recommendation Report based on the answers in that initial survey. I imagine I'd have to use Excel as a database and I could use Dynamics as my CRM.
Does anybody think this is possible??
Thanks in advance
John
- Donal McCarthyBrass ContributorDynamics is just a Power App built on the Dataverse (the core Power Platform database) so if you have a Dynamics license, you don't need to use Excel to store data.
That said, if you are a small business, I would question whether you even need Dynamics.
For £15 a month, you could buy a Power Apps per User license. This would give you full access to the Dataverse (with 10Gb of storage) and Power Automate.
The Accounts and Contacts tables that you get in Dynamics are included in the Dataverse, Leads and Opportunities are not.
If the documents you want to generate are in Word, there is a very simple Word connector that can populate a Word template.
You could capture the date in MS Forms and use that to create/update records in the Dataverse.- JohnHollisCopper ContributorHi Donal,
Thanks for your help with this. Tech isn't my thing so I need someone like yourself to hold my hand through this, metaphorically speaking of course.
So, in short, you think this is possible?
That's great news because I've begun watching YouTube videos on how to use Power Apps but my main concern is that I fall down the rabbit-hole of this and then find out in 6 weeks time that it's not possible.
One of my main concerns is can Forms and the other basic apps handle the amount of information required in this type of process? As previously mentioned, many of the examples given that demonstrate automation are for basic processes such as a staff survey with half a dozen questions. What I'm looking to do dwarfs that but in my mind it is possible and worth the effort.
Any ideas on what I should do next? Should I get Power Apps? Explore what the dataverse is?
Thanks again
John- Donal McCarthyBrass Contributor
JohnHollis I think you should explore Dataverse. Yes, you will have to learn, but it I think it will be worth it for your business. Effectively, you can build a CRM for very cheap.
I think your main challange here will be getting the data in. I have barely used Forms and when I went to look at it there, it see`that is being rebranded to Dynamics 365 Cutomer Voice - which means it may have a Dynamics dependency. Transition from Forms Pro | Microsoft Docs