Cegeka_Logo Careers Language Solutions Back
Solutions
Business Applications

Business Applications

Transform your business with Microsoft Dynamics ERP and CRM, integrated with Microsoft’s Power Platform.

Industries Back
Industries

Our industry-tailored services are designed to address specific challenges and opportunities across different industries.

All industries
food-80-80

Food

Streamline operations, ensure traceability and maintain compliance.

pharma-icon-80-80

Pharma & Life Sciences

Face the increasingly complex challenges in Pharma & life sciences with confidence.

Website_Navigation_Energy_Utilities

Chemicals

Cegeka's solutions help face complex supply chains & strict regulations in the chemicals industry.

Insights Back
Knowledge is our backbone

We believe in sharing our insights and expertise with you. Explore our resources and learn more about our products, services and industry trends.

Icons_Navigation_Case Studies

Case Studies

Step into the world of our delighted customers and see how we helped them achieve their goals.

Icons_Navigation_News Items

Corporate News

Stay in the loop with our company news, announcements, awards and events.

Icons_Navigation_Blogs

Blogs

Read our latest articles on topics ranging from technology, innovation, business and beyond.

Icons_Navigation_Webinars

Webinars

Be part of the action with our live or on-demand webinars, where our experts share invaluable knowledge.

Icons_Navigation_Ebooks

E-books & Whitepapers

Download our guides and reports on various aspects of technology and business.

Icons_Navigation_Events

Events

Find out where we are going to be next, and register for our upcoming events.

About Us Back
shaping digital together

We work shoulder to shoulder with our clients to ensure technology drives impact when and where it matters most.

Start the journey with us
Icons_Navigation_Why Cegeka

Why Cegeka

Discover why more than 2,500 clients around the world choose to work with us, and stay with us.

Icons_Navigation_Cegeka&Society

Cegeka & Society

We develop innovative solutions with a positive impact on the environment, people, and society.

Icons_Navigation_Our Story

The Cegeka Story

In just over 30 years, Cegeka has grown from 30 people to a global company with 9,000 employees across 3 continents.

Icons_Navigation_Annual Report

Annual Report

See how our work makes a difference, explore the full annual report to learn more.

More Cegeka

Our Management

Corporate News

Contact & Locations

Back
Select language

Global

Austria

Belgium

Belgium

Germany

Italy

Romania

Sweden

The Netherlands

United Kingdom

United States

Let’s get in touch
Cegeka_Logo Solutions
Solutions
Business Applications

Business Applications

Transform your business with Microsoft Dynamics ERP and CRM, integrated with Microsoft’s Power Platform.

Industries
Industries

Our industry-tailored services are designed to address specific challenges and opportunities across different industries.

All industries
food-80-80

Food

Streamline operations, ensure traceability and maintain compliance.

pharma-icon-80-80

Pharma & Life Sciences

Face the increasingly complex challenges in Pharma & life sciences with confidence.

Website_Navigation_Energy_Utilities

Chemicals

Cegeka's solutions help face complex supply chains & strict regulations in the chemicals industry.

Insights
Knowledge is our backbone

We believe in sharing our insights and expertise with you. Explore our resources and learn more about our products, services and industry trends.

Icons_Navigation_Case Studies

Case Studies

Step into the world of our delighted customers and see how we helped them achieve their goals.

Icons_Navigation_News Items

Corporate News

Stay in the loop with our company news, announcements, awards and events.

Icons_Navigation_Blogs

Blogs

Read our latest articles on topics ranging from technology, innovation, business and beyond.

Icons_Navigation_Webinars

Webinars

Be part of the action with our live or on-demand webinars, where our experts share invaluable knowledge.

Icons_Navigation_Ebooks

E-books & Whitepapers

Download our guides and reports on various aspects of technology and business.

Icons_Navigation_Events

Events

Find out where we are going to be next, and register for our upcoming events.

About Us
shaping digital together

We work shoulder to shoulder with our clients to ensure technology drives impact when and where it matters most.

Start the journey with us
Icons_Navigation_Why Cegeka

Why Cegeka

Discover why more than 2,500 clients around the world choose to work with us, and stay with us.

Icons_Navigation_Cegeka&Society

Cegeka & Society

We develop innovative solutions with a positive impact on the environment, people, and society.

Icons_Navigation_Our Story

The Cegeka Story

In just over 30 years, Cegeka has grown from 30 people to a global company with 9,000 employees across 3 continents.

Icons_Navigation_Annual Report

Annual Report

See how our work makes a difference, explore the full annual report to learn more.

More Cegeka

Our Management

Corporate News

Contact & Locations

Global   Global EN Austria   Austria DE Belgium   Belgium NL Belgium   Belgium FR Germany   Germany DE Italy   Italy IT Romania   Romania EN Sweden   Sweden EN The Netherlands   The Netherlands NL United Kingdom   United Kingdom EN United States   United States EN Careers Let’s get in touch
Home Discover our latest blogs Discover our latest blogs Use case: Update your online product catalog with Microsoft Power Platform
Power Platform
2 minutes reading

Use case: Update your online product catalog with Microsoft Power Platform

Jasper Callens

Jasper Callens

september 06, 2022

To ensure that buyers can make informed decisions, it is essential to regularly update your online product catalog. While these online catalogs are often connected to large back-end databases, writing statements may not be the best or most efficient way to perform such updates. Using Microsoft Power Apps, Cegeka has now built a user-friendly canvas app which allows you to update your catalog without a single line of manually written code.

SQL Database 1

The challenge

One of our customers – a manufacturer of medical devices and supplies – stores all product information in a SQL database. When they first started to build their online catalog, they hadn’t included a user-friendly solution for later updates. As a result, the only way to update their catalog was by either:

  • writing new SQL statements – a complex and labor-intensive process,
  • or requesting help from the IT department – which in turn meant a prolonged turnaround time.

 

The challenge was clear: how could we replace the manual coding approach with an easier, more user-friendly solution for adding, modifying and removing items from the online catalog?

 

SQL Database 3

The approach

To solve our customer’s problem, we developed an easy-to-use custom canvas app that communicates with the SQL database. This is how it works:

  • Upon opening the application, the user sees an overview of all items in the catalog.
  • To add a new item, rather than directly writing SQL statements to generate the item, the user simply enters the desired textual input into the appropriate fields.
  • Microsoft Power Automate automatically converts the textual input into SQL statements and then places these statements correctly in the SQL database, thereby updating the product catalog.

As well as adding new items, it’s also possible to remove items from the catalog and to modify a number of product details, including titles, descriptions, categories etc.

 

SQL Database 2

The results

Compared to the manual coding approach, our solution is:

  • much more user-friendly: the customer no longer needs to write SQL statements or call in the IT department for every minor update.
  • much faster: with a few simple clicks and minimal manual effort, it’s possible to add, modify or remove items from the catalog.
  • much less error-prone: the extensive validation processes embedded within the canvas app prevent incorrect or nonsensical entries that would disrupt the logical structure of the catalog.

Wondering how Microsoft Power Platform could benefit your business?

We’ll help you find the best solutions. Let’s connect.
Jasper Callens

Jasper Callens

More of Jasper Callens articles

Get in touch