Go to next to if

Hello,

I have a flow that has multiple Excel output files/sheets. I want to update some of the files 3 times a day, others daily and some weekly. Is there an easy way to skip some of the output tools depending on the day and time?

Example: If sunday, output the weekly report to excel

If any day between 10:30 and 10:45, run the daily report?

Thanks

Developer Tools

Accepted answers

Kenda

Could you add a Formula tool that checks your date conditions versus DateTimeNow() then use Detour tools to determine if output will get written or not?

All comments

MarqueeCrew

If you don't mind a temp file being written, you can create a formula to write the proper file name when you want it and use a temp file name to write to (e.g. .\trash.xlsx) when you don't want it.

Kenda

Could you add a Formula tool that checks your date conditions versus DateTimeNow() then use Detour tools to determine if output will get written or not?

FMG

I am not familiar with the Detour tool, but I think it could work with the tool DateTimeNow and filters. Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703