Waitlist: send email when automatically registered=yes

(1) Share

Report

Posted on by JDG

Hi folks,

A difficult one here: we use power automates to create our event registrations when a website form is filled. We do this because we would otherwise have to create dozens upon dozens of forms manually.

This way of working prevents us from using the Waitlist functionality as intended, but we have covered this in the power automate: it checks the capacity of an event and creates either an event registration or a waitlist item.

When a place becomes available, the waitlist item gets deleted and the event registration is created, as per the documentation (/If the identified waitlist record has Automatically register set to Yes, then an event registration record is generated for the contact and the associated waitlist record is deleted./).

We now need to have an email send to the contact that he/she is registered for the event. Is there any way to do this? Bear in mind that we use one journey for all the events and event registrations.

Many thanks.

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Hi,

Hi,

Since I'm using the trial version of Customer Insights-Journey, which doesn't have the Outbound Marketing module, I can only manually add and delete waitlist records.
When a waitlist is deleted, you can find the deletion record in the Audit Log to get the related contact and event to send a notification confirmation registration event email to the related contact.

This can be implemented with Power Automate Flow.

Compose action: json(outputs('List_rows')?['body/value'][0].changedata).changedAttributes

Condition 1: items('Apply_to_each')['logicalName']
Set Contact GUID variable: slice(items('Apply_to_each').oldValue,8)
Condition2: items('Apply_to_each')['logicalName']

Set Event GUID variable: slice(items('Apply_to_each').oldValue,15)

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
JDG 58 on at

Like (0)

Report

Thanks very much for your answer. I'm not quite sure we'd want to go down that path, but it is certainly a solution.

Was this reply helpful? Yes No
JDG 58 on at

Like (0)

Report

I'm trying to implement this but am kind of at a loss what to do with the conditions 1 and 2 in the Apply to each. You mentioned an expression (Condition 1: items('Apply_to_each')['logicalName'])) but I'm not sure where the 'logicalName' comes from. Shouldn't there have be a Compose action for this one as well?

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report

Hi,

The output of the Compose step is an array, where each element of the array is an object.

These objects represent the changed fields in the deleted Waitlist record.

The /logicalName/ in the object is the logical name of the field.

The /oldValue/ is the value of the field before the record was deleted.

The /newValue/ is the value of the field after the record is deleted.

Best Regards,
Dengliang Li

Was this reply helpful? Yes No