Populate a Microsoft word template based on Form responses where there are multiple answers for a question

Like (0) Share

Report

Posted on 24 Jul 2023 11:52:36 by Aidan_O

Hi, looking for a small bit of help, please.

I'm populating a Word document using Power Automate when a response is submitted to a form.

Most of the questions are yes/no answers, and one of them will pull through some text. An example expression is:

if(equals(outputs('Get_response_details')?['body/r3be654137aae4fde8510a4bb370f4523'],'Yes'),'We would recommend the preparation of a shareholder’s agreement.','')

The problem I'm having is where a questions can have multiple answers e.g. A/B/C where any number of the three can be selected: A, A and B, B and C etc

I tried putting an expression in for each answer, but nothing is coming through. If I turn multiple answers off, it works, but then I can only get one text answer, when I want it to also be able to do two or three

How can I pull through the three different bits of text depending on the different amount of answers?

All responses (2)

Answers (1)

Aidan_O 8 on 25 Jul 2023 at 08:44:21

Like (0)

Report

Re: Populate a Microsoft word template based on Form responses where there are multiple answers for a question

That works perfectly, thank you.
Verified answer

v-xiaochen-msft on 25 Jul 2023 at 02:05:36

Like (1)

Report

Re: Populate a Microsoft word template based on Form responses where there are multiple answers for a question

Hi @Aidan_O ,

Please try to use contains instead of using equals, something like:

if(contains(outputs('Get_response_details')?['body/r3be654137aae4fde8510a4bb370f4523'],'A'),'Answer for A','')

if(contains(outputs('Get_response_details')?['body/r3be654137aae4fde8510a4bb370f4523'],'B'),'Answer for B','')

if(contains(outputs('Get_response_details')?['body/r3be654137aae4fde8510a4bb370f4523'],'C'),'Answer for C','')

Best Regards,

Wearsky