Unanswered

SP date and time field in the form

(0) Share

Report

Posted on by ekoz21

Hi All,

I am experiencing some difficulties with an SP field date and time in the form in PowerApps.

I have a date and time field in my form as mandatory/required. I have a submit button and I want it to be disabled if the date Datacards have not been selected/filled.

When trying the formula below on the DisplayMode of the button, the submit button is in edit mode as soon as I fill out the other required fields without even choosing date and time:
If(
VideoRecordings_Frm_1.Valid,
DisplayMode.Edit,
DisplayMode.Disabled
)
I have also tried the IsBlank formula, it works with other fields, however, the button never becomes editable with the date and time field.

Thank you for any advice!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

KvB1 1,596 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't really understand the inner If functions.

They both return a Time, but only when the user hasn't filled in the StartofFootage_DataCard or FinishOfFootage_DataCard. If those are filled in, those 2 If functions will return nothing for the outer If function, making it just check whether DataCard5_1 or DataCard3_1 is empty.

It appears you were trying to give users an option to either manually enter a datetime, or use a datepicker?

When I need users to use a DatePicker, I check whether its value is different than its default value, and use that as an argument in en If function
ekoz21 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am only using a DatePicker.
Could you please clarify how should I check whether the selected value is different from the default value?

Your help is much appreciated!
KvB1 1,596 on at

Like
a
(1)

Report
Copy link

Link copied!

If the DefaultDate property of your datepicker is set to Today(), DatePicker1.SelectedDate=Today() will return true if the defaultdate and selecteddate are the same.

You can also use this to force users to pick a date that makes sense. For example, in your case it would make sense of the start date of footage would be in the past. You could set the DefaultDate of your datepicker to Today()+1, and then disable the button if the DatePicker.SelectedDate>Today
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ekoz21
Date is empty , so button is disabled.
Date is not empty , so button is enabled.

Display mode of the button:
If(IsBlank(DataCardValue39.SelectedDate) ,DisplayMode.Disabled, DisplayMode.Edit)