Unanswered

End date greater than start date

(0) Share

Report

Posted on by Community Power Pla...

I am working on a date validation, so the user can not save the item in SharePoint if the end date is before the finish date. I have a powerapps form and a sharepoint list.

Any suggestions would be great, thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

You might want to consider disabling the "Submit/Save" button if the dates do not validate.

Set the DisplayMode property of the button to:

If(endDate < finishDate, Disabled, Edit)

Obviously this formula would need to be modified to meet your actual control names and properties.

I hope that is helpful for you.

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

Like (0)

Report

For me to use that solution, I would have to hide the save/cancel options and create buttons in wich I have no idea. Could you please show me how to do it?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

This solution does not require any additional buttons. You are simply changing the DisplayMode property of the Save button that you already have to the formula provided.

So, let's say you have a EndDate DatePicker and a FinishDate DatePicker control on your form. You can simply change the DisplayMode property of the Save button to this formula:

If(EndDate.SelectedDate < FinishDate.SelectedDate, Disabled, Edit)

Beyond that, you'll need to share more details on your date controls/datacards/or columns, and your save button details.

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

Like (0)

Report

But I do not have a Save button, I use the option that the Sharepoint form have

Was this reply helpful? Yes No
GrischkePro 287 on at

Like (0)

Report
This is what I would do.

Set button's Visibility to true or false like so:
If(EndDate > StartDate,true,false) True = show button False = hide button
If(EndDate is greater than StartDate,show Submit button, don't show Submit button)
You can also add a label and set its visibility to true if the above is false. For example: If EndDate is less than Start date, show error message (the label).
edit:
@Anonymous we are talking about the EditForm, Submit(EditForm) button.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Ah, SharePointIntegration!!

So in this case, yes, you cannot alter the save button, but you can alter its behaviour.

In the OnSave action of the SharePointIntegration control, you can change the formula to the following:

If(EndDate.SelectedDate < FinishDate.SelectedDate,

Notify("Check Dates"),

SubmitForm(SharePointForm1))

This will check the two dates (again, you need to adjust the names to reflect your form controls) and if they are invalid, then it will Notify the user about the issue (you can do other things if needed).

If the dates are good, then it will do the normal SubmitForm function.

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

Like (0)

Report

Sorry but I can't seem to get where to put that code, I do not see the integration control you are talking about. Could you please share a screenshot of where it is

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (4)

Report

@Anonymous

It will be in the left side component naviagation tree, listed as SharePointIntegration

You will click on that and then choose the OnSave property in the property drop down list. Then alter the formula there.

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

Like (1)

Report

It was right there! Thank you very much!

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

Like (0)

Report

One last thing, in SubmitForm(SharePointForm1), the "SharePointFom1" is the name of the SharePoint list?

Was this reply helpful? Yes No