web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Bulk update newly adde...

Power Apps

Answered

Bulk update newly added sharepoint column

(0) Share

Report

Report

Posted on by NicoleHudon

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

Does anyone know how I can bulk update the field for all 2000 rows

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 155,307 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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

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

Was this reply helpful? Yes No

Join the conversation