Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Forms "Name" in {"Name":"Value"} pair of json file from Logic Apps pipeline output returning GUIDs



I am processing the output of Office Forms responses in a Logic Apps Pipeline to be cross analysed in a Power BI report as seen in the attached screen shots.


When reviewing the successful run in the Logic Apps Designer, the list of question and response are shown correctly. However, when reviewing the raw output in the Logic Apps Designer and the exported json in VS Code and Power BI, the "Name" in the {"Name":"Value"} pair is returning a GUID instead of the Form question.


How do I get the original questions - "Name" - to return in the raw output and exported json? 


For example, instead of


Name | Value

rd320d83389a744d98d88855a4133d4d9 | Highly experienced and supported


{"rd320d83389a744d98d88855a4133d4d9 ": "Highly experienced and supported", ...}


The desired output is:


Name | Value

What is your capability to support Office Forms implementations? | Highly experienced and supported


{"What is your capability to support Office Forms implementations? ": "Highly experienced and supported", ...}



0 Replies