Schedule in Gallery to save in sharepoint

Hi Everyone,

Basically I have a flow that I'm going to save in the gallery, schedule it every day, and save it in sharepoint. However, its variable is the month, so I would like to know if there is a way to override it when it is the same month, and create a new folder when the month changes, for example:

I put it in schedule in month 05, it will be saved in the spreadsheet "05_2023", we will move to month 06, it will be saved in the spreadsheet "06_2023", and so on.

Thank you very much in advance.

Gallery

Scheduler

Sharepoint

Accepted answers

FrederikE

Hey @JVMORO,

True, the SharePoint tool is a bit more complicated - Here you would require a batch macro to dynamically update the path since the tool has no such built-in functionality.

Your main flow could look like this:

The top part is just the path that you want to save it to, with the dynamically updated path. The bottom part would be whatever you want to save.

The Macro then should look like this:

The Action tool is configured to update the path of your sharePoint output dynamically.

I have added the main-Workflow as an attachement - The macro is not shared, since all configurations are Computer/SharePoint specific.

New Workflow1.yxmd

All comments

FrederikE

Hey @JVMORO,

You can change the file path to where the file is written. The Folder ("5" in this case) needs to be there already.

Formula:

Output Tool:

There is a similar config with the SharePoint Output tool, if you are using this one instead.

JVMORO

Hi @FrederikE

Your answer was of great help. Do you happen to know how it would look in an example of the sharepoint path?
because the two are quite different.

FrederikE

Hey @JVMORO,

True, the SharePoint tool is a bit more complicated - Here you would require a batch macro to dynamically update the path since the tool has no such built-in functionality.

Your main flow could look like this:

The top part is just the path that you want to save it to, with the dynamically updated path. The bottom part would be whatever you want to save.

The Macro then should look like this:

The Action tool is configured to update the path of your sharePoint output dynamically.

I have added the main-Workflow as an attachement - The macro is not shared, since all configurations are Computer/SharePoint specific.

New Workflow1.yxmd

JVMORO

Thank you very much for your help, it was of great benefit!!👊

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703