I have branching MS Form. I need response from Q4 OR Q5 to map to single column in SP list.

(1) Share

Report

Posted on by eli-g

Hello,

I have a branch in my MS form. I need the answer to question 4 OR question 5 to populate to a single column on a Sharepoint list. I cannot figure the expression. The ones I've tried are below.

or(equals(body('Get_response_details')?['r005116349d424f0097fd8e36806a67d6'], 'true'), equals(body('Get_response_details')?['r40193135c51f4b79a74d7dc645e3a6e2'], 'true')

or(equals(body('Get_response_details')?['r005116349d424f0097fd8e36806a67d6'], 'response value in form (i.e. a person's name'), equals(body('Get_response_details')?['r40193135c51f4b79a74d7dc645e3a6e2'], 'response value in form (i.e. a person's name')

***These are successful but returns either "True" or "False" in the column. I need the actual response.

Other variation

or(equals(outputs('Get_response_details')?['body/responses/4ba29520b66249c99a2a2bec0d4a3f69'], true), equals(outputs('Question_response')?['body/responses/r20a5e3a23d8d4a41bd8b760ee0a1b7c0'], true), equals(outputs('Question_response')?['body/responses/raa663146608e412fba67b5bd56c70a33'], true))

How do I get the actual response output from either Q4 OR Q5 to populate in the column?

Many thanks,

Elizabeth

ms forms logo.htm

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

David_MA 14,624 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The coalesce function in Power Automate is used to return the first non-null value from a list of parameters. When you use coalesce on a value in the dynamic content, it will check each value in the list you provide and return the first one that is not null.

For example, if you have the following expression: coalesce(body('Get_response_details')?['r40193135c51f4b79a74d7dc645e3a6e2'], body('Get_response_details')?['r005116349d424f0097fd8e36806a67d6'], 'default')

If body('Get_response_details')?['r40193135c51f4b79a74d7dc645e3a6e2'] is null, it will check body('Get_response_details')?['r005116349d424f0097fd8e36806a67d6']. If body('Get_response_details')?['r005116349d424f0097fd8e36806a67d6'] is also null, it will return 'default'. Essentially, it provides a fallback mechanism to ensure that you always get a non-null value, even if some of the values in your list are null.

Was this reply helpful? Yes No
eli-g 29 on at

Like (0)

Report
Copy link

Link copied!

@David_MA thanks for these details.

the flow is successful but it is not returning the value.

The response details are as follows:

"r005116349d424f0097fd8e36806a67d6": "Mr. Davis",
"r40193135c51f4b79a74d7dc645e3a6e2": "",

The create item is null?:

"item/RSM": ""

Any thoughts on how to get 'Mr. Davis' created as the item in the SP list?

Thx

Elizabeth

Was this reply helpful? Yes No
David_MA 14,624 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please show the expression you are using and the configuration of your flow action. I cannot explain why you are getting the result you are without knowing what you are doing.

Was this reply helpful? Yes No
eli-g 29 on at

Like (0)

Report
Copy link

Link copied!

@David_MA I realize coalesce isn't going to work b/c I don't have "null" values. They are blank values in the other question response keys. I am going to use a switch in my flow instead :)

thank you!!

Was this reply helpful? Yes No