Post back once you have something working, I think it would make an excellent use of the different tools available to us. I thought I had seen a blog post on the powerapps site covering this pattern but am unable to find it now. Here is the documentation on the MSGraph, Excel functions. My particular use case meant I used this pattern with Flow, rather than directly from a PowerApp, but you should be able to do the same thing with a PowerApp. I found the MSGraph a little hard to work with but from a pattern perspective, it will work. Once the excel file has done the calculation, you can then read the value back into your powerapp. The end result of following these steps will be having. The version that I am showing in this article is NAV 2018, but any version of NAV that isn’t web-based (i.e., Business Central) would be the same.
MICROSOFT DYNAMICS POS EXCEL INTEGRATION HOW TO
This workbook can have a table or series of functions that you can use to calculate your totals, based on data that you pass in from your powerapp. In this article I am going to share how to turn on the integration between Dynamics NAV and Excel.
Using the Microsoft Graph, Workbooks and Charts functions you can query against an Excel file that is stored in OneDrive/SharePoint. I was looking to do something a little similar a few weeks ago and came up with the following high level pattern. More details about Microsoft Flow, please check the following article: If you want to sync records from Excel table to your Dynamics 365 entity automatically, you could add a Recurrence trigger within a flow, then synx Excel table data into your D365 entity in a specific interval automatically (<- Sync Excel table data to D365 entity). You could consider add a trigger within a flow to detect if a record is added within your Dynamics 365 Entity, if yes, create corresponding record within the pre-defined Excel table (<- Sync records from D365 Entity to Excel table).
If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:Īs an alternative solution, if you want to c reate a auto-sync process between Dynamics 365 entity and Excel table, I think Microsoft Flowcould achieve your needs. If you want to create a auto-sync process between Dynamics 365 entity and Excel sheet using PowerApps, I afraid that there is no way to achieve your needs in PowerApps currently. Hi you want to create a auto-sync process between Dynamics 365 entity and Excel sheet using PowerApps?
0 kommentar(er)
