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 e...
JohnHollis
Jun 21, 2022Copper Contributor
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
John
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
RobElliott
Jun 21, 2022Silver Contributor
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)
- RobElliottJun 21, 2022Silver Contributor
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)- JohnHollisJun 21, 2022Copper ContributorSame to you Rob, where's the best place to start learning? Is it YouTube channels? Websites? Books?
- Donal McCarthyJun 21, 2022Brass Contributor
RobElliott - thanks - that makes sense - like I said - don't really use forms
JohnHollis - if you run into a wall with the forms limitations that RobElliott mentioned, Power Automate does have a connector for paid Surveymonkey accounts.
I really would try to use the Dataverse as opposed to SharePoint.
- JohnHollisJun 21, 2022Copper ContributorAny ideas where is the best place to learn? Is it YouTube channels? Websites? Books?
- JohnHollisJun 21, 2022Copper ContributorCheers Rob,
Is there any alternative to Forms?
How would you suggest I structure this? Do you even think it's possible?
John