You’re offline. This is a read only version of the page.
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!
Perfect Thanks 🙂
@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.
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.
@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.
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
