Entering a file path in the formula tool

I have a workflow that someone helped me build and have been using it for months. All of a sudden today my files won't output at all. The workflow completes with no errors but there are no output files. The output is going to multiple excel files. Here is what it looks like:

Your help is greatly appreciated!

Thank you.

Output

Accepted answers

OllieClarke

@CherieACI the data preview shows the first row of data, so if it's blank then maybe there are no rows of data passing through the formula tool (which would also explain why there's no files being output)

All comments

OllieClarke

Hey @CherieACI when you run the workflow, if you click on the output tool, what messages appear in the results window?

CherieACI

OllieClarke

@CherieACI hmmm that's weird, especially that the tool isn't erroring... Bit of a guess, but as you're writing to onedrive, is your connection up at the moment?

CherieACI

Yes, we have an identical workflow and it works fine. Question, when we use file path in the formula tool, the data path usually has something in there but this one is blank. Do you know why that would be?

The other workflow that is identical and working as a file name in it:

OllieClarke

CherieACI

With your comment about no data passing to the formula tool, we worked our way backwards and found the error. We have a filter tool that was pulling from the true and should have been from the false! So, there was no data flowing to the formula tool! We made that change and everything worked fine!

Thanks for your help!

Cherie

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703