The expression is invalid when trying to convert Microsoft Forms response to Boolean

(0) Share

Report

Posted on by DorienM

Hi All,

I am trying to take a microsoft form response and record it in dataverse (NOT a SP list). Part of this involves taking a response to a question and converting it into a boolean that can be accepted by a dataverse yes/no field.

The forms question looks something like this:

Bathroom Cleanliness:

1. OK

2. Not OK

I need to convert this response into the true/false that dataverse will read. To accomplish this I am trying this function:

if(equals(outputs('Get_response_details')?['body/r00184bd4d501404eb9c9ef7ccb20fb1a'], "Not OK"),false,true)

Unfortunately I get the browser alert that says "The expression is invalid". For the life of me I cannot figure out why, can anyone help?

I have the same question (0)

All responses (1)

Answers (0)

ScottShearer 25,240 Most Valuable Professional on at

Like (0)

Report

Re: The expression is invalid when trying to convert Microsoft Forms response to Boolean

@DorienM

You have double quotes around Not OK - change them to single quotes.

Was this reply helpful? Yes No