Posting Collection to Specific Sharepoint Record

[Sacred_Totems]

I need to update Sharepoint records using a Save Button on a screen with a dozen TextInput fields that have their defaults set to draw from Sharepoint a Sharepoint record selected by making a choice from a DropDown named 'IP House Selection PD'.

For example the TextInput called Owner First Names has Default set to:

'IP House Selection PD'.Selected.'OwnerFirstNames'

Each TextInput is saved into a Collection using exactly the same column names as a Sharpoint list called House List.

Is there a way to modify:

Collect('House List', CollectHouseList)

so that the Collection is posted to whichever record was selected in the DropDown 'IP House Selection PD'?

If there is no way of doing it that way.  What should I replace the red text below with, if I have have a Global variable called House Choice, that holds the text equivalent of the Title field of a Sharepoint list(List name = HouseChoice) record set by using a DropDown OnChange: Set(HouseChoice,'IP House Selection DB'.SelectedText.Value)

Patch(

'House List', Title=HouseChoice,

{OwnerFirstNames: IP Owners First Names DB.Text, OwnersLastNames:'IP Building Owner Last Names PD.Text'})

[v-xida-msft · Accepted solution]

HI @Sacred_Totems ,

Which formula do you put within the Items property of the 'IP House Selection PD' Dropdown box?

I assume that the 'IP House Selection PD' Dropdown box is bind to your 'House List', is it right? Please set the Items property of the 'IP House Selection PD' Dropdown box to following:

 'House List'

then specify proper column name as display column value within the 'IP House Selection PD' Dropdown box.

set the OnChange property of the 'IP House Selection PD' Dropdown box to following:

Set(HouseChoice, 'IP House Selection PD'.Selected)

After that, you could modify your Patch formula as below:

Patch(
      'House List', 
       LookUp('House List', Title = HouseChoice.Title),   // Find the record in your SP list you want to update
       {
          OwnerFirstNames: 'IP Owners First Names DB'.Text, 
          OwnersLastNames: 'IP Building Owner Last Names PD'.Text
       }
)

Please take a try with above solution, check if the issue is solved.

If the HouseChoice variable holds the Title text in your SP List, please modify above formula as below:

Patch(
      'House List', 
       LookUp('House List', Title = HouseChoice),   // Find the record in your SP list you want to update
       {
          OwnerFirstNames: 'IP Owners First Names DB'.Text, 
          OwnersLastNames: 'IP Building Owner Last Names PD'.Text
       }
)

Best regards,