Hey,
I believe that the approach below can help you.
For this example, I'm using the following Form, which contains a single question and the choice answers (single choice only) from A to E:
The responses must be loaded in this Excel table (from your end, the process may be a little different, since you are using a SQL table):
In Power Automate, I'm simply capturing the Form responses and loading it to the Excel table, with an expression to handle the scenario for each column:
The expressions are pretty much the same: I'm using equals(outputs('Get_response_details')?['body/r3ae835a961be4529b8971a7c84836c82'], 'A') for the a input, and just changing the text in red for the others, in order to match each character from B to E. From your end, you must also replace the text in blue for the dynamic content of the question that you want to track:
In summary, we are using the equals() expression to test if the question's answer is equal to 'A' (or to 'B', or 'C', and so on). Since the equals() expression returns a boolean output, your flow will automatically populate the marked answer as true and all of the others as false. After a few random submissions, this is the outputs in the Excel table:
Note 1: Power Automate is case sensitive, so make sure to keep the same format from your response in the equals() expression. If I used 'a' instead of 'A', it would not work.
Note 2: If the choices are not simply a single letter like in my example, you can use some text expressions to extract the letter from the selected choice. Check the content below for more details.
Knowledge base
Since you mentioned that you are new to Power Automate, I'm sharing some blogs that I wrote about topics discussed here, which can be helpful for you or anyone that finds this thread in the future:
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
