Data Validation for user inputs

hemant86

Good Day All,

I'm looking for a tool for Validation of column and show appropriate message to user for the validation. For example

1. Col A to Col L should be blank if not throw a message to user saying the same its not blank.

2. Col M should not be future date and always be current date if not throw a message to user saying the same

And workflow should not proceed until the conditions are satisfied

Thanks in advance!!

Common Use Cases

Accepted answers

atcodedog05

Hi @hemant86

You can use message tool like below to validate, throw errors and stop processing.

Workflow:

Hope this helps : )

message.yxmd

atcodedog05

Happy to help : ) @hemant86

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

atcodedog05

Hi @hemant86

In your current data date> today and make sure to configure to stop processing on error.

When I change the data they seem to work

Hope this helps : )

Book1 (4).xlsx

ACH.yxwz

All comments

atcodedog05

Hi @hemant86

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

hemant86

My input data is something like this:

Should be blank	Should be blank	Should be blank	Should not be future date
Column1	Column2	Column3	Column4	Column5	Column6
Data1			10/31/2021
			11/1/2021

I do not need any out put here. Its just the tool should check for Column1 , Column2 & Column3 for blank and if not blank it should give the user a popup message saying particular column should be blank or a range of column should be blank,

Ex. IF Column1 !="" OR Column2 !="" OR Column3 !="" Then "Column1 should be blank" (i guess we would need to use a variable to pick the column name here)

IF Column4 > Today() Then "Column4 cannot be future date"

And there is no output file produced here. I just need to validate these columns and give a popup message to the user. The output file is produced only if validation is successful. So the workflow should not proceed until validation is successful.

Not sure if I'm asking a valid question.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703