Unable to Update Existing DE with Ampscript

Question

We have a Registration Form with Fields

1. FirstName
2. Email
3. Phone
4. Job Function
5. Status

When someone enters details on the form and clicks on submit the data is stored in MC and creates a Lead in CRM.We have an email post that where there are 2 CTA buttons (Yes/ No). If someone clicks on Yes, it redirects to a CloudPage.

I am adding this Ampscript Logic on the CloudPage

%%[ 
set @Email = RequestParameter("Email")
set @Id = RequestParameter("Id") 
set @UpdateRowsinDE = UpsertDE("ResponseDE",1,'Id',@Id, "Status",'closed' )
set @UpdateRowinHC = UpdateSingleSalesforceObject('Request__c',@Id,'Status__c', 'Closed' ) 

]%%

Issue : Instead of updating the record which was initially created through the form its adding a new row just with that field mentioned in AMPscript.

I want the record who entered details on the first form to get updated

Answer 1

Updated:

Pass parameters to a Cloudpage:

%%[
    set @Id = AttributeValue("Id column name")
    set @Email = AttributeValue("Email column name")

    set @CTA_Url = CloudPagesURL("Cloud page Id", "Id", @Id, "Email", @Email)                                          
]%%                                                

<!-- CTA button -->
<a href="%%=RedirectTo(@CTA_Url)=%%">Your CTA button</a>

• CloudPagesURL function

---

Since you didn't post the AMPscript code in your email so I assume that you passed the parameters for "Email" and "Id" properly to the CTA URL.

One thing I notice that you are using UpsertDE function for your Cloudpage instead of using UpsertData function.

Based on the document of UpsertDE function

Use this function with email messages at send time only

Therefore you would want to try this on your Cloudpage:

%%[ 
set @Email = RequestParameter("Email")
set @Id = RequestParameter("Id") 
set @UpdateRowsinDE = UpsertData("ResponseDE",1,'Id',@Id, "Status",'closed' )
set @UpdateRowinHC = UpdateSingleSalesforceObject('Request__c',@Id,'Status__c', 'Closed' )
]%%