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

%3CLINGO-SUB%20id%3D%22lingo-sub-2380030%22%20slang%3D%22en-US%22%3EForms%20%22Name%22%20in%20%7B%22Name%22%3A%22Value%22%7D%20pair%20of%20json%20file%20from%20Logic%20Apps%20pipeline%20output%20returning%20GUIDs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380030%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20processing%20the%20output%20of%20Office%20Forms%20responses%20in%20a%20Logic%20Apps%20Pipeline%20to%20be%20cross%20analysed%20in%20a%20Power%20BI%20report%20as%20seen%20in%20the%20attached%20screen%20shots.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20reviewing%20the%20successful%20run%20in%20the%20Logic%20Apps%20Designer%2C%20the%20list%20of%20question%20and%20response%20are%20shown%20correctly.%20However%2C%20when%20reviewing%20the%20raw%20output%20in%20the%20Logic%20Apps%20Designer%20and%20the%20exported%20json%20in%20VS%20Code%20and%20Power%20BI%2C%20the%20%22Name%22%20in%20the%20%7B%22Name%22%3A%22Value%22%7D%20pair%20is%20returning%20a%20GUID%20instead%20of%20the%20Form%20question.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3E%3CSTRONG%3EHow%20do%20I%20get%20the%20original%20questions%20-%20%22Name%22%20-%20to%20return%20in%20the%20raw%20output%20and%20exported%20json%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20instead%20of%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3EName%20%7C%20Value%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3Erd320d83389a744d98d88855a4133d4d9%20%7C%26nbsp%3BHighly%20experienced%26nbsp%3Band%20supported%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3Ei.e.%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%7B%22%3CEM%3Erd320d83389a744d98d88855a4133d4d9%20%3C%2FEM%3E%22%3A%20%22%3CEM%3EHighly%20experienced%26nbsp%3Band%20supported%3C%2FEM%3E%22%2C%20...%7D%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20desired%20output%20is%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3EName%20%7C%20Value%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3EWhat%20is%20your%20capability%20to%20support%20Office%20Forms%20implementations%3F%20%7C%26nbsp%3BHighly%20experienced%26nbsp%3Band%20supported%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3Ei.e.%26nbsp%3B%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CEM%3E%7B%22What%20is%20your%20capability%20to%20support%20Office%20Forms%20implementations%3F%26nbsp%3B%22%3A%20%22Highly%20experienced%26nbsp%3Band%20supported%22%2C%20...%7D%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2380030%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELogic%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

 

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

i.e.

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

 

The desired output is:

 

Name | Value

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

i.e. 

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

 

 

0 Replies