Answered

Condition in DataCardValue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have two date fields that are dependent.

I need to create a condition in which DataCardvalue2 can only be filled if the value is greater than or equal to DataCardvalue1.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

What you need to do if to give notification to the user like:

If(DataCardvalue1.SelectedDate>
DataCardvalue2.SelectedDate, Notify "StartDate should be equal or less Then EndDate")

Or you can highlight the date, so in the fill of the date;
If(DataCardvalue1.SelectedDate>
DataCardvalue2.SelectedDate,Red,White)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

it worked, Thank you!

But, another doubt, can I prevent the person from being able to save the form if the field is filled in wrong?

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

You can put the question in a new post. But explain further what you meant by "if the field is filled in wrong?" Give example
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

For example : If I fill in DataCardValue2 with a date value less than DataCardValue1, I get the notification that the date value must be greater than or equal to DataCardValue1, but I can save the form in the same way, even if the date value is incorrect.

And I would not like it to be saved with the wrong date value, but rather that it would not allow saving.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

On the Onselect of the save button, you can use the same formula
If(DataCardvalue1.SelectedDate>
DataCardvalue2.SelectedDate, Notify ("StartDate should be equal or less Then EndDate"),SubmitForm(YourformName)

Replace SubmitForm(YourformName) with Patch formula if using patch

Thus if the criteria if not met, the form will not be saved.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have a problem now, because the dates do not need to be filled in to be submitted, they just need to be filled in correctly, but if the field is empty, I should submit it.
Ah any possibility of submitting these dates if the field is empty?

Was this reply helpful? Yes No