web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Native export of custo...
Power Apps
Suggested Answer

Native export of custom event fields does NOT exist in Real time Marketing

(1) ShareShare
ReportReport
Posted on by SN-29012043-0 Microsoft Employee
Microsoft’s Real‑time event registration uses unmapped fields (custom registration fields), but there is no built‑in export that produces a clean Excel file with one column per field.
Instead, all custom values are stored inside Form Submissions / Field Submissions, not in a flattened, event-centric table.
[learn.microsoft.com], [sjoholt.com]
Outbound Marketing did support custom registration fields with a proper view and export, but that feature is explicitly listed as Outbound‑only and not available in Real‑time.
[learn.microsoft.com]
 
And we want to bring it back!!!
Categories:
Building Power Apps
I have the same question (0)
  • Suggested answer
    VASANTH KUMAR BALMADI Profile Picture
    VASANTH KUMAR BALMADI 322 on at

    You’re not missing anything — this is a real functional gap in Real-time Marketing, and Microsoft has already acknowledged it internally.

    You’re describing exactly what changed when Dynamics 365 Marketing moved from Outbound Marketing → Real-time Journeys.

    ✅ What actually happened

    Outbound Marketing (legacy)

    Outbound had:

    • Event Registration entity

    • Flattened schema

    • One column per custom field

    • Views worked

    • Excel export worked

    • Power BI worked

    You could literally:

    Event Registration
 ├─ First Name
 ├─ Email
 ├─ Company
 ├─ Custom Question 1
 ├─ Custom Question 2
 └─ ...

    Everything was tabular.

    Real-time Marketing (current)

    Real-time registration uses a form engine, not Dataverse schema.

    So instead of columns, it stores data like this:

    Event Registration
   ↓
Form Submission
   ↓
Field Submissions
       ├─ FieldId
       ├─ FieldLabel
       ├─ Value

    This is entity-attribute-value (EAV) storage.

    That’s why:

    • no registration view can show your fields

    • no Excel export flattens correctly

    • Power BI looks broken

    • advanced find is useless

    This is by design — not a bug.

    ❌ Why Microsoft did this

    Real-time Journeys uses the same engine as:

    • marketing forms

    • landing pages

    • preference centers

    • event registration

    That engine supports:

    • dynamic fields

    • conditional questions

    • runtime personalization

    • anonymous submissions

    Those features require schema-less storage, which is incompatible with flat Dataverse tables.

    So Microsoft traded:

    reporting simplicity
    for
    real-time flexibility

    Unfortunately, events took the hit.

    ✅ Official Microsoft position (as of 2025)

    • ❌ Custom registration fields are not flattened

    • ❌ No built-in Excel export

    • ❌ No Dataverse view support

    • ❌ No roadmap commitment to reintroduce it

    • ❌ Outbound feature parity is not planned

    This is confirmed in the docs you linked.

    ✅ What you can do today (supported options)

    Option 1 — Power Automate flattening (most common)

    On registration submit:

    1. Trigger flow on Form Submission created

    2. Read related Field Submissions

    3. Pivot values

    4. Write to your own Dataverse table:

    Event Registration Export
 ├─ Contact
 ├─ Event
 ├─ Question 1
 ├─ Question 2
 ├─ Question 3

    Now you have:

    • clean views

    • Excel export

    • Power BI support

    • audit history

    This is what most enterprise customers are doing.

    Option 2 — Synapse Link + SQL pivot

    If you use Fabric / Synapse:

    • enable Dataverse → Fabric Link

    • query FieldSubmission table

    • pivot on FieldLabel

    • export from SQL

    Very powerful, but more technical.

    Option 3 — Custom registration app

    Some customers bypass Microsoft forms entirely:

    • Power Pages or Power Apps form

    • write directly to Dataverse

    • full schema control

    • perfect export

    Still integrate with Real-time journeys using triggers.

    ⚠️ What you cannot restore

    There is no supported way to:

    • extend the Real-time registration table

    • add custom columns

    • enable classic views

    • get Outbound-style exports

    Those features were intentionally removed.

    📌 Why your “bring it back” request is valid

    Event management fundamentally requires:

    • tabular exports

    • Excel handoff

    • offline attendee lists

    • badge printing

    • imports into third-party tools

    EAV storage breaks all of that.

    This is one of the most requested missing features in Real-time Marketing.

    ✅ Where to raise it (this actually matters)

    If you want Microsoft to bring this back:

    🔗 Power Platform Ideas portal

    https://ideas.powerplatform.microsoft.com

    Search for:

    “Real-time marketing event registration export”

    and upvote existing ideas.

    Microsoft product team actively monitors these.

    ✅ Summary

    You’re correct on every point.

    • Real-time events store data in EAV format

    • Custom fields are unmapped

    • No clean export exists

    • Outbound had this — Real-time does not

    • This is a known regression

    Only workarounds today are:

    • Power Automate flattening

    • Fabric/Synapse pivot

    • Custom registration solution

    Until Microsoft adds a flattened registration projection, there is no native fix.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 424

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
11manish Profile Picture

11manish 290

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans