Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Is there a way to expo...
Customer experience | Sales, Customer Insights,...
Suggested answer

Is there a way to export all marketing form submissions for an event at once instead of per page?

(0) ShareShare
ReportReport
Posted on by Stijn Lieshout 5

Hi,

I'm running into a very basic problem but haven't been able to locate a solution for it.
We have an event and would like to export all submitted values from the marketing form to an Excel file.

So far no issue as I know how to do this, however the current amount of rows we can see is 10 per page.
Given we are currently at 712 registrations, we would have to export all 72 pages separately.
This doesn't make sense so I assumed there would be a simple solution to get all these records into one page, but I can't find how?
My personal settings have been set to 250 records per page, that didn't work.

Thanks for any help, it must be something simple or is this simply not possible?
I've blanked out the actual values as this is private customer data.


crm_5F00_excel_5F00_submissions_5F00_export.png

  • Stijn Lieshout Profile Picture
    Stijn Lieshout 5 on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi Helene,

    Microsoft is aware of this bug, they have responded to our ticket and the prevision is for the fix to be deployed on December's release (first week of December).

    Hope this helps.

  • Stijn Lieshout Profile Picture
    Stijn Lieshout 5 on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi, no, not yet!

  • Helene B. Profile Picture
    Helene B. 84 on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi, i m encountering the same issue. have you found a solution to it?? also quite unwilling to do export page by page...

  • Suggested answer
    Petr Jantac Profile Picture
    Petr Jantac on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi,

    If the problem persists, please raise a support ticket so our engineers can check your environment and try to find the root cause.

    docs.microsoft.com/.../get-help-support

    Thank you.

    Petr

  • Stijn Lieshout Profile Picture
    Stijn Lieshout 5 on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi Petr,

    Thanks for taking time to respond.

    Yes, we have set the submission storage field to "Yes" from the moment where the form was created/saved.

  • Petr Jantac Profile Picture
    Petr Jantac on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hello,

    Could you please check the form Summary tab if "Store form submission" is enabled (set to yes)? This might be the reason why the export is empty.

    pastedimage1655379569227v1.png

    Thank you.

    Petr

  • Stijn Lieshout Profile Picture
    Stijn Lieshout 5 on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi Steve,

    We tried all the different exporting options but the submitted values column remains empty unless we export page by page.
    If it works for you we may have done something wrong in the form and/or its fields itself.
    At least I know that it is supposed to work and that our situation is an anomaly.

    Thanks for responding!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi StijnL,

    When I click button,  the Submitted values column has value. You can try to click 'Static Worksheet' to have a try.

    There is no another way to export data in the Dynamics. You need to use other tools to do this, such as Power Automate, Azure Data Factory etc.

  • Stijn Lieshout Profile Picture
    Stijn Lieshout 5 on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Thank you Steve for responding. I've tried the option you described first (apologies, I should have mentioned that) but the Submitted values column will end up empty when I do that. The only way I can get the data out is by exporting page by page.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there a way to export all marketing form submissions for an event at once instead of per page?

    Hi StijnL,

    Don't select them and directly export them to have a try:

    pastedimage1655276380225v1.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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans