I have a flow where I'm attempting to show the questions and answers to a survey. Both are stored in SharePoint lists.
The answers are stored in a single row, one field per response (the response is a single-valued choice).
The questions are stored one per row, with a column showing the question and a column for the field name.
So for instance the response list has a field named Risk_x0020_Physical_x0020_Enviro (the displayed name is Risk Physical Environment).
The question has a row where the Choice Field Name field has the value Risk_x0020_Physical_x0020_Enviro and the Question field is the wording of the question the responder answers.
In the flow, I need to output an HTML table of the questions and answers for a single response.
As far as I can see the expression would be something like:
@{@{body('Get_Response')}[@{items('Apply_to_each')['Field']}]}
Where the Get_Response step gets the relevant response list row and the Apply_to_each steps through the rows of the questions list.
This doesn't work though - it won't even allow me to save it.
