cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Posting Collection to Specific Sharepoint Record

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'})

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (77,397)