Announcements
I have two arrays where the property name on one matches a value in the other. I am trying to replace the property name in the first array with a matching value from the second.
The first array is the output of an inspection checklist. Each property is the unique ID of a question and the value is the response to that question. Here is a sample output:
Are you talking about setting the questions as property names?
I would not walk that dark path 😉
What is your goal?
Maybe we can find a better way.
Thanks for your reply! The end goal is to produce a document (probably a PDF) that shows the questions and the responses to the questions in a table format. But rather than, for example, the document listing "QB000011" as the question that was answered I would like it to display the actual words from that question. In the case of QB000011 we would want it to read "Was site safety orientation provided?" in the final product. However, the checklist results (the answers to the questions) are maintained in a table where it only shows the question ID and not the actual question itself. So I am trying to "merge" the data. If there is a better/easier way to do that I'm all ears!
Sorry, realized I replied to the post and not to you (still learning to use this forum):
Hi @aevans16 ,
I would agree with @Chriddle and not use the question text as the Key. The following data structure could fit your needs:
[ { "Question": "Are there any hazards from nearby plant or machinery?", "Answer": "No" }, { "Question": "Was site safety orientation provided?", "Answer": "Yes" }, { "Question": "Were emergency procedures reviewed?", "Answer": "Yes" }, { "Question": "Is the location of emergency equipment known?", "Answer": "Yes" }, { "Question": "Do you know how to report an emergency/accident?", "Answer": "Yes" }, { "Question": "Overall site conditions?", "Answer": "Good" }, { "Question": "Is a site escort required?", "Answer": "No" }, { "Question": "Is your PPE inspected and in good condition?", "Answer": "No" } ]
Ellis
Sorry, I should have clarified that I did not structure this data nor do I really have control over how it is structured. This is coming from a third-party platform that we do not manage. I totally agree that I would probably have structured things differently.
The structure that you are suggesting though is exactly the output I need though. Do we think it is possible to manipulate the two separate arrays into that?
It could be done like this:
json(slice(string(outputs('Compose_1')),1,-1))
The expression in the Compose action produces the following JSON object:
In the Select action below, we will use the JSON object to lookup the Answer when we provide a Question ID:
The expressions uses are:
Question: item()?['Question'] Answer: outputs('Compose_Object')?[item()?['Question ID']]
Finally we remove questions with no answers (i.e. Answers that have null or empty values):
The expressions for the Filter array action are:
item()?['Answer']
The Filter array action produces the following array of JSON objects:
Ellis____________________________________If I have answered your question, please mark the post as ☑️ Solved.If you like my response, please give it a Thumbs Up.My Blog Site
Success! Thank you so much!
Why are you using this "hack"
when you (probably) want to do this
first(outputs('Compose_1'))
Is it just a holdover from the days before functions like first() existed, or is there another purpose behind it?
Hi @Chriddle ,
Yes, I agree that's an easier and better way to do it.
Many times I use string manipulation to change data, may be I've become a bot? 😉
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 276 Super User 2026 Season 1
11manish 169
Haque 154
