Forum Discussion
How far can Power Automate go?
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.
- Hi 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
JohnJohnHollis 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
Donal McCarthy Customer Voice is the old Forms Pro and is a totally separate product now from standard Forms.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
JohnHollis just be aware that in Forms you have a hard limit of 100 questions, but in reality it can be quite a bit lower if you include a lot of likert type questions as each statement is considered 1 question. I had to be quite careful about this in a form for a public consultation recently.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)JohnHollis if you are doing this in the Office 365 Power Platform apps rather than the core apps you are going to have to learn Power Apps or Power Automate, there is no way round that. Forms is a good jumping-off point but do bear in mind my previous comment re the question limit. Then it will need a flow in Power Automate to save each form response into a SharePoint list and to create the PDFs. It's all do-able but needs learning and work.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
