Handle missing values and consolidate errors in one go with specified reason

What is the best approach to read sheet inside different sections and find missing values.

If there are multiple missing values then consolidate missing value in one go so that it is easy for stakeholders to find what are the missing values.

I have used multiple statements during processing of sheet

but it seems that only one section of missing values are notified at a time.

You could, for example, store your errors in a list.

Initialise a new list like so:

Then, in all of your various statements and checks, if an error occurs, just add the error to your list using the Add to Collection activity:

Then after all your checks are complete, the list will contain all your errors and you can take whatever action is required.

e.g. this would just log them as an error message.

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