web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate concat adding double q...

Power Automate

Answered

concat adding double quotes is adding backslash that makes xpath statement invalid

(0) Share

Report

Report

Posted on by PaulHancock

9

when item()[]ParentPosition] is 1.1 below works:

xpath(outputs('Compose-XML'),concat('//array[Item = ',item()['ParentPosition'],']/PartNumber/text()'))?[0]

when item()[]ParentPosition] is is 1.1.1 it does not. I think 1.1.1 requires ". e.g "1.1.1"

Tried below:

concat('//array[Item/text() = ','"', item()['ParentPosition'] ,'"', ']/PartNumber/text()')

returns

//array[Item/text() = \"1.1.1\"]/PartNumber/text()

how do I remove the \ from \"1.1.1\" so that I have "1.1.1".

wrapping with replace does not work e.g. replace( above, '\','')

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Are you able to provide some of the initial JSON or XML you are working with? What you are storing in:

outputs('Compose-XML')

I think it will always show \" as it needs to escape the double quotes. You can try the following instead to give you single quotes.

concat('//array[Item/text() = ''', item()['ParentPosition'] , ''']/PartNumber/text()')

Was this reply helpful? Yes No
Wendy_Lumsden 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @PaulHancock - did you resolve this issue?

I am have exactly the same problem, since I am querying an xml with a string id .... which needs double inverted comma's and keep getting errors because power automate adds a backslash before the inverted comma's, which I also tried to remove with replace.... to no avail.

Any help much appreciated.

Was this reply helpful? Yes No

Join the conversation