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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Title Header with ...
Power Automate
Answered

Get Title Header with Same Name

(0) ShareShare
ReportReport
Posted on by

Hi All,

I have one output from JSON but I can't mapping the data

So when the group ID is null, then the value is the header, where the group ID that has the same ID is the child. 

vividichtarosa_1-1719288091720.png

 

So the output I want to display is as follows:

vividichtarosa_2-1719288225569.png

Here is the output from JSON :

{
 "id": "4fmamP33NEuxNSgNB2SKLuxozBMagJpDq2cQEvKFp89UQkdYQk9USTNCT0NHTUFNUUY0TFFDTUozMS4u",
 "title": "SAM",
 "questions": [
 {
 "groupId": "rb5880f0da3104ac29fce9b54b4f1d858",
 "defaultValue": null,
 "image": {
 "altText": null,
 "contentType": null,
 "fileIdentifier": null,
 "originalFileName": null,
 "resourceId": null,
 "resourceUrl": null,
 "height": null,
 "width": null,
 "size": null
 },
 "modifiedDate": "2024-06-20T09:54:39.7816441Z",
 "status": "Added",
 "subtitle": null,
 "allowMultipleValues": false,
 "choices": [],
 "titleHasPhishingKeywords": false,
 "subtitleHasPhishingKeywords": false,
 "fileUploadSPOInfo": null,
 "formsProRTQuestionTitle": "Apakah tersedia report atau dashboard mengenai cost control dan management? (Top Management, medium level and operation cost)",
 "formsProRTSubtitle": null,
 "questionTagForIntelligence": null,
 "insightsInfo": null,
 "isFromSuggestion": false,
 "id": "r42049f4c06864872a337c0d8a3a5b221",
 "isQuiz": false,
 "order": 54833833.333333336,
 "deserializedQuestionInfo": null,
 "questionInfo": null,
 "required": false,
 "title": "Apakah tersedia report atau dashboard mengenai cost control dan management? (Top Management, medium level and operation cost)",
 "type": "Question.MatrixChoice",
 "justification": null,
 "allowCustomChoice": false,
 "imageDictionary": null,
 "trackingId": "b97d0f7cdab24a23a072a83324d1520e"
 },
 {
 "groupId": "rb5880f0da3104ac29fce9b54b4f1d858",
 "defaultValue": null,
 "image": {
 "altText": null,
 "contentType": null,
 "fileIdentifier": null,
 "originalFileName": null,
 "resourceId": null,
 "resourceUrl": null,
 "height": null,
 "width": null,
 "size": null
 },
 "modifiedDate": "2024-06-20T09:54:39.7816387Z",
 "status": "Added",
 "subtitle": null,
 "allowMultipleValues": false,
 "choices": [],
 "titleHasPhishingKeywords": false,
 "subtitleHasPhishingKeywords": false,
 "fileUploadSPOInfo": null,
 "formsProRTQuestionTitle": "Apakah ada activity/kegiatan untuk melakukan control budgeting serta analysis nya?",
 "formsProRTSubtitle": null,
 "questionTagForIntelligence": null,
 "insightsInfo": null,
 "isFromSuggestion": false,
 "id": "r44d6a7ea862b41e49b5b03a0ac3c9a6c",
 "isQuiz": false,
 "order": 54667166.666666664,
 "deserializedQuestionInfo": null,
 "questionInfo": null,
 "required": false,
 "title": "Apakah ada activity/kegiatan untuk melakukan control budgeting serta analysis nya?",
 "type": "Question.MatrixChoice",
 "justification": null,
 "allowCustomChoice": false,
 "imageDictionary": null,
 "trackingId": "776084bfb3da4cf4a24b84a770005759"
 },
 {
 "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-06-20T09:54:38.3166758Z",
 "status": "Added",
 "subtitle": null,
 "allowMultipleValues": false,
 "choices": [
 {
 "id": 1,
 "order": 1,
 "displayText": "0",
 "description": null,
 "isCustomChoice": false,
 "customProperties": "{\"FormsProDisplayRTText\":\"0\"}",
 "key": "251256af-851f-42b0-939d-bdd7333f27d7",
 "formsProDisplayRTText": null
 },
 {
 "id": 2,
 "order": 3,
 "displayText": "100",
 "description": null,
 "isCustomChoice": false,
 "customProperties": "{\"FormsProDisplayRTText\":\"100\"}",
 "key": "f4b7159a-b2b7-485d-987a-1bace48141e4",
 "formsProDisplayRTText": null
 },
 {
 "id": 3,
 "order": 2,
 "displayText": "50",
 "description": null,
 "isCustomChoice": false,
 "customProperties": "{\"FormsProDisplayRTText\":\"50\"}",
 "key": "14ecb9f0-9b47-4a1b-b9a1-ddcb3a6df0a7",
 "formsProDisplayRTText": null
 },
 {
 "id": 4,
 "order": 4,
 "displayText": "N/A",
 "description": null,
 "isCustomChoice": false,
 "customProperties": "{\"FormsProDisplayRTText\":\"N/A\"}",
 "key": "9fe763e0-cb7d-431e-8e62-8d8de66d1c71",
 "formsProDisplayRTText": null
 }
 ],
 "titleHasPhishingKeywords": false,
 "subtitleHasPhishingKeywords": false,
 "fileUploadSPOInfo": null,
 "formsProRTQuestionTitle": "<span>Planning, Budgeting, &amp; Cost - Control</span>",
 "formsProRTSubtitle": null,
 "questionTagForIntelligence": null,
 "insightsInfo": null,
 "isFromSuggestion": false,
 "id": "rb5880f0da3104ac29fce9b54b4f1d858",
 "isQuiz": false,
 "order": 54500500,
 "deserializedQuestionInfo": null,
 "questionInfo": "{\"ShuffleOptions\":false,\"ShowRatingLabel\":false,\"IsMathQuiz\":false}",
 "required": false,
 "title": "Planning, Budgeting, & Cost - Control",
 "type": "Question.MatrixChoiceGroup",
 "justification": null,
 "allowCustomChoice": false,
 "imageDictionary": null,
 "trackingId": "17723e332e7249169c9e74a956492349"
 }
 ]
}
Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    on at

    Hi , @vividichtarosa 

    This is my sample test flow:

    vyueyunmsft_0-1719294323464.png

    You can refer to , The Compose action is used to create the same json test data:

    vyueyunmsft_1-1719294466390.png

     

     

    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 ,

    You're a lifesaver! 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard