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.
I assume these issues are related. Is there anything I am missing in terms of settings?
Thank you.
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.
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
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.
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
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.
However, when I export my custom view, the field is still blank as issue you encountered.
So I did retrieving with Web API to check whether the field actually contains data,
when I retrieve all records, the field contains data:
then the strange thing happened, when I retrieve a specific record(first record in above screenshot), the field became null.
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.
Submitted value can display normally in exported csv from Insights data.
Regards,
Clofly
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156