I am trying to take the output from a Form response and create an array or object that I can then loop through and do a find and replace so that I can update an HTML template file with the answers that someone submitted.
If I view the output from a compose on the form get response details I see
{
"responder": "joe@abc.com",
"submitDate": "10/15/2019 3:25:48 PM",
"rd150a2c9a12f42c683dcfabec7f32a52": "Jim",
"r6d253b9398c14d4f853d8c0df68d0857": "Bob",
"r9c2da6f89bf74338b7395d49a99fe5ac": "jbob@gmail.com",
"r99e5c06a5a1e4d179907101b6aaf53cd": "Calgary",
"r717f9de19e0f44ab8a3fe7a3bb6b8e20": "",
"rd8629ebb96a0487cb1e703adc805f048": "ABC Corp"
}
I can then do a Select to map the fields that I want to the find text like this
[
{
"{FirstName}": "Jim",
"{LastName}": "Bob",
"{Email}": "jbob@gmail.com",
}
]
I would like to convert this to something that I can then use an "Apply to each" and take and loop through
each element and replace the string in the "{}" with the second string after the ":" in my HTML string
If I take an initialized hardcoded object variable of this and pass it to the "Apply to each" I can get
it to work. Is there a way to convert my Select above to get something similar to below
{
"fields": [
{"Name": "{FirstName}",
"Value": "Jim"},
{"Name": "{LastName}",
"Value": "Bob"},
{"Name": "{Email}",
"Value": "jbob@gmailcom"}
]
}
Any suggestions would be greatly appreciated.
