web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Bypass xml special cha...
Power Automate
Unanswered

Bypass xml special characters -

(0) ShareShare
ReportReport
Posted on by 678

I have a Power App that is patching a SP List.
Users can trigger a flow and that's where the issue occurs. No issue inside the Power App itself and I believe it pertains to special characters in XML + the carriable return.
I could solve this within the Power App and remove the > < " ' & as well as the carriage return using the substitute function on multiple text fields. It's not broken in the Power App piece though. 
Or in Power Automate I do a GetItems pull (ok), then convert to a json array (ok) and then convert to xml (which is where this all fails).
As the issue is specific to the xml conversion... and it applies to multiple properties where would you put the fix of either replace or substitute and can I put it the substitute or replace within an xpath lookup?
I'm doing a select action and the issue is with the text value of Responsibility (and other vars)

xpath(outputs('XMLRegulations'),concat('//Array[ID/text()="', item()['ID'],'"]/Responsibility/text()'))?[0]

I don't want to do a loop (as that would slow things down).
Thoughts?
 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard