Share
Report
678I 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?
All responses (
Answers (
