Exchange Rate Loader PowerApp for D365 F&O - Part 4

-

 In this final part I am going to go through one of the tweaks I made to the error messaging, what I experienced on running loads was the follow error due to timeouts on the Respond to PowerApps step in my flow:

ActionResponseTimedOut. The execution of template action 'Respond_to_a_PowerApp_or_flow' is failed: the client application timed out waiting for a response from service. This means that workflow took longer to respond than the alloted timeout value. The connection maintained between the client application and service will be closed and client application will get an HTTP status code 504 Gateway Timeout.

This meant that basically on long running flows the flow succeeded but the messaging back timed out and the user was unaware if it succeeded or not (limit I believe is 2 minutes).

The way I resolved to fix this was rather than rely on the Respond to PowerApps step to provide my status, every time I got a response back on the do-until I would write to a Dataverse table and display that instead on the form. This is how I achieved this:

I created a new DataVerse table with the following fields, Status and Error:


This I made a data source under my PowerApp and added it to the form:


To get the data in the table to refresh I placed a timer control to run automatically and on the end function I placed a refresh on the data source to modify how often the data on the form will refresh.


Finally I made some adjustments to the flow to update the new table:

Firstly to add the new row to the table and I used the same naming as the folder I used in blob storage account:



I then replaced the step at the end of the do until to update the table with the dataverse step, this works quite well as the statuses from Data Management are displayed to the user so I removed the spinner:


I tried it with files up up until 100k lines and it preforms ok. But as I am using data management to load this could be much quicker depending on own environment. This app could work for any data entity so I am planning in future posts to look at how to use it with General Journals which have a more complicated structure and maybe others...

A video of the App is below, 











Comments

Post a Comment

Popular posts from this blog

"Exception while trying to get Virtual Entity metadata for entity" Error on Data Events

-
Image
When enabling data events in D365 F&O you might get some error which says similar to below: Exception while trying to get Virtual Entity metadata for entity: ##### I checked the logs and the following is showing depth is "Basic, BusinessUnitId" Response status code does not indicate success: 403 ({"error":{"code":"0x80040220","message":"SecLib::CheckPrivilege failed. User: #### , PrivilegeName: prvReadEntity, PrivilegeId: #### , Required Depth: Basic, BusinessUnitId: #### , MetadataCache Privileges Count: 5803, User Privileges Count: 82"}}). This means to resolve this make sure your application user in PowerPlatform admin center has the Basic user role.
Read more

Electronic Reporting displaying Legal Entity Email/Phone by custom Address Purpose

-
 You may need different email addresses to display on outgoing business documents depending on department sending them or have different "from" email addresses for email's in the ER destinations. This can be done using a custom address purpose, in  the example below I created an Address Purpose called "AP" under  Organization administration > Global address book> Address and contact information purpose and gave it a purpose of contact. Then I added a email address to legal entity using this purpose. Then in the format add the following Class = DirParty Enumeration = LogisticsElectronicAddressMethodType Table = CompanyInfo Then add the following where you want to display the email address: DirParty.electronicAddressLocatorsByRole(CompanyInfo.'current()',LogisticsElectronicAddressMethodType.Email,"AP").
Read more

Custom Connector for HMRC VAT Number Validation

-
Image
I was scrolling through available API's on HMRC website and noticed this one which is in BETA: Check a UK VAT number - HMRC Developer Hub - GOV.UK This information would be very useful in PowerApps and also F&O, so I decided to create a custom connector around this API. To do this I went to custom connectors section in PowerApps: Then I clicked on New Custom Connector > Create from Blank. I filled in the image, Host URL and clicked Security. As this is an Open API and there is no security requirement, I just left this as is and went to the definition tab: I filled in the various pieces of information here: Then Clicked on new to create a new action for the first of the 2 available API's which is just to receive the VAT number without a reference number and then clicked on Import from Sample: Checking the HMRC documents, this is a GET, so mark as GET and then I put in the URL, the URL is a combination of the Host URL and this end point  /organisations/vat/check-vat-number...
Read more