I realised I missed the Accepted property from the source data. I have updated the solution with the Accepted property. Please try: Solved: Re: Format into proper JSON structure - Power Platform Community (microsoft.com)
to see if that resolves your issue.
Here is an extract:
The expressions used are:
1: items('Apply_to_each')?['formResponse']?['answers']
2: item()?['question~']?['name']
3: item()?['answerDetails']?['com.linkedin.ads.TextQuestionAnswer']?['answer']
4: items('Apply_to_each')?['formResponse']?['consentResponses']?[0]?['accepted']
This is the data that I was able to extract:
[
{
"First Name": "Ghoghe",
"Last Name": "Manta",
"Email Address": "ar1975@gmail.com",
"Company Name": "TAXI SPEED",
"Country": "Romania",
"Job Title": "Taxi Driver",
"Accepted": false
},
{
"First Name": "alxandra",
"Last Name": "petror",
"Email Address": "perr@gmail.com",
"Company Name": "opica",
"Country": "Romania",
"Job Title": "Sales Consultant",
"Accepted": false
},
{
"First Name": "Anda",
"Last Name": "Ros",
"Email Address": "andreamsu@gmail.com",
"Company Name": "DWF - Genuine SEO Agency",
"Country": "Romania",
"Job Title": "SEO Project Manager",
"Accepted": false
},
{
"First Name": "Gabriel",
"Last Name": "Pastrav",
"Email Address": "gabrielv@gmail.com",
"Company Name": "goldenfishromania",
"Country": "Romania",
"Job Title": "Owner",
"Accepted": false
},
{
"First Name": "Catalin",
"Last Name": "Bejan",
"Email Address": "cbn@outlook.com",
"Company Name": "Forston Development",
"Country": "Romania",
"Job Title": "Business Development Manager",
"Accepted": true
},
{
"First Name": "Cristina",
"Last Name": "Cristescu",
"Email Address": "cristin@yahoo.com",
"Company Name": "Witfuse Solutions",
"Country": "Romania",
"Job Title": "Executive Coach",
"Accepted": false
}
]
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
