Share via

One Form, Multiple Excel Sheets

Anonymous
2022-08-02T05:24:36+00:00

Hi, Im hoping to determine a way to have my team fill out one form and have the information routed to more than one excel sheet. For example, question 1 would route to sheet 1 and 2, question 2 would only route to sheet 2, etc etc. (This is to avoid the team having to populate multiple excel sheets with similar details.) Thanks in advance!

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-08-03T03:44:00+00:00

    Dear Tracee415,

    I'm following up on the thread.

    You can get all form responses from Microsoft Forms Rest API and then extract all Question1's responses to sheet1 and all Question2's responses to sheet2 and so on by Power Automate. You can create a temporary list to store the Question1 responses and Question2 responses.

    You can create the flow as follows.

    Rest API to get all responses.

    Method: Get

    Uri: formapi/api/forms('formid')/responses

    Apply to each: outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['value']

    Compose: items('Apply_to_each')?['answers']

    Compose2: json(item()['answers'])[0]['answer1']

    Compose3: json(item()['answers'])[1]['answer1']

    Result:

    Welcome to share any updates when you have time if you need further help on this issue.

    Sincerely,

    Cliff | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save". ***

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-02T09:32:47+00:00

    Dear Tracee415

    Good day! Thank you for posting in Microsoft Community. We are happy to help you.

    Based on your description, it seems that you want to make different question can route to different sheets in Excel via one Form. If my understanding is correct, the easy and quick way is to use Power Automate flow to achieve this requirement. We have some reference about this and hope it can give you some ideas:

    Solved: Re: Updating an excel sheet which is a subject of ... - Power Platform Community (microsoft.com)

    One form with multiple excel sheets inside workboo... - Power Platform Community (microsoft.com)

    Besides, we should do a test for this query so that we can provide the best answer for you, the test maybe needs to take a little time to finish, so we kindly suggest you keep patient and give us some time to do the test.

    We’ll post back as soon as possible once we have finished the test and we’ll post back to update the latest situation to you.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Stacey | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save". ***

    0 comments