Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

(0) ShareShare
ReportReport
Posted on by 105

Is there a way to batch export/import Templates and/or Content Blocks?

My client just started using Real-time Marketing and now that it has Content Blocks we need all CB from Outbound in Real-time Marketing. We are taling about 100+ Content Blocks.

Is there another way than creating every single CB again in Real-time and copy and pasting HTML Code for every single content block?

  • RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

    Thank you!!! That was it! *facepalm"

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

    Hi KE Comm,

    Please check the Environment is the same as your Marketing Environment.

    pastedimage1659513855230v3.png

  • RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

    Tahnk you, this looks awesome, however I have now run into the issue that Power Automate does not find the table...

    Are there any setup steps in Power Automate that I need to take first?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

    Hi KE Comm,

    Yes. The data of Content blocks in the Outbound is stored in the 'msdyncrm_contentblocks' table. Real time in stored in the 'msdynmkt_fragments'. These two tables' schema is similar and you can copy the field's value from 'msdyncrm_contentblocks' to 'msdynmkt_fragments'. I used the Power Automate to test.(You could also use another tool or code.)

    Steps:

    1. Create an Instant could flow and select manually trigger a flow.

    2. List all rows from the 'msdyncrm_contentblocks' table.

    pastedimage1659506307002v1.png

    Note: When you search Content blocks in the Table name, there would be two tables. You could select one and peek the code to check its table logical name.

    pastedimage1659506423349v2.png

    pastedimage1659506447371v3.png

    3.  Loop the Step2's result and set the value with each row's field value.

    pastedimage1659506515737v4.png

    4. Save and run the flow is ok.

    Result:

    Outbound Content block:

    pastedimage1659506559338v5.png

    Real Time Content Blocks:

    pastedimage1659506590743v6.png

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans