Skip to main content

Notifications

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

Form Submissions - Submitted Values not visible in export or Blob

(0) ShareShare
ReportReport
Posted on by 27

Hello,

I am working with the Power BI Templates for D365 Marketing. In the Form Submissions Report (and others that pull Form Submission data), I am not getting any values for 'SubmittedValues' in the Form Submissions query. In fact, the column for SubmittedValues is not created at all.

When looking in D365 at various Marketing Forms with submissions, I am able to see values for "Submitted Values". However, when I attempt to export this table, the Submitted Values column is blank.

pastedimage1584542766480v1.png

pastedimage1584542838147v2.png

I assume these issues are related. Is there anything I am missing in terms of settings?

Thank you.

  • Suggested answer
    Nishant Rana Profile Picture
    Nishant Rana 11,314 Microsoft Employee on at
    RE: Form Submissions - Submitted Values not visible in export or Blob

    In case someone else is also facing the same.

    It is a calculated column so Retrieve call will not fetch it's value, however if you are Retrieve multiple, CRM takes care of populating the value of that field.

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Form Submissions - Submitted Values not visible in export or Blob

    Hi tcmanders,

    Thanks for your feedback.

    I would like to help you further, but I havn't subscription to Power BI unfortunately.

    You could open a ticket if you think it would be a bug.

    Regards,

    Clofly

  • tcmanders Profile Picture
    tcmanders 27 on at
    RE: Form Submissions - Submitted Values not visible in export or Blob

    Clofly,

    The export does work as you described, but my overall need is for the data to be populated in the blob storage because I'm building reports in PBI. Sounds like it is a bug.

    Thanks.

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Form Submissions - Submitted Values not visible in export or Blob

    Hi tcmanders,

    Could "export insights data to csv" works for submission value?

    Regards,

    Clofly

  • Suggested answer
    RE: Form Submissions - Submitted Values not visible in export or Blob

    Hi tcmanders,

    This isn’t an expected behavior. Please file a support ticket to ensure we can assist in a timely manner.

    Best regards,
    Defne

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Form Submissions - Submitted Values not visible in export or Blob

    Hi tcmanders,

    I found a strange thing:

    As we have seen, a form submission record is actually a Form Submission entity record.(logical name: msdyncrm_marketingformsubmission)

    At first, the Submitted Value does exist in Form Submission entity, because I found it in customization.

    I create a custom view for the entity, and add submitted value as one of column, it displays well.

    pastedimage1584587202409v1.png

    However, when I export my custom view, the field is still blank as issue you encountered.

    pastedimage1584587376202v2.png

    So I did retrieving with Web API to check whether the field actually contains data,

    when I retrieve all records, the field contains data:

    pastedimage1584587608484v3.png

    then the strange thing happened, when I retrieve a specific record(first record in above screenshot), the field became null.

    pastedimage1584587741878v4.png

    So in my opinion, it could be a bug at present which caused such issue.

    If you would like to do analytic for form submission data, as a workaround, you could enable 2020 wave 1 early access for your environment,

    this release has brought a new feature: export insights data as csv file.

    By this way, which means that we instead export data from Insights widget.

    pastedimage1584588035241v5.png

    Submitted value can display normally in exported csv from Insights data.

    pastedimage1584588173998v6.png

    Regards,

    Clofly 

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…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans