Answered

Removing '{}' in multiple choice answers - even when the question is not filled in owing to the branching in MSFORMS

(0) Share

Report

Posted on by clarkyb

Hi a quick question I am stuck on

I have multiple choice answers and I use join(json(outputs('Get_response_details')?['body/r200a521530d34a3a9d833ec47cfc6c32']), decodeUriComponent('%0D%0A')) and I drop it into the populate a ms word field to remove the '[]' and seperate the selected answers. This works all well and good when the answer is populated. However when the form question is branched off (therefore not completed). I keep getting a null error. Is there something I can change on the join to rectify this?

Any help would be great thanks

Categories:

Building flows

All responses (3)

Answers (2)

Sort by

Verified answer

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @clarkyb,

You can check if the array is empty first. If that is false you can use your join expression.

if(empty(json(outputs('Get_response_details')?['body/r200a521530d34a3a9d833ec47cfc6c32'])), null, join(json(outputs('Get_response_details')?['body/r200a521530d34a3a9d833ec47cfc6c32']), decodeUriComponent('%0D%0A')))
clarkyb on at

Like
a
(0)

Report
Copy link

Link copied!

Have I messed up? I cant get it to work? Thanks
Verified answer

clarkyb on at

Like
a
(1)

Report
Copy link

Link copied!

sorry ignore last post .... it has worked!! Thanks so much!