Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Data entity related to a form

(0) ShareShare
ReportReport
Posted on by 4,125

Hi expert,

Open in Excel lets you use the data entity that is related to the form data. Is it a property on AOT to define a related data entity for the form?

Thanks,

  • Verified answer
    Martina123 Profile Picture
    Martina123 on at
    RE: Data entity related to a form

    Hi Yuji,

    It is not a property on AOT.

    When an entity has the same root datasource (table) as a form, it will be added as an option in the Open in Excel section of the Open in Microsoft Office menu. You may refer to docs.microsoft.com/.../office-integration-edit-excel

  • Verified answer
    AnithaEswaran Profile Picture
    AnithaEswaran 2,032 on at
    RE: Data entity related to a form

    hi Yuji,

    By default, if the form`s parent datasource matches with the entity`s datasource, the 'Open in Excel' will be automatically set.

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans