web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Don't overwrite data i...
Power Apps
Answered

Don't overwrite data in sharepoint via patch

(1) ShareShare
ReportReport
Posted on by

Hi Experts,

 

In my app I have a drop down box within a gallery and i've set the OnChange property to the below. I'm wanting the history comments to be added to what is already in the history column in sharepoint but currently it's overwriting what is already there. Can you advise what I need to change please? FYI, the Technician selection should overwrite the choice currently in sharepoint, it's just the History text that shouldn't. 

 

Select(Parent);
Patch(
 TicketingSystem,
 'Gallery-Tickets'.Selected, 
 {
 Technician: 'Dropdown-Technician'.Selected.Value,
 History: User().FullName & " - " & Text(Now(),"[$-en-GB]dd/mm/yyyy hh:mm:ss","en-GB") &":" & Char(13) &
 "----------------" & Char(13) &
 "Technician changed to: " & 'Dropdown-Technician'.Selected.Value 
 }
)

 

Thanks in advance

Dave

Categories:
I have the same question (0)
  • Verified answer
    Fredrik_A Profile Picture
    3,401 Super User 2025 Season 2 on at

    Not at my pc right now but this might work:

     

    Patch(
     TicketingSystem,
     'Gallery-Tickets'.Selected, 
     {
     Technician: 'Dropdown-Technician'.Selected.Value,
     History: 'Gallery-Tickets'.Selected.History & Char(13) & User().FullName & " - " & Text(Now(),"[$-en-GB]dd/mm/yyyy hh:mm:ss","en-GB") &":" & Char(13) &
     "----------------" & Char(13) &
     "Technician changed to: " & 'Dropdown-Technician'.Selected.Value 
     }
    )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 419

#2
WarrenBelz Profile Picture

WarrenBelz 397 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 345 Super User 2025 Season 2

Last 30 days Overall leaderboard