Don't overwrite data in sharepoint via patch

(1) Share

Report

Posted on by Dave-ITMan

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:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Fredrik_A 3,401 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
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 } )

Was this reply helpful? Yes No