Validation from flow action, I need to make some validations

Hello,

I want to build some requirements in Flow action (validation):

  1. If you fill in the first row (date), than the second row (date) is required;
  2. The time of the second row can not be earlier than the time of the first row;
  3. If you fill in the third row (date), than the fourt row (date) is required.
  4. The time of the fourth row (date) can not be earlier than the time of the third row (date).

So I got 4 validations for my dates/rows in total, see attachment.

Hi @AhmadB16: For validating required condition, i would suggest to configure it in the Cell properties itself ( required condition → add a when rule)

For the other validation based on business logic to make sure second date is not before first date, you can use below function in the validation rule.

[First DateTime] [relation] [Second DateTime]

You can get more details about validations in system architect mission.

Please let us know if you need further assistance.

Thanks.

@ArulDevan I tried it, see screenshot. I only don’t know how to specify the Required When condition. I also tried adding refresh on change in the row/section, but didn’t work.

Hi @AhmadB16: Here is some detailed steps.

  • In the first date time, set a action to refresh section on change
  • In the second date time, add a when rule for required condition
  • Open the when rule defined as required condition for date time 2. Navigate to advanced tab. In the conditions row, you will see a small down arrow at the end. Click it and select “[property reference] has a value” condition. Select the date time 1 property in the conditions dropdown. Save the when rule.
  • Save the section rule

Hope this helps.

Thanks.

@ArulDevan I don’t know where you mean with?

Open the when rule defined as required condition for date time 2. Navigate to advanced tab. In the conditions row, you will see a small down arrow at the end.

See attachment in date time 2/row 2 I see this, see attachment.

Hi @AhmadB16: Please find the attached. It will be in the general tab of cell properties.

Thanks.

@ArulDevan thanks it worked!