Patch to Sharepoint Dropdown Value from Look-up List to Different List

[OldDogNewTricks]

I'm trying to add a record to a sharepoint list from a PowerApp Form.  My patch function works well for data from "Text Input" fields, but I'm not able to crack the code for Patching from these drop-down controls.  The drop-down values are based on look-up lists, also in Sharepoint.

My background:

I am not experienced with Powerapps or with Sharepoint, and probably use the wrong naming conventions.  My experience is with relational databases including Sybase, Oracle, Informix, Digital RDB, Pick, and in recent decades MS SQL Server.  So, my inclination is to view lists as tables and look-up fields from a relational perspective.

Background:

If any of these Lists or other object names seem familiar, I started with the Helpdesk template.  (I'm not sure if starting with the template was a help or a hinderance.)  All of the delivered Collections have been replaced with SharePoint lists.

I have a look-up list named Locations with a column named Location.  Here is the structure of Locations:

If pertinent, here is the definition of the Location column:

I'm trying to add a record to a list named TicketList.  It includes a column named Location, which is defined as a lookup type.

Here is the definition of Location in TicketList.

My form includes a drop-down box named CreateTicketScreenLocationDropDown.  I (initially) defined the "Items" attribute as Locations.Location, which shows no errors and works as a drop-down.  However, I have been unable to succeed in including it in a Patch function writing to TicketList.   (I tried Patch(Ticketlist,Defaults(TicketList),{... Location:CreateTicketScreenLocationDropDown.SelectedText, but it shows an error:

I also tried ...Selected without success.

Reading numerous other post solutions, I believed that my dropdown should be based on a Choices function.  I've tried the following variations:

Choices(Locations.Location)  

Choices([@Locations].Location) shows the same error.

My app has numerous other drop-downs based on look-up lists, but I'm assuming that if I break the code on one, the others will work similarly.

So I'm looking for how to define the "Items" attribute of my drop-down and how to include a Patch statement that uses that it to add a record to my TicketList.

Thank you in advance for any help you can provide.

[LaurensM · Accepted solution]

Hi @OldDogNewTricks,

The Items property of the dropdown will be:

Choices([@TicketList].Location)

Using DropDownLocationName.Selected in your patch property should do the trick. Could you give these adjustments a try. 😊

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

[OldDogNewTricks]

It's sorta counterintuitive, but it works!  Thank you very much.