web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Bulk update newly adde...
Power Apps
Answered

Bulk update newly added sharepoint column

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    155,463 Most Valuable Professional on at

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard