Unanswered

Increment a variable each time an automated flow is run

(0) Share

Report

Posted on by Community Power Pla...

I'm making a flow that saves each new email attachment that comes into a shared mailbox by a new name in sharepoint that includes a number that increases by 1 each time a new file is created. I'm looking for a suggestion on how to do this. I was originally going to get a number from a cell in an excel table, add it to the file name, and then increment it up one and update the excel cell with the new number but I can't figure out how to do that. Thanks!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Anonymous

There are a few ways to go about this. Since you're already using SharePoint, why not just create a custom SharePoint list. Add a number column to the list - call it something like NextNumber. The list will only have one row of data. Use a SharePoint Get Items action to retrieve that row and the number. Then, update the SharePoint list incrementing the number by 1. Using a SharePoint list will allow you to avoid issues that sometimes take place when updating Excel files.

As I said, there are a number of ways to go about this...

If you need an example, please let me know.

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

Like (0)

Report

Thanks @ScottShearer

Could you provide an example? I am having trouble capturing the number in the list as a dynamic value so I can initialize a variable.

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (3)

Report

@Anonymous

See my example below. You can refer to the variable when renaming the file. I could have made this a bit more elegant with the use of expressions, but I tried to keep it as simple as possible.

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

Like (0)

Report

Perfect Thanks 🙂

Was this reply helpful? Yes No