Irish Last Name with Apostrophe causing flow to fail

(0) Share

Report

Posted on by KassieH

The RegistrantNameText is a string from 'x-ms-user-name-encoded'

This works perfectly until we have a name with an Apostrophe.

Error:

The expression "RegistrantNameText eq 'O'Bryan, Al' and Course_x0020_ID eq 67" is not valid. Creating query failed.
clientRequestId: 1bda0327-d87d-4938-ac42-1f9ec77b4014
serviceRequestId: 1bda0327-d87d-4938-ac42-1f9ec77b4014

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,406 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @KassieH,

I assume you have added it as expression to the RegistrantNameText string variable and not as plain text?

And what trigger action are you using? I tested it with the Manually trigger a flow action.

Was this reply helpful? Yes No
KassieH on at

Like (0)

Report
Copy link

Link copied!

That did not work. It only imported the whole thing over in the string.

The expression "RegistrantNameText eq 'replace(base64ToString(O'Bryan, Al), '''', '''''')' and Course_x0020_ID eq 67" is not valid. Creating query failed.
clientRequestId: 854c96cb-29d4-4eaf-be8a-7c777be37fcd
serviceRequestId: 854c96cb-29d4-4eaf-be8a-7c777be37fcd

Was this reply helpful? Yes No
Expiscornovus 33,406 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @KassieH,

You need to escape that apostrophe by using another apostrophe. The below should be valid

RegistrantNameText eq 'O''Bryan, Al' and Course_x0020_ID eq 67

In your setup you could use the following expression in your variable:

replace(base64ToString(triggerOutputs()['headers']['x-ms-user-name-encoded']), '''', '''''')

Was this reply helpful? Yes No