Answered

SharePoint List Forms Date Checking on Save

(0) Share

Report

Posted on by BW-01101641-0

Newbie here.

I have a SharePoint List Form that I'm editing in PowerApps. There are 2 date/time fields ("Start" & "End") in my SharePoint list. I want to do a bit of error checking to see if Start is after End. If Start is after End, I want an error message to appear when the user hits "Save" on the form since Start should not be after End.

Based on my research, I need to edit OnSave in SharePointIntegration. Here's what I've tried (among many other things):

PowerApps does not detect a syntax error in the code, but the code does not work since it does not detect when Start is after End.

My SharePoint List has the date/time fields "Start" and "End." My PowerApps form has these cards:

Any ideas? Thank you for your help!

-Ben

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Since the validation is occurring on App, change the start and end to;

If(

DateValue1.SelectedDate>

DateValue2.SelectedDate,Notify(.….))

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

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.
Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ben94607 ,

try this:

If(DateDiff(DateValue2.SelectedDate,DateValue1.SelectedDate,Days)>0,SubmitForm(SharePointForm1),Notify("End Date can't be less then the start date"))
BW-01101641-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. That works well. Is there a way to incorporate the time in there also so that it compares both date & time?
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately no! if that helps your issue please mark it as a solution so that the new members will make use of it.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What will be the purpose of the time?

Is time not part of your date already

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

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.
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

I just want to follow up with you on this issue to see is it resolved or still you see any challenges.

If you see any challenge/need further help let me know I am always happy to help
BW-01101641-0 on at

Like
a
(0)

Report
Copy link

Link copied!

The form is a leave request form. It's important to see if the start date & time is later than the end date & time. I thought of having a nested if statement to first test for date and then time, but I was hoping for something more straight forward. Thanks!