Process Status

Help Studio
1

Hi,

I’ve hit a wall and really need some help! :slight_smile:

I have an Excel spreadsheet that uses Power Query to grab data from another spreadsheet. I have created an automated process that does a ‘Refresh All’ on the spreadsheet, so that my spreadsheet is refreshed with the latest data every two minutes. This works really well and am super happy with it.

My problem is that, because the process can sometimes stop and the data doesn’t refresh, I need the process to write to a cell in the spreadsheet, something simple, say “Stopped”, so I know I have to restart it.

Is this possible? If so, how would I do it?

Thanks :slight_smile:

2

@paulparkes

Do you mean when it stops it throws error?

If so use a try catch …and in the catch block you can use a write cell activity to write whatever you need

Cheers

3

Hi,

Awesome, thank you! I’ll try that :slight_smile:

I use the Assistant to run the process. If I hit the Stop button on the Assistant, would a try catch do the same thing and write to the cell to tell other users that the process had stopped, or does the try catch only relate to errors?

4

@paulparkes

Try catch only relates to error

And not to the stop button on assistant

Cheers

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.