Hi All,
Sorry for all of my questions in advance, but I haven't done this before and have zero programming knowledge with no one to ask. I found a website that helps describe how to create a Flow that will take survey data from (Qualtrics) that is then delivered to the Flow via JSON. I tried following the website, but I'm still not really clear on the details of getting this to work because I don't have programming experience. The link I used is:wxwr.medium.com/syncing-qualtrics-survey-results-to-excel-and-powerbi-using-power-automate-f0cafebeb466
It was unclear if I only add Key names in the "body" section or if I had to add the names to the "header" section as well. Also, in order to insert the "piped text" I used Qualtrics drop down option and copied that. I wasn't sure if there was a different way, but the only thing that changed were the numbers. For example in this link the name and age have different piped texts. For mine all of them were: ${q://Q!D1/ChoiceTextEntryValue}, however the number "1" changed to 2,3,4, etc., matching the question (sorry if that doesn't make sense).
After I filled in all of that information and made my Excel table and matched it with the Key names, i went to PowerAutomate. I kept reading that you can "use sample payload to generate schema," but nothing came up. In the article, it says to just copy the json and customize it based on my configured task. The article's json was simple with the Excel only showing two questions, so the Keys were just name and age:
{
“name”: “peter”,
“age” : “0-20“
}
In the photo, it's a more detailed JSON Schema. I'm confused. I tried to make my schema, based on that example and my questions, but it failed. I know it's wrong. Mine is:
{
"type": "object",
"properties":,
“Visits”: {
"type": "string"
},
"CZSmember": {
"type": "string"
},
“preferredname”: {
"type": "string"
},
"likelytoattendzoo": {
"type": "string"
},
“descriptionlikeanddislike”: {
"type": "string"
},
"appealing": {
"type": "string"
},
“agreeordisagree”: {
"type": "string"
},
"likelihoodtoattend": {
"type": "string"
},
“expensiveprice”: {
"type": "string"
},
"inexpensiveprice": {
"type": "string"
},
"considerableprice": {
"type": "string"
},
"bargainprice": {
"type": "string"
},
"comments": {
"type": "string"
},
"zipcode": {
"type": "string"
},
"gender": {
"type": "string"
},
"age": {
"type": "string"
},
"income": {
"type": "string"
},
"ethnicity": {
"type": "string"
}
I keep getting an error saying it's invalid. I tried to follow what was on the link. I'm lost on all of this. With survey data, if I have a question that is going to output qualitative data, is that going to be a string? I also have questions that asks quantitative data, but the response options are a mixture of words and numbers. For example, if I ask, "what is your pre-tax income for your entire household for last year?" and my responses are "under $25k, $25k-$49k, $50k-$74k, etc. and the last option is "I prefer not to say" is that going to still be numeric or will it be string?
Also, for a demographic question asking someone to choose their ethnicity with the last option being Other:______ (this is a fill in), is this also a string variable? Again, sorry for all of the questions. I am completely lost, and I don't have IT support at the moment.
Any help would be awesome!
Thanks!
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2