Retain or pass on values between scheduled flow runs

Ask a question
1

Hi,

Is there a way to pass on a value, like an index counter or a last-run time stamp, from 1 flow to the next scheduled run of that same flow?

Thanks,
Alderik

2

Hey @Alderik_Manuputty :wave:

Try using the Insert date & time column step towards the end of your flow and export it to Google Sheets using the Send to Google Sheets step.

Each time you run your flow, a new timestamp will be exported.

To pull in the timestamp from your last run, use a Pull from Google Sheets step towards the start of your flow.

Here’s a mocked out version of this flow:

image
image1920×943 45.4 KB

Note: I am using Insert text column steps to create a shared column to merge the timestamp back in with the source data.

Let me know if this helps!

2 Likes
3

Thanks Daniel, much appreciate the response. I will try this and let you know the results!

~WRD0441.jpg

4

Hi Daniel, this works. very elegantly.
It worked this out in Google Sheets first and succeeded.
I then had to rewrite it to work with Box. This was a breeze as well since the files save as csv automatically and are read as such as well.

3 Likes