cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gfeldhake
Helper II
Helper II

Date Field Wont Patch

 

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);

 

 

2 REPLIES 2
gowrihalan04
Helper V
Helper V

@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).

gfeldhake
Helper II
Helper II

@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. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,374)