Patch Function not recognizing field

(0) Share

Report

Posted on by ctedesco3307

967

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)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@ctedesco3307 ,

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

Was this reply helpful? Yes No
ctedesco3307 967 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 37,271 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 967 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No