Answered

Using the patch function to add to a record

(0) Share

Report

Posted on by RyanBourbon1

Hello, I have been developing a Power App and using the patch function to add new records as well as update information within an existing record within a SharePoint List, but am now running into a scenario where I would like to keep the existing text and add to it as opposed to replacing it.

If I use the below table for example:

Name	Age	Location
Ryan	38	Florida
Alex	50	Leon

Lets say I want to add the Country to each location. I want to use the patch function to add USA and Mexico along with a delimiter respectively. so that my new entry would be:

Name	Age	Location
Ryan	38	Florida, Unite States
Alex	50	Leon, Mexico

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RyanBourbon1

Patch(ds,ThisItem,{Location: ThisItem.Location & ", " & ThisItem.Country})
RyanBourbon1 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply Dr. Rick. that is effectively what I have been trying to accomplish but am running into an issue identifying what text is currently there because I am looking up the entry based on another columns criteria.

based on my function posted in the picture, I am identifying which row to update by looking it up based on a selection from a dropdown. How would I then call out the text from the completion notes column on the same entry to then add my new notes to it?
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@RyanBourbon1

Not enough information. but assuming you have a list of Locations and Countries that you can lookup,

Patch('CTC-Issue Tracking', LookUp('CTC-Issue Tracking',ID=IssueCountDropdown.ID), {'Assigned to': assignedToDropdown.Selected.'Assigned to', 'Date Updated: Today(), 'Completion Notes': Concatenate( updateIssueInputNotes.Selected.Location,", ", LookUp( LocationsList,Location = updateIssueInputNotes.Location ).Country ) } )

.SelectedText has been deprecated and should not be used.
RyanBourbon1 56 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked well. thanks for the advice on using the concatenate function.