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?
@Anonymous - I am glad that, I could help 🙂
thanks!
@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.
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?
@Anonymous I am glad that you have a working solution 😊
@CFernandes thanks. I got it to work. Messed it up first, but redid it and it seems to have worked.
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.
WarrenBelz
146,587
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional