

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.
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:
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?
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:
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.
Compared to the manual coding approach, our solution is:
Wondering how Microsoft Power Platform could benefit your business?
We’ll help you find the best solutions. Let’s connect.
Technical Designer and Power Platform enthusiast
Want to learn more about the possibilities?