
Hi forum,
I'm very new to PowerApps and have no coding experience beyond a bit of entry-level VBA, so hoping someone can give me some pointers here....I'm trying to automate a particular process we use in my workplace but I've run into a bit of a dead-end and wondering if I can get around this (ideally without having to sign-up for any premium features or plug-ins).
Essentially we have one category of worker (A) completing a form, which contains eight text fields. I've created this in Forms and set up a flow with the submission of the form as a trigger, followed by 'get response details'; I've recently been playing around with different methods of recording the output, e.g. exporting to a Word document created in Sharepoint. But what I'm really keen to do is to create a method whereby the text inputted in the form then passes to another group of users (B) who review the contents and assign eight numerical scores representing a quantitative assessment (e.g. of the level of risks described by A across eight dimensions of business activity).
From what I've read so far, it appears that there is currently no way to plug the outputs from the first form into a second form, which is then assigned to group B users upon submission, i.e. it's impossible to pre-populate part of a form before another user is invited to complete other fields. Is this really the case, and would I need to use Dynamics to create this functionality? Is there another mechanism anyone can recommend which would allow me to collect text inputs from A, forward them to B, and then gather together the scorings?
Thanks in advance for any suggestions,
Ben
Hey Ben,
I think if you set up something like this it would work:
MSForms to collect data > flow writes data to a SharePoint List Row > separate flow is triggered 'on creation of new item' to notify reviewers > reviewers follow link in notification to open Power Apps > power apps app allows reviewers to view initial submissions and patches their decision to a second list > separate screen in app tallies up totals of secondary list submissions for that particular request.
Hope this suggestion helps you with a plan of action 🙂