This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow that would run a series of data validations and then output the rows that failed each validation to a separate tab in an Excel report. The workflow for each check is similar, I filter on the rows that failed the check, and then select the relevant fields that related to that check (will be different for each check), add a "TabName" field that equals to the name of the check, and then output the Tab to the excel file. The problem with this is that I have over 100 data validations that I have to run, so I have to manually create each workflow, which is also opening the workflows up for errors.
I wonder if its possible to make a excel sheet with 2 fields, Check_Name and Selected_ Fields like this
and then have build an macro to parse through the excel spreadsheet to replicate the workflow?