Possible to create file with incrementing number in filename?

[sudosaurus]

Hello,

I have a PowerApp that has a run button which generates a PDF file in Power Automate.

The flow currently takes all the necessary information from the app uses an Encodian Convert HTML to PDF action followed by a Create file in OneDrive action where the filename is in this format:

BSCR-BuildingName-v1-Date.pdf

Where BuildingName is whatever building is selected in the app and a PDF is being generated for.

Currently the document version (v1) is fixed text in the filename, however we would wish this to auto increment to v2 if another file was generated for the same building.

What would be the best course of action to achieve this and considering there are several different buildings with their own names, the flow would need to check against existing file names and create new ones with a new version in the filename if "v1" or "1.0" already existed for that building. 

[v-bofeng-msft · Accepted solution]

Hi @sudosaurus ,

I've made a test for your reference:

1\

substringof('@{variables('BuildingName')}',FileLeafRef)

2\

length(outputs('Get_files_(properties_only)')?['body/value'])

3\

BSCR-@{variables('BuildingName')}-v@{add(int(split(split(last(outputs('Get_files_(properties_only)')?['body/value'])['{FilenameWithExtension}'],'-v')[1],'-')[0]),1)}-Date.pdf

Best Regards,

Bof

[WillPage]

Simplest way: Create file in an empty staging library or folder then use the Move file action with this option:

[sudosaurus]

@v-bofeng-msft thank you that worked a treat! 🙂 

[sudosaurus]

@v-bofeng-msft how can we get the versioning to go past 10? It doesn't seem to allow version 11 to be created:

BSCR-@{variables('BuildingName')}-v@{add(int(split(split(last(outputs('Get_files_(properties_only)')?['body/value'])['{FilenameWithExtension}'],'-v')[1],'-')[0]),1)}-Date.pdf

Would changing the number formatting to 01 work better?

[sudosaurus]

@v-bofeng-msft any ideas?

[v-bofeng-msft]

Hi @sudosaurus ,

Please try:

1\

int(split(split(item()['{FilenameWithExtension}'],'-v')[1],'-')[0])

2\

BSCR-@{variables('BuildingName')}-v@{add(last(body('Select'))['VNumber'],1)}-Date.pdf

Best Regards,

Bof

[sudosaurus]

Hi @v-bofeng-msft ,

I've given this a go however it's still only creating the file up to version 10 and wont roll up to version 11.

[v-bofeng-msft · Accepted solution]

Hi @sudosaurus ,

Please try:

1\

int(split(split(item()['{FilenameWithExtension}'],'-v')[1],'-')[0])

2\

BSCR-@{variables('BuildingName')}-v@{add(last(sort(body('Select'))),1)}-Date.pdf

Result:

Best Regards,
Bof

[sudosaurus]

@v-bofeng-msft - that was the solution!

Thank you so much for your help 🙂