Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Microsoft Power Apps Cookbook, 2e
Microsoft Power Apps Cookbook, 2e

Microsoft Power Apps Cookbook, 2e: Apply low-code recipes to solve everyday business challenges and become a Power Apps pro , Second Edition

eBook
$24.99 $35.99
Paperback
$49.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
Table of content icon View table of contents Preview book icon Preview Book

Microsoft Power Apps Cookbook, 2e

Building from Data with Model-Driven Apps

Model-driven apps are the data-centric siblings of canvas apps. They get their foundation from the business data model, taking an approach of placing building blocks on top of data. These blocks build up in a standard responsive layout, which allows the creation of a solution that adapts to any device.

Even though analyzing and setting up the data source is one of the main objectives of any application, this is the primary objective in model-driven apps. A complete understanding of the business process allows you to design your data model with a solid structure to support the proposed solution. The last step would be to build the app on top of this model.

This chapter will explore the model-driven world of Power Apps while building a help desk solution. Through these recipes, you will get a clear view of all the components available on this platform:

  • Exploring Dataverse
  • Configuring the environment
  • Building a...

Technical requirements

The proposed help desk solution requires the following recipes to be addressed in sequence to build a complete model-driven solution.

The complete version of this application is available from our GitHub repository at https://github.com/PacktPublishing/Microsoft-Power-Apps-Cookbook-Second-Edition/tree/main/Chapter02

Licensing requirements

When building model-driven solutions, there are some specific licensing requirements. Please refer to the Preface section of this book to get more information about the licensing model of this platform.

Exploring Dataverse

When we talk about the data model for model-driven apps, we mean Dataverse. The data gets stored in tables just like regular databases. The difference between a traditional database and Dataverse lies in the rich set of business-oriented features:

  • Use a set of standard business tables out of the box with the ability to add your own custom tables
  • Create a table, and the platform will automatically add all columns to address the underlying process requirements, such as owner info, tracking, status, versioning, and the like
  • Structure your data with various column data types, which helps in complex data modeling scenarios
  • Design relationships and define keys for standard and custom tables to ensure data integrity across the service
  • Enforce security on roles, records, and column levels, giving you complete flexibility when setting up data access
  • Add business features right from the table configuration: data consumption through...

Configuring the environment

When you configure a Dataverse database for the first time, it will create a set of business-centric tables, such as Accounts and Contacts. Starting from them, you would only need to add custom tables that your processes might need to achieve their goal. In this recipe, we will start creating the building blocks of an application to handle a help desk service.

Getting ready

To build our solution, we will start by setting up a new environment and use it as our development area. Then, we can pack our solution and deploy it wherever it is needed.

How to do it…

  1. Go to the Power Apps admin center by visiting https://admin.powerplatform.microsoft.com, or https://aka.ms/ppac for short. You can also navigate from the Power Apps maker portal by clicking on the upper-right gear icon and selecting Admin center.
  2. Once in the admin center, select Environments in the left pane and click on New. This action will open a panel where you...

Building a Power Platform solution

If environments serve as containers for all our Power Platform components, then a solution is the container for each development we build using those components. A solution creates a package to store all the pieces that compose your application, which aids in deployment, distribution, and management. More information on this subject can be found here: https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/distribute-model-driven-app

Getting ready

To build our solution, we will start by setting up the publisher, which defines the solution’s developer and also specifies the prefix for all your custom tables and columns.

How to do it…

  1. From the Power Apps maker portal, select Solutions from the left menu, and then click on New Solution.
  2. Before describing the solution, click on New publisher and enter the Display name and Name. Enter a meaningful two-to-eight letters Prefix for all the elements you...

Defining data structures

For our help desk solution, we will use related tables as our data source. We will design a base column template to keep track of all the information needed. You can customize it to your own needs.

Getting ready

The following tables will make up our solution’s data structure with the main focus on the Ticket table, to which all the tables will be related. Let’s start with this one and then move on to the rest.

Ticket

This table will hold the base information of the help desk ticket and will be our data model’s primary object. The column structure is as follows:

Display name

Data type

Format

Title

Single line of text

Text

Description

...

Building the model-driven app

Creating a low-code application entails a different methodology for the application-building process. When using other technologies, you might need to choose the language, infrastructure, database system, and more. For model-driven applications, the essential principle is to create everything from the data structure and then build the components from there.

Getting ready

As per our example, the help desk solution will package all elements required for our application, such as tables, dashboards, and the like. All components can be exported in just one package and then imported into the destination environment.

We will use the Modern app designer to build the application. This designer allows more rapid application development, although it doesn’t have the complete list of features that the classic designer has. However, there is always a Switch to classic button to fall back to the classic designer when needed.

How to do it…...

Setting up business process logic

For every business process, there is always a step-by-step procedure that defines every requirement, objective, and resolution from start to end. Companies build on and improve these procedures depending on the business needs and even create departments to work exclusively on this.

Getting ready

Model-driven apps help set up these rules by providing several tools to define business logic at various platform levels. You can incorporate data validation rules, structured data flows to guide the end-user, and even trigger workflows for specific events in your processes. These are just some examples of what you can achieve with this platform.

Let’s improve our help desk application by adding business logic in two ways:

  • Hiding or making a column visible depending on the ticket status, by using a business rule. In our case, there is no reason for the Ticket Validation column to be visible unless the case is in a Resolved state...

Designing dashboards to visualize data

When working with business processes that deal with data, one of the main goals for organizations is to gain insights. Knowing where your operations are failing or where there is a market opportunity is vital, so having an easy way to interact with data is very important.

Dashboards are a feature in Dataverse that allow you to display a mix of graphs, grids of data, and web resources in one place. For example, web resources can include iframe objects, which can be used to display content from another website inside a model-driven application.

Building on the example used throughout this chapter, let’s add more value to the help desk solution by including a ticket dashboard.

How to do it…

  1. Let’s create the charts that we will use in our dashboard. Starting from our solution, expand the Ticket table and click on Charts. From the toolbar, click on New chart. This action will open a new tab to define the...

Integrating canvas apps inside model-driven apps

One of the best features present in canvas apps is the ability to access multiple external connectors from the same app. We can use this strength by embedding a canvas app as a component.

These are some scenarios in which this can be very helpful:

  • A canvas application that is already in use by the organization and we want to integrate into our model-driven solution.
  • A canvas app that connects to a legacy system using the on-premises data gateway.
  • An employee tracking system that gives us information about which of our customer locations our support staff is working at any given moment. This data could be helpful to see whether we already have someone from support at the customer’s location when a new ticket arrives.

Now let’s see how we can integrate a canvas into our model-driven solution.

How to do it…

  1. From the solution, expand the Project table and click on Forms...

Improving model-driven apps with custom pages

Model-driven apps offer many capabilities focused on data-driven solutions. These solutions use the features available from Dataverse, but what if you need to go beyond what model-driven apps provide?

The Power Apps roadmap hints about a convergence model in which model-driven apps and canvas apps use the same designer to build solutions. This feature offers the ability to unite the excellent capabilities available in canvas apps within model-driven applications. More information on this subject is available here: https://powerapps.microsoft.com/en-us/blog/custom-pages-for-converging-model-driven-apps-and-canvas-apps/

With this recipe, we will use canvas apps to make use of a device’s native capabilities – in this case, the Global Positioning System (GPS).

Getting ready

Building on this chapter’s solution, we will improve the data handling of the Ticket Operations table. Before we begin, go to the table...

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Enhanced with added content on Power Pages, robotic process automation, map capabilities for canvas apps, solutions using mixed reality, and much more
  • Explore a variety of built-in templates to create custom apps for specific business scenarios
  • Strengthen your enterprise applications with advanced techniques and proven tips using a low-code approach

Description

Power Apps is a low-code platform owned by Microsoft. With this platform, you can create solutions to solve your business needs while integrating with other components of the Power Platform, such as Microsoft Power Automate, Microsoft Power BI, and others. This book is a handy solution guide to meet many organizational requirements. Microsoft Power Apps Cookbook, Second Edition, takes a pragmatic approach where every business scenario is presented in a quick, practical, and action-oriented recipe. You will be able to use these instant solutions in your development environment and customize your business apps to meet challenging business needs. This will help you handle real-world scenarios and experiences to give you a head start in your Power Apps projects. You will discover various aspects of Power Apps, from building canvas apps, designing model-driven solutions, extending apps with custom connectors, and integrating apps with other platforms, to the pro-developer side including Power Apps Component Framework and creating website experiences for external users with Power Pages. By the end of this Microsoft Power Apps book, you will have gained experience in developing applications using the Power Apps platform and all its features.

Who is this book for?

This book is targeted at information workers and citizen developers wanting to develop custom applications for their organizations or the projects they are undertaking. Traditional app developers will also find this book useful by discovering how to use a rapid application development environment with increased productivity and speed. Readers are expected to have prior exposure to the Microsoft Power Platform ecosystem.

What you will learn

  • Learn to integrate and test canvas apps
  • Design model-driven solutions using various features of Microsoft Dataverse
  • Automate business processes such as triggered events, status change notifications, and approval systems with Power Automate
  • Implement RPA technologies with Power Automate
  • Extend your platform using maps and mixed reality
  • Implement AI Builder s intelligent capabilities in your solutions
  • Extend your business applications capabilities using Power Apps Component Framework
  • Create website experiences for users beyond the organization with Microsoft Power Pages
Estimated delivery fee Deliver to Russia

Economy delivery 10 - 13 business days

$6.95

Premium delivery 6 - 9 business days

$21.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 30, 2022
Length: 414 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803238029
Vendor :
Microsoft
Category :
Tools :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
Estimated delivery fee Deliver to Russia

Economy delivery 10 - 13 business days

$6.95

Premium delivery 6 - 9 business days

$21.95
(Includes tracking information)

Product Details

Publication date : Aug 30, 2022
Length: 414 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803238029
Vendor :
Microsoft
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 162.97
Microsoft Power Platform Solution Architect's Handbook
$62.99
Workflow Automation with Microsoft Power Automate, Second edition
$49.99
Microsoft Power Apps Cookbook, 2e
$49.99
Total $ 162.97 Stars icon

Table of Contents

14 Chapters
Building Pixel-Perfect Solutions with Canvas Apps Chevron down icon Chevron up icon
Building from Data with Model-Driven Apps Chevron down icon Chevron up icon
Choosing the Right Data Source for Your Applications Chevron down icon Chevron up icon
Automating Processes with Power Automate Chevron down icon Chevron up icon
Extending the Platform Chevron down icon Chevron up icon
Improving User Experience Chevron down icon Chevron up icon
Power Apps Everywhere Chevron down icon Chevron up icon
Empowering Your Applications with No Code Artificial Intelligence Chevron down icon Chevron up icon
Discovering the Power Platform Admin Center Chevron down icon Chevron up icon
Tips, Tricks, and Troubleshooting Chevron down icon Chevron up icon
Advanced Techniques with Power Apps Component Framework Chevron down icon Chevron up icon
Reaching Beyond the Organization with Power Pages Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.7
(18 Ratings)
5 star 88.9%
4 star 0%
3 star 5.6%
2 star 5.6%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Raymond Tham Jul 02, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Excellent book
Feefo Verified review Feefo
Murray Fife Oct 25, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I got a copy of Eickhel Mendoza's second edition of his Microsoft Power Apps Cookbook book a couple of weeks ago, and this book is great. It covers all of the key components within the Power Platform, and gives great overviews of the Canvas and Model Driven Apps, Power Automate (including modularization techniques), Power Pages, and more.For any of you that just want to tinker around with the Power Platform, then this is a great start. Check it out on Amazon here:
Amazon Verified review Amazon
A. Jaokar Apr 23, 2023
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I like this book - both because of its content - but also because it clarified my understanding of the power platform - very relevant especially in the post GPT world.I read a lot of books - but few cause me to change my technical strategy in a big way. This book did.My hypothesis was that the worlds of LLMs and low code would come together. Hence, my interest in understanding #lowcodeThe book itself was interesting because while I explored it for low code (which included the AI builder product) - I realised that the Power apps / Power platform is now a full fledged development platform. In other words, I saw it as a Business intelligence platform (based on its origins) - much like Cognos or Business Objects. But the power platform has evolved far beyond the BI roots and I think with LLMs it will play a key role going forward. That's what I mean by it clarified my strategyThe cookbook format is easy to follow but also very comprehensive
Amazon Verified review Amazon
Jamie Willis-Rose Jan 30, 2023
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Eickhel Mendoza's Microsoft Power Apps Cookbook (2nd Edition) has amazing tips for everyone. From best practices for canvas apps to the more advanced topics like security and Power Apps Component Framework.You could read it cover to cover and learn a lot, but it's also well organized, so you can quickly jump the section the can help solve your problem. Definitely check out Chapter 10 "Tips, Tricks and Troubleshooting."Overall, highly recommend for anyone creating Power Apps today.
Amazon Verified review Amazon
Michel Mendes Dec 09, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Awesome way to get started with the Power Platform or extend your knowledge by getting to know how to get started with more features and integrations.This book not only guides you through some good practices and principles for Canvas apps development but also gives very practical examples demoing the usage of Canvas apps with different data sources such as SharePoint, Dataverse, SQL Server and Azure Key Vault. Not only explaining how to use different data sources but also how to integrate Canvas Apps with SharePoint and Teams and practical details about those integrations.This book is not restricted to Power Apps Canvas but also will bring tutorials and samples on several parts of the Power Platform.For example, related to Power Automate cloud flows there are also practical samples explaining how the main concepts work and how to automate processes and integrate different tools.The book also brings nice tutorials on Model Driven apps, Desktop flows, Power Pages, how to get started with PCF components and Power Platform administration.Highly recommended for anyone looking into expand their knowledge of the Power Platform!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela