Unanswered

Running list of items submitted by Microsoft Forms

(0) Share

Report

Posted on by SarahKeown

I have a Microsoft Form for Ladies Uniform order/request.

An employee will fill out this form and has the option to order multiple items e.g. 1 zip up jacket, 2 polo shirts and 1 long sheet shirt.

The form can be completed multiples times for an employee.

The structure of the form is as follows

Q: Please select the item you want to purchase?

A: Choice of items (only one to be selected)

Q: What size of the selected item?

A: Choice of size (only one to be selected)

Q: Qty of the selected item?

A: Number input

Q: Do you wish to request an additional item?

A: Yes/No

If Yes they will see the same questions Select item > Size > Qty and then asked for additional items.

Basically that will go in a loop.

However, in excel this feeds into the spreadsheet horizontally (as shown below).

But I wish to have it in this running list over time, in a format similar to below.

Is this possible to do?

I'm not overly familiar with using power automate/forms in this way.

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (0)

Ajinder31 530 on at

Like (1)

Report
Copy link

Link copied!

Hi @SarahKeown , Yes, it sounds possible. Will you be able to share the form response details received in Power Automate?

Was this reply helpful? Yes No
SarahKeown 77 on at

Like (0)

Report
Copy link

Link copied!

I haven't even gotten as far as setting up the power automate yet as there are a few other things I need to check if they are possible.

At the minute I only have a couple of questions laid out in the form.

Was this reply helpful? Yes No
Ajinder31 530 on at

Like (0)

Report
Copy link

Link copied!

Hi @SarahKeown , Unfortunately I don't know how to configure the Microsoft form as per requirement (i.e to go in the loop) but Yes, it will be possible to save the response using power automate in different rows.

Was this reply helpful? Yes No
SarahKeown 77 on at

Like (0)

Report
Copy link

Link copied!

Do you know the specific automate rule that allows for that?

Was this reply helpful? Yes No
SarahKeown 77 on at

Like (0)

Report
Copy link

Link copied!

I understand that I can create a new row for every form response, but in this case I would have to separate individual responses from 1 form into new rows.

If you look at the pdf, each item can be requested in one form, so for a body warmer, size 10, 3 qty thats one row. Another row for the softshell jacket and so on.. All completed via one form

Ladies Uniform Or...

Was this reply helpful? Yes No
Ajinder31 530 on at

Like (1)

Report
Copy link

Link copied!

Hi @SarahKeown , That sounds doable. Just setup the form as per your requirement and let me know the response received in Power automate. I will be able help you.

Was this reply helpful? Yes No
SarahKeown 77 on at

Like (0)

Report
Copy link

Link copied!

That would be great, can you clarify what you mean by response received in power automate??

Was this reply helpful? Yes No
Ajinder31 530 on at

Like (0)

Report
Copy link

Link copied!

Sure @SarahKeown , As per my knowledge it is not possible to save single response in multiple rows by default using Microsoft form so what we can do it to use Power Automate to achieve the required.

A Power automate flow will be configured to triggered on submission of Microsoft Form. Once we have the submitted form in Power Automate we can save the data as per our requirement.

This Flow with Forms documentation link and Video should help in getting started with it.

Was this reply helpful? Yes No
SarahKeown 77 on at

Like (0)

Report
Copy link

Link copied!

Please see included screenshot and body of the response received
{
    "statusCode": 200,
    "headers": {
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=2592000; includeSubDomains",
        "X-RoutingOfficeCluster": "neu-100.forms.office.com,neu-101.forms.office.com",
        "X-RoutingOfficeFE": "FormsSingleBox_IN_10,FormsSingleBox_IN_8",
        "X-RoutingOfficeVersion": "16.0.15831.42055,16.0.15831.42055",
        "X-RoutingSessionId": "0058c55d-86e2-4e09-8ee0-e1316c470967",
        "X-RoutingCorrelationId": "660c09a7-3487-4768-b42c-7ecaeb236834",
        "X-CorrelationId": "660c09a7-3487-4768-b42c-7ecaeb236834",
        "X-OfficeCluster": "neu-101.forms.office.com",
        "X-OfficeFE": "FormsSingleBox_IN_13",
        "X-OfficeVersion": "16.0.15831.42055",
        "X-UserSessionId": "0058c55d-86e2-4e09-8ee0-e1316c470967",
        "X-Robots-Tag": "noindex,nofollow",
        "OData-Version": "4.0",
        "X-Cache": "CONFIG_NOCACHE",
        "X-MSEdge-Ref": "Ref A: B7790290B80D447989158D4BD8A22D65 Ref B: LON212050709033 Ref C: 2022-11-08T12:23:41Z",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Tue, 08 Nov 2022 12:23:41 GMT",
        "Content-Type": "application/json",
        "Content-Length": "693"
    },
    "body": {
        "responder": "anonymous",
        "submitDate": "11/8/2022 12:23:41 PM",
        "r3f1faebfffb547538c5a5f9ef812ce63": "Regatta Softshell Jacket ",
        "r2e46baa3d390458baa5b8856c354a21b": "10",
        "ra2f266e9b24e4935b2d4c8923d42d7ce": "3",
        "r5804a86bc29c4f6c844d56e29322a415": "Yes",
        "r6c352a137a1b41e8aadf674879875044": "8",
        "rd4ec4c50432f40b5a8752c1b5d8fbf87": "1",
        "r901abd4deb0545c9be707cd7062bb999": "Regatta Softshell Body Warmer",
        "r0304dec0a590485e8068a0559c25ed83": "Yes",
        "r76a708d05f18436fbddd877c433d2ec3": "Sweatshirt (round-neck)",
        "rb5270a9ba3c14efe8f6bbf552db924f0": "",
        "r6cf3201f946b48d7a0dc3f5d3f817409": "1",
        "r2f100053c106471982f776c1d2fa1d64": "No"
    }
}

Alternative Heat ...

Was this reply helpful? Yes No
SarahKeown 77 on at

Like (0)

Report
Copy link

Link copied!

I have attached the raw outputs from power automate

{
    "statusCode": 200,
    "headers": {
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=2592000; includeSubDomains",
        "X-RoutingOfficeCluster": "neu-100.forms.office.com,neu-101.forms.office.com",
        "X-RoutingOfficeFE": "FormsSingleBox_IN_10,FormsSingleBox_IN_8",
        "X-RoutingOfficeVersion": "16.0.15831.42055,16.0.15831.42055",
        "X-RoutingSessionId": "0058c55d-86e2-4e09-8ee0-e1316c470967",
        "X-RoutingCorrelationId": "660c09a7-3487-4768-b42c-7ecaeb236834",
        "X-CorrelationId": "660c09a7-3487-4768-b42c-7ecaeb236834",
        "X-OfficeCluster": "neu-101.forms.office.com",
        "X-OfficeFE": "FormsSingleBox_IN_13",
        "X-OfficeVersion": "16.0.15831.42055",
        "X-UserSessionId": "0058c55d-86e2-4e09-8ee0-e1316c470967",
        "X-Robots-Tag": "noindex,nofollow",
        "OData-Version": "4.0",
        "X-Cache": "CONFIG_NOCACHE",
        "X-MSEdge-Ref": "Ref A: B7790290B80D447989158D4BD8A22D65 Ref B: LON212050709033 Ref C: 2022-11-08T12:23:41Z",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Tue, 08 Nov 2022 12:23:41 GMT",
        "Content-Type": "application/json",
        "Content-Length": "693"
    },
    "body": {
        "responder": "anonymous",
        "submitDate": "11/8/2022 12:23:41 PM",
        "r3f1faebfffb547538c5a5f9ef812ce63": "Regatta Softshell Jacket ",
        "r2e46baa3d390458baa5b8856c354a21b": "10",
        "ra2f266e9b24e4935b2d4c8923d42d7ce": "3",
        "r5804a86bc29c4f6c844d56e29322a415": "Yes",
        "r6c352a137a1b41e8aadf674879875044": "8",
        "rd4ec4c50432f40b5a8752c1b5d8fbf87": "1",
        "r901abd4deb0545c9be707cd7062bb999": "Regatta Softshell Body Warmer",
        "r0304dec0a590485e8068a0559c25ed83": "Yes",
        "r76a708d05f18436fbddd877c433d2ec3": "Sweatshirt (round-neck)",
        "rb5270a9ba3c14efe8f6bbf552db924f0": "",
        "r6cf3201f946b48d7a0dc3f5d3f817409": "1",
        "r2f100053c106471982f776c1d2fa1d64": "No"
    }
}

Alternative Heat ...

Was this reply helpful? Yes No