Customer experience | Sales, Customer Insights,...

edit event registration custom field

(1) Share

Report

Posted on by MN-01121504-0

Is there any way to edit submissions for the field msevtmgt_eventregistrationcustomfield after they’ve been submitted

I can update it in Make Power Apps, but end users shouldn’t have to go there, so we need an alternative way for users to change a participant’s response (e.g., updating “Accommodation: Yes/No” on an existing registration).

I have also tried editing the value directly from Form Submissions, but the change is not reflected in the subgrid on the event registration record/view for event registrations.

Categories:

Dynamics 365 Customer Insights - Journeys

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Goloknath 1,909 User Group Leader on at

Like (1)

Report
Copy link

Link copied!
The reason your changes in "Form Submissions" aren't showing up in the subgrid is due to the underlying data architecture of Event Management. In Dynamics 365 Marketing (Customer Insights), when a user fills out a custom field on a registration form, the data is stored in the Event Registration Custom Answer entity (msevtmgt_eventregistrationcustomfield). The "Form Submission" record is merely a historical log of the incoming web traffic; editing it does not "push" updates to the actual registration record. To allow end users to edit these without going into the Power Apps maker portal, you should use one of the following methods:
1. Instead of looking at the "Form Submissions" tab, users should edit the record directly within the Event Registration record.

Navigate to the Event Registration record for the participant.

Go to the Custom Answers tab (or the subgrid where these are listed).

The Trick: Many environments have this subgrid set to "Read Only" by default. You may need to enable "Editable Grid" for this subgrid in the Form Editor.

Once enabled, users can click directly into the "Value" or "Boolean" column and change "No" to "Yes" without leaving the page.

2. If the standard form is too cluttered, create a simplified Main Form for the msevtmgt_eventregistrationcustomfield entity.

In the Event Registration record, users can click the "Edit" (pencil icon) or the record name in the subgrid.

This will open the Custom Answer record in a pop-out (Main Form Dialog).

Users can update the value and click Save & Close.

3. If you need to change these answers based on an external trigger (like an email response or a survey), you can use a Cloud Flow:

Trigger: When a row is modified (on a custom staging table or a survey response).

Action: Update a row in the Event Registration Custom Answers table.

Key: You must filter the update to find the specific answer row where the msevtmgt_registrationid matches your participant and the msevtmgt_customfieldid matches "Accommodation."

if this helps pls mark as verified so that it may be helpful for someone else. Thanks!

Was this reply helpful? Yes No
MN-01121504-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @Goloknath

Thanks for the explanation and response. I tried the first option you suggested.

I enabled Editable Grid on the subgrid so users could edit the values directly. When I do that, the grid ends up looking like this:

However, it should ideally look like this instead (with the possibility to edit the subgrid)

My initial thought was that I could create a new view for the subgrid that includes the relevant fields. The challenge is that the actual custom fields are created in production, so I don't have the same fields available in dev when creating the view. The idea would normally be to configure the view in dev and deploy it to prod, but since the custom fields only exist in prod, I'm not able to include them in the view definition

Could you elaborate a bit on how you would approach this in practice?

(this is the component that i used)

Thank you.

Was this reply helpful? Yes No