Dynamics Community Forum Thread Details

Power Apps for D365 Finance

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:

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.
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?
I have pretty much only come across Canvas Apps when built for D365 F&O, are model driven apps ever used?
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

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.

Quick Links