Hi @eric142, here is a solution for you.
After you trigger starts, pull the results by using the 'Get response details' action. Then use a Select (Data Operation).
Use the 'Switch Map to text mode' button to go into text mode.
In the 'From' input, we will convert the result JSON to XML to use it for XPath (thanks to Expiscornovus in another post). Use the string below:
xpath(xml(json(concat('{"Responses":', string(outputs('Get_response_details')?['body']), '}'))), '//Responses/*[text() = "Pass"]')
You notice at the end of the string "Pass". This is the text from the answers in the form we're searching for. This can also be "Fail" or something else if you want to filter on other words.
In the 'Map' input, you use the string below:
substring(base64ToString(item()['$content']), 1, sub(indexOf(base64ToString(item()['$content']), '>'), 1))
The output from the XPath is going to be a base64 unreadable string. This substring will extract the text in the XML node, in this case, the Question IDs. With this array, you can continue your flow, e.g., creating an email.
If you want to get the corresponding question; use the string below and replace
re9f2aefb65084fa090ff2e00da734853 with your Question IDs:
outputs('Get_response_details')?['body/re9f2aefb65084fa090ff2e00da734853']
Example of my flow when it ran.
I hope this solution is going to work for you. If so, mark this as Solved.
Thank you.
