How i can add a SurveyMonkey Response In CSV file from power automate

[B8]

I have added a response from SurveyMonkey and from power automate I getting the response details in CSV format now I have to add that response in my CSV file which is stored in OneDrive.  I have to add those response in CSV file which is in OneDrive and after that I have to Extract that response and store them SharePoint list. This all should be done BY Power automate

[Bcnewton]

Hi, did you ever get a solution?  I am also looking for a solution to this.

[RPAaccMNM]

anyone?

[Bcnewton]

I never figured that out but finally figured out how to get each and every field by id.  From that you can do anything.

[sandeep8530]

Hi,

When we get response for a survey. Do we get actual question and answer text or do we get question_id and answer_id/choice_id where we need to map to get actual question or answers 

[Bcnewton]

@sandeep8530 

I have finally figured out, once I run the first Parse JSON with all fields filled into the form, I save that info to my files and then I do a parse JSON on each and every id and manipulate them to get the info.  Took me forever to figure and is tedious, but not hard once you finally figure it out.

I have these steps for each ID.  I don't know if it is overkill but it works. 

[Bcnewton]

If you need what behind each piece, let me know.

[sandeep8530]

Thanks @Bcnewton  for taking time to look into it. 

when question is of multiple choice do you get exact value which was chosen or it gives choice_id or answer_id

[Bcnewton]

Yes @sandeep8530 ,

You only need the main id. NOT the individual choice id.  It will supply the correct answer.   Here is an example of what you get in your body of your first JSON.  Use the very first one.

{
"id": "151886435",
"answers": [
{
"choice_id": "1118194085",
"simple_text": "Drinking Water"
}
],
"family": "single_choice",
"subtype": "vertical",
"heading": "Nature of the complaint affecting you?"
}

[Bcnewton]

Here is what I do on the rest of the step after getting the JSON of the ID.. 

_________________________________________________________________________________________________________

xpath(xml(json(concat('{"root":', body('Parse_Nature_of_Complaint'), '}'))), '//simple_text/text()')

_________________________________________________________________________________________________________

string(outputs('Compose_Nature_of_Complaint'))

 ________________________________________________________________________________________

replace(replace(replace(replace(outputs('Compose_String_Nature_of_Complaint'),'[',''),']',' '),'"', ' '),',', '<br>')

I hope this is helpful. Like I said, I don't know if I do overkill, but I get the answers I hwant looking exactly as I want.

[sandeep8530]

Perfect! I got what I am looking for.

Thanks a lot for looking into it!!