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

(0) Share

Report

Posted on 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?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Aidan_O 8 on at

Like
a
(0)

Report
Copy link

Link copied!

That works perfectly, thank you.

Was this reply helpful? Yes No