Why is this expression with brackets not working?

(1) Share

Report

Posted on by Alex2

Hey!

Why is this not working as an expression inside a add new row to list element in excel>

if(contains(outputs('Get_response_details')?['body/rf4c88f4b0d444f5d9549221ffd7b4c60'],'Freight brokerage (awards freight to carriers on the client's behalf)'),'x','')
 
but this is working 
 
if(contains(outputs('Get_response_details')?['body/rf4c88f4b0d444f5d9549221ffd7b4c60'],'Freight brokerage'),'x','')

why can't I put in the string with the brackets? How can I fix this?

Thanks!

Alex

Categories:

Building flows

All responses (1)

Answers (0)

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi it happens because due to a single quote at the highlighted point

To resolve this - try this expression , i have replaced ' in client's to like client''s

if(contains(outputs('Get_response_details')?['body/rf4c88f4b0d444f5d9549221ffd7b4c60'],'Freight brokerage (awards freight to carriers on the client''s behalf)'),'x','')

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!