Hello everyone,
I need help with a Power Automate flow. I accidentally changed the text type of a column in SharePoint, and now over 8,000 records have the following corrupted HTML text format:
div<div><div><p><span style="font-size:11pt">...
I've tried creating a manual flow to correct this column for each record. The flow I designed is as follows:
1. Trigger: "Manually trigger a flow"
2. Action: "Compose" (or a similar action to process the text)
My goal is to use an expression to decode this text and update the column, but the expression doesn't work. I've tried the following in the Compose action input:
decodeUriComponent(decodeUriComponent(triggerBody()['text']))
And also a series of nested replace functions:
replace(replace(replace(replace(triggerBody()?['text'],'&amp;','&'), '&','&'), '<','<'), '>','>'), '"','"')
In both cases, the flow output is the same corrupted text input, indicating that the expression isn't being applied correctly.
Is there a way to decode this type of text in Power Automate to fix my 8,000 records in bulk? Any guidance or an example flow would be greatly appreciated. :(
