Skip to main content

Notifications

Power Automate - Translation Quality Feedback
Unanswered

How to Use Power Automate to direct data

(0) ShareShare
ReportReport
Posted on by 50
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:
  • Verified answer
    Neilers72 Profile Picture
    Neilers72 50 on at
    How to Use Power Automate to direct data
    Thanks for the response but I have the answer I was looking for and have it running in the away that I wanted it.
  • David_MA Profile Picture
    David_MA 8,929 on at
    How to Use Power Automate to direct data
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics