Patch Function not recognizing field

(0) Share

Report

Posted on by ctedesco3307

690

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report

@ctedesco3307 ,

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

Was this reply helpful? Yes No
ctedesco3307 690 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
@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} )

Was this reply helpful? Yes No
ctedesco3307 690 on at

Like (0)

Report

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

Was this reply helpful? Yes No