Answered

Update every record in Sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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
Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thanks!

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No