Answered

How to Use Power Automate to direct data

(0) Share

Report

Posted on by Neilers72

Hi All

I have an MS Form that is used for reviews - in total there are 4 reviews that the user can select. When the user selects the review they are conducting the branching function in MS Forms takes the user to that set of questions for that particular review. One the review questions have been answered the form is submitted.

I need to do two things

1) capture the data

2) create a PDF that only incorporates the review that was selected

1) is it best to set up 4 lists (one for each review) so when a review is selected, completed and submitted it is saved in to that reviews List - if so how do I go about doing that or should I use just one list - there is a total of 105 questions over the 4 reviews so that's a lot of data.

2) How do I produce a PDF that only captures the review data that was selected - is there a way of using the review that the user has selected in MS Form as the trigger?

I could use 4 MS forms (one for each review) and set them all up separately and run it that way, I know how to do this and how to email the PDF to the user etc - but the reason to use one form with branching reduces the number of forms the staff have to use. Its like a one form fits all.

If anyone is able to give me some advice on this or indeed an alternative solution I would be very grateful.

Hopefully I have explained this well enough

Categories:

Translation quality feedback

I have the same question (0)

All responses (2)

Answers (1)

David_MA 13,502 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You have put your post in the Translation Quality Feedback forum. I don't see how this relates to translation. I am also not sure I see a relationship to Power Automate in what you are asking to do. From what you describe, all this can be done within MS Forms without the need for a flow.

With MS Forms, the data is saved within MS forms. You just need to open the form and choose View Responses.

If you need to print a specific response to PDF, from the response overview, choose Check individual results. Then just print it to a PDF file.

If you need to provide the response to the submitter, go to the form settings and check the box, "Allow respondents to save their responses." That will enable the responder to get it immediately after they complete the form.

As an added benefit, the responses within MS Forms include automatic analytics on the responses.

If you are having trouble with the above in MS Forms, I suggest you post a question in the MS Forms Community at Microsoft Forms | Microsoft Community Hub.

If there is something specific you need to automate with this, I suggest you clarify what that is and post it in one of the other Power Automate forums such as General Discussion.

Was this reply helpful? Yes No
Verified answer

Neilers72 64 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response but I have the answer I was looking for and have it running in the away that I wanted it.

Was this reply helpful? Yes No