Answered

Update every record in Sharepoint list

Like (0) Share

Report

Posted on 13 Feb 2024 00:15:13 by Community Power Pla...

I need to modify every record in a Sharepoint list to ensure a text column is lowercase. I think I would create a flow and Get Items from the list and then For each modify the column, I'm not sure how to do the actual modify and write back.

There are about 1,000 records, so I'm think a flow would be the quickest/easiest way to do this. Can someone help?

I have the same question (0)

All responses (7)

Answers (2)

CFernandes 8,396 Most Valuable Professional on 13 Feb 2024 at 15:28:41

Like (0)

Report

Re: Update every record in Sharepoint list

@Anonymous - I am glad that, I could help 🙂

Was this reply helpful? Yes No
Community Power Pla... on 13 Feb 2024 at 15:26:42

Like (0)

Report

Re: Update every record in Sharepoint list

thanks!

Was this reply helpful? Yes No
Verified answer

CFernandes 8,396 Most Valuable Professional on 13 Feb 2024 at 13:55:57

Like (0)

Report

Re: Update every record in Sharepoint list

@Anonymous - Set pagination to 5000 on and set max records there.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Community Power Pla... on 13 Feb 2024 at 13:52:45

Like (0)

Report

Re: Update every record in Sharepoint list

@CFernandes
I spoke too soon. While it does work, it is not processing All records...seems like only first 100 or so. How can I make it do all?

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on 13 Feb 2024 at 13:22:16

Like (0)

Report

Re: Update every record in Sharepoint list

@Anonymous I am glad that you have a working solution 😊

Was this reply helpful? Yes No
Community Power Pla... on 13 Feb 2024 at 13:07:54

Like (0)

Report

Re: Update every record in Sharepoint list

@CFernandes thanks. I got it to work. Messed it up first, but redid it and it seems to have worked.

Was this reply helpful? Yes No
Verified answer

CFernandes 8,396 Most Valuable Professional on 13 Feb 2024 at 06:21:25

Like (0)

Report

Re: Update every record in Sharepoint list

Hey @Anonymous - You can for sure update items in the list...

For each you can increase the concurrency...

Update items -

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No