Power Platform Community Forum Thread Details

Hello,

I am working with getting this popup to work whenever it detects a duplication. I have gotten the provider, providernumber, and hours to work; however, I cannot get the month to work. On here, it is not detecting any errors but my popup is not working. It does work when I remove the month. Any ideas as to why it does not work? By the way in SQL the date defaults to 2015-06-23 00:00:00. Not sure if that matters.

If(
LookUp('[incentive_test].[Lkp_Teaching]',
Provider=DataCardValue1_1.Text &&
PROVIDERNUMBER=DataCardValue2_1.Text &&
Hours=Value(DataCardValue3_1.Text) &&
Month=DateTimeValue(DateValue2_1.InputTextPlaceholder),
true
),
UpdateContext({DuplicationPopUp: true}),
SubmitForm('MS Data Entry')
)