nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How Can I Prevent My Workflow From Failing When a Company Has No PDR Data?

Lizbhernan

Salary Employee Audit WF 06.11.26.yxmd

Hello Community,

I am working on a workflow that can be separated into different cycles and enabled/disabled depending on which cycle needs to be run. However, I am running into an issue where not every company will have Punch Detail (PDR) data available for each cycle, causing the workflow to fail.

Does anyone have any suggestions on how to prevent the workflow from failing when a company is not present in the data?

For example, Cycle B includes 11 companies, but not all 11 companies will necessarily have information to report during every run. If a company has no data available, I would like the workflow to automatically skip that company and continue processing the remaining companies successfully.

I have attached a screenshot of my workflow and would greatly appreciate any guidance or best practices you can share.

Thank you in advance for your help!

Workflow

Input

Transformation

Help

Accepted answers

OllieClarke

@dougperez
There's a FileExists() function which checks to see if a file exists. You can then filter out the imagined filepaths before the dynamic input No macro needed :)

All comments

dougperez

Hello Liz!

Can you attach some screenshot and more examples? The workflow attached is not valid (I can't open)

But I think the solution is to filter when one of the field is null…

Regards

Lizbhernan

@dougperez yes, sorry, this is what i get when a PDR is missing causing the workflow to fail. I don't think I can filter for nulls when the file is not present 😕

dougperez

You can check if the file exists before reading it on dynamic input, see the zip above, I created a macro to validate if the file exists and then run the dynamic:

help-community.zip

OllieClarke

@dougperez
There's a FileExists() function which checks to see if a file exists. You can then filter out the imagined filepaths before the dynamic input No macro needed :)

dougperez

That's a better solution!

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703