cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

Help with special characters in a string.

Hello 

        I need some help with how to format my expression to be able to use special characters. As currently it is breaking the flow.

My current expression is as follows

trim(substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'Requestor's Agency'),46),sub(lastIndexOf(body('Html_to_text'),'* Agency Approver Title'),add(indexOf(body('Html_to_text'),'Requestor's Agency'),46))))
Unfortunatly because the word " Requestor's " has a ' in it, it breaks the expression and i get failure in flow. 
Can someone explain how this needs to be formatted to work.
 
Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
Responsive Resident
Responsive Resident

Hello @stephenJames ,

 

Flow uses ' to define different strings.

 

Try this

 

 

'Requestor''s Agency'

 

 

 

 

2.jpg1.jpg

View solution in original post

2 REPLIES 2
Responsive Resident
Responsive Resident

Hello @stephenJames ,

 

Flow uses ' to define different strings.

 

Try this

 

 

'Requestor''s Agency'

 

 

 

 

2.jpg1.jpg

View solution in original post


@FoDelement wrote:

Hello @stephenJames ,

 

Flow uses ' to define different strings.

 

Try this

 

 

'Requestor''s Agency'

 

 

 

 

2.jpg1.jpg


Thanks @FoDelement  that worked perfectly 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,877)