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 : SSmvOGRscdHOJGcG0g0evv
Power Automate - Building Flows
Unanswered

Numbering Sharepoint Files Sequentially

Like (0) ShareShare
ReportReport
Posted on 21 Oct 2022 11:22:38 by 199

I have a flow that is creating a new file in Sharepoint for the "Submittal Transmitall process". We work on multiple jobs and each job has several Submittal Transmitalls. Each transmitall is numbered with the job number (ex. 22-109), followed by the number of the transmitall in a sequence for each job. So for instance, in the folder you can expect to find the following file names: 22-108-01, 22-108-02, 22-110-01, etc.

 

I am looking to create a series of actions in power automate that will automatically name the flow based on the job number and then the sequential numbered transmitall for that job. The job number is a dynamic element from Powerapps. 

 

It seems like I should create an if statement that first asks if a transmittal that begins with that job number exists in the folder, if it does then name the file the next sequential number, if it doesn't then create a file named "Job No - 01".

 

I was planning on slipping this action in the flow where I'm showing "Choose an operation". Then I can take the output of this operation and use it in the file name of the Create File operation.

Screenshot 2022-10-21 072144.png

  • rbergan Profile Picture
    199 on 21 Oct 2022 at 19:03:54
    Re: Numbering Sharepoint Files Sequentially

    While working on this problem, I decided to add a Sharepoint column for the Job No and for the Transmittal No. This way I can filter for the current Job No. How do I return the latest (max) Transmittal No?

     

    I'm using Get Files (properties only) which always creates an "Apply to Each" situation which complicates everything else down the line. 

     

    I'm looking to create a flow that look to see if there is a file in the folder that has the same job number, if yes, then add 1 to the last transmittal no., if no then the transmittal no. for the new file will be "1".

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete