web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Mapping from HTTP Acti...
Power Automate
Answered

Mapping from HTTP Action and Store the data with 1 line for 1 Questions

(0) ShareShare
ReportReport
Posted on by

Hi all,

I am trying to use action below when get the data from Microsoft Form and store the data to the sharepointlist. 

vividichtarosa_0-1716943101296.png

But The API works fine for me when I test as below.

1. However, I need to mapping the output and nothing I have tried works. Screenshot Input :

vividichtarosa_1-1716943464913.png

 Screenshoot Output : 

vividichtarosa_2-1716943513053.png

2. Then I want to mapping the data in 1 row for 1 question, not merged into 1 line

vividichtarosa_3-1716943574757.png

 

Categories:
I have the same question (0)
  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @vividichtarosa 

    Can you give me your Send an http request output in your side. And which field you want to extract ? Can you give me the detailed end result you want to get from your Json object?

     

    Best Regards,

    Yueyun Zhang

     

  • vividichtarosa Profile Picture
    on at

    Hi @v-yueyun-msft 

    Output like this in my side , data not show after I parse JSON:

    vividichtarosa_0-1716947913480.png

     

    But I want to the data show like this :

    [

       {

         "Question" : "Apakah sudah dilakukan pengecekan?",

         "Answer": "90 %"

       },

      {

         "Question" : "Apakah sudah menggunakan SOP?",

         "Answer": "0 %"

       }

    ]

     

    The following is the current order of queries in Power Automate:

    1. 

    vividichtarosa_1-1716948121244.png

     

    2. 

    vividichtarosa_2-1716948174951.png

     

    3.

    vividichtarosa_3-1716948201823.png

     

    4.

    vividichtarosa_4-1716948225513.png

    5.

    vividichtarosa_5-1716948243908.png

     

    6.

    vividichtarosa_6-1716948258164.png

     

  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @vividichtarosa 

    Thanks for your response! Do you mean you want to get the result from your "Send an http request to SharePoint" action?

    [

       {

         "Question" : "Apakah sudah dilakukan pengecekan?",

         "Answer": "90 %"

       },

      {

         "Question" : "Apakah sudah menggunakan SOP?",

         "Answer": "0 %"

       }

    ]

     

    So the data "Apakah sudah dilakukan pengecekan?" , "90 %" , "Apakah sudah menggunakan SOP?" , "0 %" are all from your "Send an http request to SharePoint" action. Right?

     

    If this , can you give me your "Send an http request to SharePoint" action outputs (You can give the field you need to extract in it)in your side so i can make a sample test flow to help you.

     

    Best Regards,

    Yueyue Zhang

  • vividichtarosa Profile Picture
    on at

    Hi @v-yueyun-msft ,

    "Send an http request to SharePoint" action outputs from my side

    {
     "statusCode": 200,
     "headers": {
     "Cache-Control": "no-store, no-cache",
     "Pragma": "no-cache",
     "Transfer-Encoding": "chunked",
     "Vary": "Accept-Encoding",
     "Set-Cookie": "ARRAffinity=f2f616db1fb852bebf8d33f4c2e809bd2033537707f3f091cc1bbac7ec19b816;Path=/;HttpOnly;Secure;Domain=sharepointonline-sea.azconn-sea-001.p.azurewebsites.net,ARRAffinitySameSite=f2f616db1fb852bebf8d33f4c2e809bd2033537707f3f091cc1bbac7ec19b816;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-sea.azconn-sea-001.p.azurewebsites.net",
     "Strict-Transport-Security": "max-age=2592000; includeSubDomains",
     "X-RoutingOfficeCluster": "sea-103.forms.office.com",
     "X-RoutingOfficeFE": "FormsSingleBox_IN_23",
     "X-RoutingOfficeVersion": "16.0.17722.42053",
     "X-RoutingSessionId": "e9c56b96-1f6b-4005-a470-7eb3745ddd59",
     "X-RoutingCorrelationId": "e6a9e7a3-da0a-44e8-b40a-a9736a5f5626",
     "X-CorrelationId": "e6a9e7a3-da0a-44e8-b40a-a9736a5f5626",
     "X-OfficeCluster": "sea-103.forms.office.com",
     "X-OfficeFE": "FormsSingleBox_IN_0",
     "X-OfficeVersion": "16.0.17722.42053",
     "X-UserSessionId": "e9c56b96-1f6b-4005-a470-7eb3745ddd59",
     "X-Robots-Tag": "noindex,nofollow",
     "X-Cache": "CONFIG_NOCACHE",
     "X-MSEdge-Ref": "Ref A: 1476575FCC7B4A58A23FAEB7F93237D5 Ref B: SG2EDGE2910 Ref C: 2024-05-29T05:59:13Z",
     "x-ms-request-id": "dd7c926c-03dd-4f3b-86df-31c264f7a1d5",
     "X-Content-Type-Options": "nosniff",
     "X-Frame-Options": "DENY",
     "Timing-Allow-Origin": "*",
     "x-ms-apihub-cached-response": "true",
     "x-ms-apihub-obo": "false",
     "Date": "Wed, 29 May 2024 05:59:13 GMT",
     "Content-Type": "application/json; charset=utf-8",
     "Content-Length": "91952",
     "Expires": "-1"
     },
     "body": {
     "createdBy": "Vivid",
     "responses": [],
     "permissionTokens": [],
     "fileUploadFormInfo": {
     "driveId": "b!MZDEyTA2Mk-z3Zgw04Bsqvv8bGkft5tInxpFnnSuLc-eRg5sttFrQ4BO-v4wFgoe",
     "folderId": "017Z3MYUOBLLCOT6AT4BF3C7LQU2I2HD3S",
     "errorCode": null
     },
     "xlFileUnSynced": false,
     "description": "DIVISION OF REBUILD COMPONENT\nPRC AUTO ELECTRIC PRC ENGINEPRC\n\nDRIVE TRAIN & TRANSMISSION\nPRC UNDERCARRIAGE & FABRICATIONPRC TEST BENCHPRC CYLINDERPRC HYD PUMP & MOTOR",
     "onlineSafetyLevel": 0,
     "reputationTier": 1,
     "background": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "header": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "logo": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "tableId": "T9LT0ZQCOZKKS10IW4AJLIJCCD",
     "otherInfo": "{\"Theme\":{\"Name\":\"Teal\",\"PrimaryColor\":\"#03787c\",\"SecondaryColor\":\"#014446\",\"Source\":0,\"BackgroundColor\":\"#e8f2f4\",\"SecondaryBackgroundType\":2,\"Thumbnail\":\"/Images/Theme/new-teal-thumbnail.png\",\"Type\":0}}",
     "permissions": [],
     "responderPermissions": [],
     "status": "Active",
     "localeInfo": "{\"TimezoneOffset\":420,\"Locale\":\"id-ID\",\"TimezoneId\":\"Asia/Bangkok\"}",
     "descriptiveQuestions": [],
     "questions": [
     {
     "groupId": null,
     "defaultValue": null,
     "image": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "modifiedDate": "2024-02-22T07:55:14.6925638Z",
     "status": "Added",
     "subtitle": null,
     "allowMultipleValues": null,
     "choices": [],
     "titleHasPhishingKeywords": false,
     "subtitleHasPhishingKeywords": false,
     "fileUploadSPOInfo": null,
     "formsProRTQuestionTitle": "<b>Functional Location/ Unit No/ Other</b>",
     "formsProRTSubtitle": null,
     "questionTagForIntelligence": null,
     "insightsInfo": null,
     "isFromSuggestion": false,
     "id": "r375c27f21da24c4d9fbd3edb12f7e76a",
     "isQuiz": false,
     "order": 19000500,
     "deserializedQuestionInfo": null,
     "questionInfo": "{\"Multiline\":false,\"ShuffleOptions\":false,\"ShowRatingLabel\":false,\"IsMathQuiz\":false}",
     "required": true,
     "title": "Functional Location/ Unit No/ Other",
     "type": "Question.TextField",
     "justification": null,
     "allowCustomChoice": null,
     "trackingId": "702ce2b550a24449a47fa3c1ada4311a"
     },
     {
     "groupId": null,
     "defaultValue": null,
     "image": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "modifiedDate": "2024-02-19T07:44:27.8978584Z",
     "status": "Added",
     "subtitle": null,
     "allowMultipleValues": null,
     "choices": [],
     "titleHasPhishingKeywords": false,
     "subtitleHasPhishingKeywords": false,
     "fileUploadSPOInfo": null,
     "formsProRTQuestionTitle": "<b>Remarks Activity</b>",
     "formsProRTSubtitle": null,
     "questionTagForIntelligence": null,
     "insightsInfo": "{\"AutoPinnedInsights\":[\"ResponseWordCloudInsight_rdb2e1cd908414a56acf4347bd5c30371\"],\"PinedInsights\":[\"ResponseWordCloudInsight_rdb2e1cd908414a56acf4347bd5c30371\"]}",
     "isFromSuggestion": false,
     "id": "rdb2e1cd908414a56acf4347bd5c30371",
     "isQuiz": false,
     "order": 12000500,
     "deserializedQuestionInfo": null,
     "questionInfo": "{\"Multiline\":false,\"ShuffleOptions\":false,\"ShowRatingLabel\":false,\"IsMathQuiz\":false}",
     "required": false,
     "title": "Remarks Activity",
     "type": "Question.TextField",
     "justification": null,
     "allowCustomChoice": null,
     "trackingId": "52bec04f8761448486cab183addfcc1a"
     },
     {
     "groupId": null,
     "defaultValue": null,
     "image": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "modifiedDate": "2024-02-22T09:01:43.210491Z",
     "status": "Added",
     "subtitle": null,
     "allowMultipleValues": null,
     "choices": [],
     "titleHasPhishingKeywords": false,
     "subtitleHasPhishingKeywords": false,
     "fileUploadSPOInfo": null,
     "formsProRTQuestionTitle": "<b>Finish Date Field</b>",
     "formsProRTSubtitle": null,
     "questionTagForIntelligence": null,
     "insightsInfo": null,
     "isFromSuggestion": false,
     "id": "r3572dc6a0c83456a81c41469136174b8",
     "isQuiz": false,
     "order": 37000500,
     "deserializedQuestionInfo": null,
     "questionInfo": "{\"Date\":true,\"Time\":false,\"ShuffleOptions\":false,\"ShowRatingLabel\":false,\"IsMathQuiz\":false}",
     "required": true,
     "title": "Finish Date Field",
     "type": "Question.DateTime",
     "justification": null,
     "allowCustomChoice": null,
     "trackingId": "789f46012dc84554ae28d09512963ed2"
     },
     {
     "groupId": null,
     "defaultValue": null,
     "image": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "modifiedDate": "2024-05-21T01:10:13.01354Z",
     "status": "Added",
     "subtitle": null,
     "allowMultipleValues": null,
     "choices": [],
     "titleHasPhishingKeywords": false,
     "subtitleHasPhishingKeywords": false,
     "fileUploadSPOInfo": null,
     "formsProRTQuestionTitle": "<span>Apakah list/ daftar unit tersedia (Machine Population)?</span>",
     "formsProRTSubtitle": null,
     "questionTagForIntelligence": null,
     "insightsInfo": null,
     "isFromSuggestion": false,
     "id": "rf85f17ebde3d407d84ec3ad5ad005760",
     "isQuiz": false,
     "order": 5000500,
     "deserializedQuestionInfo": null,
     "questionInfo": "{\"Choices\":[{\"Description\":\"0 %\",\"FormsProDisplayRTText\":\"0 %\"},{\"Description\":\"50 %\",\"FormsProDisplayRTText\":\"50 %\"},{\"Description\":\"100 %\",\"FormsProDisplayRTText\":\"100 %\"},{\"Description\":\"N/A\",\"FormsProDisplayRTText\":\"N/A\"}],\"ChoiceType\":1,\"AllowOtherAnswer\":false,\"OptionDisplayStyle\":\"ListAll\",\"ChoiceRestrictionType\":\"None\",\"ShowRatingLabel\":false}",
     "required": false,
     "title": "Apakah list/ daftar unit tersedia (Machine Population)?",
     "type": "Question.Choice",
     "justification": null,
     "allowCustomChoice": null,
     "trackingId": "e3d255b45acc4fc4a9e025abbf8b3b7e"
     },
     {
     "groupId": null,
     "defaultValue": null,
     "image": {
     "altText": null,
     "contentType": null,
     "fileIdentifier": null,
     "originalFileName": null,
     "resourceId": null,
     "resourceUrl": null,
     "height": null,
     "width": null,
     "size": null
     },
     "modifiedDate": "2024-05-21T01:04:23.345321Z",
     "status": "Added",
     "subtitle": null,
     "allowMultipleValues": null,
     "choices": [],
     "titleHasPhishingKeywords": false,
     "subtitleHasPhishingKeywords": false,
     "fileUploadSPOInfo": null,
     "formsProRTQuestionTitle": "Version",
     "formsProRTSubtitle": null,
     "questionTagForIntelligence": null,
     "insightsInfo": null,
     "isFromSuggestion": false,
     "id": "rda289ff36ce0452783ee806c2cc411a8",
     "isQuiz": false,
     "order": 1000500,
     "deserializedQuestionInfo": null,
     "questionInfo": "{\"Choices\":[{\"Description\":\"Full\",\"FormsProDisplayRTText\":\"Full\",\"BranchInfo\":{\"TargetQuestionId\":\"rc463e9241af548f3b3aa25eb2792551d\"}},{\"Description\":\"Lite\",\"FormsProDisplayRTText\":\"Lite\",\"BranchInfo\":{\"TargetQuestionId\":\"r0a53190bdefe4b65a3067f5a4e425f2e\"}}],\"ChoiceType\":1,\"AllowOtherAnswer\":false,\"OptionDisplayStyle\":\"ListAll\",\"ChoiceRestrictionType\":\"None\"}",
     "required": false,
     "title": "Version",
     "type": "Question.Choice",
     "justification": null,
     "allowCustomChoice": null,
     "trackingId": "0e19300dad064539ab8ac3c9dfef5bf8"
     }
     ],
     "fillOutRemainingTime": 0,
     "timedFormStartTime": "0001-01-01T00:00:00Z",
     "id": "",
     "title": "E-Form Time Card",
     "createdDate": "2024-02-19T07:31:31.797Z",
     "modifiedDate": "2024-02-26T01:02:45.737Z",
     "version": "1.0",
     "ownerId": "13cc68ec-801a-439a-ab67-1012f285a7cf",
     "ownerTenantId": "",
     "settings": "{\"RequiresUniqueResponse\":false,\"IsAnonymous\":false,\"NotRecordIdentity\":false,\"IsQuizMode\":false,\"PermissionForResponder\":2,\"ShareToken\":\"f5YDGDrU6UX3bRjOYay4\",\"AllowCopy\":true}",
     "softDeleted": 0,
     "flags": 4,
     "type": "form",
     "formsProRTTitle": "E-Form Time Card",
     "formsProRTDescription": "<b>DIVISION OF REBUILD COMPONENT</b><br><ul><li><b><i>PRC AUTO ELECTRIC&nbsp;</i></b></li><li><b><i>PRC ENGINE</i></b></li><li><b><i>PRC</i></b></li></ul><br><b><i><b><i><br></i></b></i></b><i><b><i>DRIVE TRAIN</i>&nbsp;&amp; TRANSMISSION</b></i><br><ul><li><b><i>PRC UNDERCARRIAGE &amp; FABRICATION</i></b></li><li><b><i>PRC TEST BENCH</i></b></li><li><b><i>PRC CYLINDER</i></b></li><li><b><i>PRC HYD PUMP &amp; MOTOR</i></b></li></ul>",
     "localeList": [],
     "tenantSwitches": 0,
     "fillOutTimeLimit": 0,
     "rowCount": 7,
     "progressBarEnabled": "false",
     "trackingId": "",
     "themeV2": "{\"Layout\":\"Paper\",\"Name\":\"Teal\",\"PrimaryColor\":\"#03787c\",\"SecondaryColor\":\"#014446\",\"ThirdColor\":\"#e8f2f4\",\"PrimaryImage\":{\"Source\":\"FormsCdn\",\"Thumbnail\":\"/Images/Theme/new-teal-thumbnail.png\"},\"PrimaryVideo\":{\"Source\":\"FormsCdn\",\"Thumbnail\":\"/Images/Theme/new-teal-thumbnail.png\"},\"PrimaryMediaType\":\"Image\",\"ContentType\":\"Predefined\"}"
     }
    }

     

     

  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @vividichtarosa 

    Thanks for your response and your json, can you give me the end result you want to extract from this json?

    Best Regards,

    Yueyun Zhang

     

  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @vividichtarosa 

    Do you mean you want to extract all the title from your json?

    vyueyunmsft_0-1717036984336.png

    If this you can refer to my test flow:

    vyueyunmsft_1-1717037045368.png

    outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['questions']
    item()?['title']

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

  • vividichtarosa Profile Picture
    on at

    Hi @v-yueyun-msft ,

    Great ! Thanks for your solution. 

    But i have to create item from select action.

    vividichtarosa_0-1717038495277.png

     

    then i want to store to the data with 1 row for 1 question and score, NOT merge or combine in 1 row

    vividichtarosa_1-1717038927562.png

     

  • apgjoe Profile Picture
    2 on at

    This helps. Thanks

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 261 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 185

#3
Haque Profile Picture

Haque 168

Last 30 days Overall leaderboard