I have been using SharePoint for quite a while and have just started dipping my toe in the water of PowerApps.
I have a SharePoint list where I am customising the data input form with Power Apps.
I have a data table and a reference table. The reference table contains the following fields
Th bold fields contain user friendly data that the user should select from a drop down. Each contractTitle has a single contractCode and wbsCode, but multiple costheatTitle records.
when you create a new record in the data table, the user should pick the relevant contractTitle and I want the form to then lookup the corresponding wbsCode and write it into a wbsCode column in the data table.
I have been trying all evening to get this to work by using the Patch function in the "On Change" Action, but it just doesnt work. I think it is because the data isnt actually written to the record until it is saved. Any pointers would be appreciated.