Hi,
I am getting a value from the SharePoint Online list using Get List Items. SPO list contains Multi line of text column(Enhanced Rich Text). Power Automate retrives the values like below ,
"<div class=\"ExternalClass4DA66774E610459BA141CB6AA38B95F6\">
<div class=\"ExternalClass6A637355CC7D4B068DAACE1B581E3E90\" style=\"font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);\">
<span style=\"color:black;\">​</span><br>
</div>
<div class=\"ExternalClass6A637355CC7D4B068DAACE1B581E3E90\">​Test College Development<p>Attn: Kel Green<br></p>3278 Burton St. SE<br>Grand , MI  11111<br>
</div>
</div>"
I wanted to retrieve only the highlighted value (including the <br>,<p> tag) , Is there any expression that we can use in Power Automate. Please Advise on this !
Note: I am not allowed to change the column type in SPO list (Rich text to Plain text)
thanks.


Report
All responses (
Answers (