You’re offline. This is a read only version of the page.
21
I have recently added a new field to my existing sharepoint list, which removes the html from a rich text field and makes it into a plain text field. I needed to create this new field because html to text (power automate) wouldn't strip the html and xml when I tried to use the data in Word and Excel documents.
The new field is updated with patch along with the other fields, but I need to go to each item on the list to patch each, and there are 2000 items
Staff using the site prefer rich text, but management wants reports in word or excel
Hi @NicoleHudon ,
Assuming you still have the HTML text in another field, firstly create a text field (you can delete it when finished). You also may have to run this a number of times depending on your Data Row Limit
Share
Report
All responses (
Answers (
With(
{
_Data:
Filter(
SPList,
YourNewField = Blank()
)
},
Patch(
SPList,
ForAll(
_Data As _D,
{
ID: _D.ID,
YourMultiLineField: PlainText(_D.YourRichTextField),
YourNewField: "Done"
}
)
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
