PowerApp to validate UK VAT Numbers in D365 F&O

-

 In my last post I showed you how to create a custom connector to validate a UK VAT number to use in PowerAutomate, in this post I am going to go through how to actually use that custom connector in a PowerApp which we can imbed in D365 F&O, in future posts I will also look at other ways you can use this API for automatic validation.

The first element is the flow which I am using which is pretty straight forward.

We use an in PowerApps step which I am using to initialize the the only parameter required to trigger the API from HMRC using the custom connector I placed in the previous post. Then I am setting the returned VRN number as a variable.



I then initialize a variable called validVRN which basically will hold the text back to the PowerApp and I do a compare too see if the VRN from the PowerApp is the same as the returned value from the API, then I set the value on the variable to either "Valid" or "Not Valid"


Then because a blank value can result in a Valid on the previous step I am doing a check to make sure that the value isn't blank, then setting a message of "Blank Value Entered"


I then pass back all the data from the API to the PowerApp to display to user:


The second element is the PowerApp itself which is also pretty straight forward:


The components are a input field and label which is editable, 





Then a button:


With the on-select property set to below:

Reset(ValidVRN);

Set(VarFromFlow,CheckVATNumber.Run(InputVATNumber));

Then numerous fields to display the data back to the user:


With the default value set to, the hash's representing what data is displayed in that field.

VarFromFlow.######

Then as added some custom colors and logo using the following 👍 Color Picker online | HEX Color Picker | HTML Color Picker (imagecolorpicker.com) to allow me to align the colors in the logo with the colors in the APP its self and using the RGBA(0,0,0,0) command to set the right color, obviously replacing whatever the color returned was.

The final step was to imbed the app into D365 F&O using the add PowerApp button and saving it a view.




Below is a short video of the app working:


Thats all for now.
















The next step is the APP which is 


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