Get cross company data from D365FO to power apps.

[Anonymous]

Hello All,

My requirement is to create a simple canvas app(in Power App) in order to display the customer details as a list and details view, where the user can able to do the basic CRUD operations.

I have created an app with Dynamics 365FO as a connection and added a data source to my list screen. By default, it is displaying the data from the company which is assigned to a user as default company in D365fo.

For example, if a user has a default company has USMF then the list displays data from that company.

How can I get multiple company data from365FO to power apps?

Thanks.

[v-siky-msft]

@Anonymous 

I am afraid that 'cross company query' is not available for Dynamics365 FO connector.

Please submit an idea to PowerApps Idea forum: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas 

Sik

[Anonymous]

@v-siky-msft Thank you for your reply!, I have submitted the same.

[v-siky-msft]

@Anonymous 

Yes, Let's wait for the next step.

Sik

[Haribabu]

Hi,

Currently powerapps is not supporting to display cross company records. 

The D365FO data entities will display only current company records, and also there is no clarification, if the user has access of multiple legal entities.

Current available option, need to create CDS data entity for customer and create data integration project for each legal entity. The CDS entity can be used in powerapps to display cross company records in powerapps.

[Anonymous]

@Haribabu Thanks for your reply.

[woutermijle_ava]

What about virtual entities? This should allow for getting your data seamlessly in Dataverse (as if it were really there, although it's just a façade using OData) and then do CRUD operations on those tables? And as the company code is one of the fields, you would be able to filter data based on that...

[Haris35]

Can we update the cross company data exist in D365 F&O from power apps using virtual entities? E.g there are multiple legal entities where user has access is in F&O and he perform operations and the business requirement is to perform crud for each company using virtual entities from power apps in addition of the default company assigned to that user.

I tried using finance and operation connector for power apps and found (record update operation) only works for default company, virtual entities can help in this case?