Unanswered

Simple Date Business Rule

(0) Share

Report

Posted on by damian_green23

274

This is killing me and it should be simple. Error it the end date is earlier than the start date. Does anyone have a business rule already that they can snip it?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

JonDoesFlow 1,304 on at

Like (1)

Report

Hey @damian_green23

I think you only need to cater for the bottom
two conditions.

Create a new business rule from
the table you want the business rule to run on.

Drag a condition step over, choose the start date as the field, and the check is if it doesn’t contain data.

Click the New+ at the top of this condition, and then select the end date and check to see if it contains data, on the yes side add an message component and put in your message and apply it to the start date field.

Next drag another condition component under the first one and set it up much in the same way but this time choose the start date is greater than the end date.

Copy and paste the error message from the yes condition above.

Save the business rule, validate and activate.

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
Verified answer

damian_green23 274 on at

Like (0)

Report

Thanks for the inspiration. Here's the visual for what I built.

IF
Actual End Date does not contain data
THEN
Set Actual Start Date as Not Business Required
Set Actual End Date as Not Business Required
ELSE IF
Actual Start Date does not contain data
THEN
Set Actual Start Date as Business Required
ELSE IF
Actual End Date less than or equal Actual Start Date
THEN
Show the error message "Actual End Date is before the Start Date, please update." against field Actual End Date
-----
Visual in the app.
1) If actual end date is populated, then actual start date gets the * business required and you'll get the error when you try and save.

2) And if End Date is earlier than Start date, you get the other error message.

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (1)

Report

So is that working ? as you want it ?

Was this reply helpful? Yes No
JonDoesFlow 1,304 on at

Like (0)

Report

@damian_green23 if my initial response helped, can you mark it as the solution ? Thanks.

Was this reply helpful? Yes No
damian_green23 274 on at

Like (0)

Report

Your response was helpful in pointing me the right direction but since I implemented a specific rule and posted it, I marked that as the solution.

Was this reply helpful? Yes No