Patch Function not recognizing field

(0) Share

Report

Posted on by ctedesco3307

621

Hey All; I can’t figure out what is wrong with my Patch function

I have a screen with 2 simple controls

The drop down selects the values from the Title column that I renamed Project Key

The date picker is not associated with any column or list

I want the Close Project button to patch the date entered in the date picker to the ClosedDate column in the PS Contracts Totals list based on the project key selected in the dropdown.

Why can’t my Patch function recognize Title? (I renamed Title Project Key in the list which is why Project Key shows in the value field for the dropdown. That Project Key value is the Title column)

Thanks in advance

All responses (4)

Answers (1)

ctedesco3307 621 on at

Like (0)

Report

Re: Patch Function not recognizing field

@timl -- that did it!!! thank you all!!!
Verified answer

timl 34,933 Super User 2025 Season 1 on at

Like (0)

Report
Re: Patch Function not recognizing field

@ctedesco3307

I'm pretty sure that @gabibalaban is correct.

Just to clarify, it's the syntax of the condition inside LookUp that's incorrect. It should look like this:

Patch( 'PS Contract Totals', LookUp( 'PS Contract Totals', Title=drpPKey.Selected.ProjectKey ), {ClosedDate: dtClose.SelectedDate} )
ctedesco3307 621 on at

Like (0)

Report

Re: Patch Function not recognizing field

@gabibalaban - thanks - but thats not working either. It's a drop down not a combo box. I tried

Title=drpPKey.Selected
Title=drpPKey.SelectedText
Title=drpPKey.Selected.Value
I get incompatible types for comparison: These types can't be compared: Text, Record
CU-18081211-6 9,266 Super User 2025 Season 1 on at

Like (1)

Report

Re: Patch Function not recognizing field

@ctedesco3307 ,

Title=drpPKey.Selected.Value (or the column you need from combobox selection)