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

Community site session details

Session Id : hOcwV2CoH/PbQvml07tjZz
Power Automate - Building Flows
Unanswered

Auto Incrementing a column in sharepoint document library

Like (0) ShareShare
ReportReport
Posted on 26 Mar 2021 09:48:42 by 88

Hello everyone,


I have an issue where I am stuck with auto incrementing a number in a document library.


The scenario :

I have a flow that is triggered manually that starts and approval process when a new file is uploaded(users click a button to start the flow for the file). The document library has a single line text column("Number") that is used for inputting some numbers that have a naming convention of *current year*+next available number so for example: 20210044,20210045,20210046 etc...


What I want to achieve is to populate that column automatically for the new items by grabbing the last item that was submitted (ex.20210045) and have an update function for the new item to be (20210046(last item number + 1)). What I did was concat the year with the ID but I don't want to grab the ID as its not used within the name.

I have tried numerous suggestions but alas i came to no solution. I would appreciate your input on this for a possible successful outcome for my issue :).


Thank you!

  • Power Platforms Communities Support Profile Picture
    Microsoft Employee on 26 Mar 2021 at 15:54:26
    Re: Auto Incrementing a column in sharepoint document library

    Hi,

     

    You can definitely auto populate column by grabbing the last item and update the next value from it. Please Refer to this like this seems similar scenario as yours.  

    Auto-Increment Number Field in a SharePoint List - Microsoft Tech Community

     

    Regards,

    Darshan

    -------

    Community Support Team _ Darshan Amin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2