Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Power Apps for D365 Finance

(0) ShareShare
ReportReport
Posted on by 10

Hi, I have recently started to explore the possibilities of building power apps to extend the functionality of D365 Finance but I cannot fund much documentation on this topic. I am mostly interested to know about general possibilities and limitations of this. As there is not much documentation, does it mean it is not commonly used for some reason or do people simply not document it? I also have some more specific questions:

  1. When using the "Fin & Ops Apps (Dynamics 365)" connector, does the app sense relationships between the different data entities or can I add relationships somehow? I am trying to build a simple app that has a gallery with sales order number etc frÃ¥n the data entity SalesOrderHeadersV2 and second gallery showing info from the data entity SalesOrderLines based on the selected sales order in the first gallery, but I don't get it to work.
  2. Does the functionality differ much if using viritual entities instead of the above mentioned connector? I found a video of Scott creating the above described app but using viritual entities, is that what I need to do for this to work?
  3. I have pretty much only come across Canvas Apps when built for D365 F&O, are model driven apps ever used?
  4. I currently only receive data from my default company in F&O even if I upload the app to a different company. Is there a way to instead filter the data to the company I am inbedding the app to? I tried the following formula that Microsoft provides, but only the first part works, not the second part which is meant to enable company filtering.

    If(!IsBlank(Param("EntityId")), Set(FinOpsInput, Param("EntityId")), Set(FinOpsInput, ""));
    If(!IsBlank(Param("cmp")), Set(FinOpsLegalEntity, Param("cmp")), Set(FinOpsLegalEntity, ""));


I am grateful for all answers I can receive!

Linnea

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: Power Apps for D365 Finance

    Hi Linnea,

    Most of the Power Apps documentation is generic. There isn't that much of information about the combination of Power Apps and Finance and Operations as the Fin & Ops Apps connector is just one of the connectors which can be used.

    1. You need to apply the relations and filters yourself. The App-in-a-day training shows you how to link tables with filters.

    2. Yes, there are differences.

       a. Virtual entities are initially ignoring the company filtering. It will show data for all legal entities unless you apply a filter.

       b. Virtual entities are part of a Dataverse environment. With the Fin & Ops connector, you would need to change the environment details when moving the app from dev to test to prod where Dataverse is aware of a current environment.

    3. When using a model driven app, you can only use tables (and virtual tables) from the Dataverse environment.

    4. See question 2. With Virtual entities, you can by default use data from all companies and apply filters when you need it.

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,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans