Azure Logic Apps and Microsoft Forms - Get field descriptors

Question

I have a Logic App that retrieves the responses submitted by the users through Microsoft Forms.

When I see the Logic App Run, I can see the descriptor for each field (MuleSoft, IoT & Integration, Encuesta de tecnologías, ...), for example:

But in the "Show raw outputs" I can't see those fields, I get an identifier (rcb6ccf0fc9e44f74b44fa2715fec4f27, ...):

How I can retrieve those descriptors??

I also have this question. Did you find a way to do this? – Steve Lovell Jun 17 '22 at 10:03 — Steve Lovell, Jun 17 '22 at 10:03
@SteveLovell I gave the solution on this thread. – felixmondelo Jun 21 '22 at 16:22 — felixmondelo, Jun 21 '22 at 16:22

score 1 · Accepted Answer · answered Jun 21 '22 at 16:18

The solution is to add a 'Send an HTTP request to SharePoint' action to get the details of the form.

The Site Address is: https://forms.office.com The Method is: GET The Uri is: /formapi/api/forms('')?select=id,title,questions&$expand=questions($expand=choices)

This returns a JSON with all the questions and for each question the ID, Title and more info about the question.

We can implement a loop through these questions and with each ID, extract the response from the Microsoft Forms:

foreach": "@body('Send_an_HTTP_request_to_SharePoint')['questions']"

And Compose the result:

"Compose": {
   "inputs": {
      "Id": "@{items('For_each')['id']}",
      "Name": "@items('For_each')['title']",
      "Value": "@{body('Get_response_details')[item()['id']]}"
   },
   "runAfter": {},
   "type": "Compose"
 }

score 0 · Answer 2 · answered May 05 '22 at 11:49

0

These are field identifiers. You can retrieve them directly from the Dynamic content of Get response details.

Alternatively, you can build your own JSON body(in your case Get response details) from Compose connector.

answered May 05 '22 at 11:49

SwethaKandikonda

7,513
2
4
18

But it's possible to get the field names also? – felixmondelo May 09 '22 at 06:38
@felixmondelo You can directly view those names from the Dynamic content itself. – SwethaKandikonda May 09 '22 at 06:46
@felixmondelo In case you want to send a custom body you can build it. Please refer the attached image https://i.imgur.com/Wmu5D4k.png – SwethaKandikonda May 09 '22 at 06:58
The question is if there is the possibility to get dynamically the field names. – felixmondelo May 10 '22 at 07:16
@felixmondelo, afaik you can't get the form names dynamically – SwethaKandikonda May 18 '22 at 05:33

Azure Logic Apps and Microsoft Forms - Get field descriptors

2 Answers2