Share
Report
2Hello,
I want to create an exam in jotform that will be automatically graded in power automate. For this, I need to analyze the responses.
So far, the flow looks like this:
This is what I get from the trigger for task one.
<p><table><tbody><tr><td><b>Bitte auswählen</b>: </td><td>Schulentwicklung</td></tr><tr><td><b>Bitte auswählen</b>: </td><td>Unterricht und Erziehung</td></tr><tr><td><b>Bitte auswählen</b>: </td><td>Kooperation</td></tr><tr><td><b>Bitte auswählen</b>: </td><td>Organisation</td></tr></tbody></table></p>
The headers are always the same (which is what jotform gives me). So I use this code in a compose action to create an array
replace(
replace(
replace(triggerOutputs()?['body/04 - input12'],
'<table><tbody><tr><td><b>Bitte auswählen</b>: </td><td>',
'["'),
'</td></tr></tbody></table>',
'"]'),
'</td></tr><tr><td><b>Bitte auswählen</b>: </td><td>'
,'","')
This gives me the following output:
[
"Schulentwicklung",
"Unterricht und Erziehung",
"Kooperation",
"Organisation"
]
In a Select action I would like to map this to
A1_1
A1_2
A1_3
A1_4
using this code (changing the 0 to 1,2,3 as I progress through the lines)
split(outputs('Antworten_A1'),',')[0]
However, I get the error that the action requires an array.
If I use the json function around the replace functions, I get an error that the action expects a string.
The end goal is to write all the answers in a SP-list and compare them to the correct answers so I can give feedback to the students for each task and give the teachers an overview over the answers.
All responses (
Answers (
