Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Use rows in a Subgrid in Real-time Marketing

(0) ShareShare
ReportReport
Posted on by 70

Hi All, 

I'm currently in the process of creating a new Event Trigger. This will fire on the creation of a 'Sales Request' record. 

On the Main Form for my 'Sales Request' record there is a Products Subgrid, this may contain a number of rows.

Has anybody created an Event Trigger capable of listing multiple rows from a Subgrid? 

Then proceeding to use the records generated within the Personalization of real-time Marketing?

If so, any help would be greatly appreciated.

Thanks,
Zak

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Use rows in a Subgrid in Real-time Marketing

    Hi Zak,

    For-each loops let you step through a collection of records that are related to a specific current record—for example, to provide a list of all the recent transactions associated with a given contact. You can add the code required to create these statements by placing it within a text element, or by placing custom-code elements in between the other design elements

    https://docs.microsoft.com/en-us/dynamics365/marketing/dynamic-email-content#for-each-loops 

    Also, you can refer the following similar threads:

       

       

    community.dynamics.com/.../dynamic-email-content-from-related-record-1-n

  • Zak Bird Profile Picture
    Zak Bird 70 on at
    RE: Use rows in a Subgrid in Real-time Marketing

    Hi  

    Sales Request is the main table. Products is a sub-grid on the Sales Request table e.g.


    Salesrequest.jpg

    I am curious, can I extract the rows from the Products subgrid into the personalisation of my Email?

    The email would be like: 

    Thanks for you Sales Request, here are the Products you ordered: (x) (x) (x). 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Use rows in a Subgrid in Real-time Marketing

    Hi,

    Could you provide some screenshots about it?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans