Date Field Wont Patch

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

The only field that I can't get to Patch is the Signature Date. In my Dataverse table it is setup as a date only type.

Thanks

Patch(
 'Travel Reimbursements',
 LookUp(
 'Travel Reimbursements',
 cr0d7_travelid = TravelSelection
 ),
 {
 TravelID: TravelSelection,
 Name: "Sig",
 'Signature Date': DateValue(SigDate_1.SelectedDate),
 Signature: SigInput_1.Image,
 'Mil Reimbursement Amount': TotalMilesCost,
 'Total Expenses': ExpensesValue,
 'Total Reimbursement Amount': LabelREexpenses,
 'Travel Status': 2
 }
);
Refresh('Travel Reimbursements');
Reset(TravelGallery);
Navigate('Home Screen');
Reset(SigInput_1);

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Gowri Halan 262 on at

Like
a
(0)

Report
Copy link

Link copied!

@gfeldhake if signature Date is date picker, then pass the value directly without DateValue function. Something like below
Date: SigDate_1.SelectedDate.
If it dosent work then use Date function.
Like Date(yyyy,mm,dd).

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like
a
(0)

Report
Copy link

Link copied!

@gowrihalan04 Date: SigDate_1.SelectedDate did not work, and I can't get the Date Function to not give an error. Can you show me how I would write it? I am very new to Power Apps.

Was this reply helpful? Yes No