Author: Andrew Ly (Page 1 of 10)

Microsoft Business Applications MVP, based out of Adelaide Australia.

Using SQL Stored Procedures within PowerApps via PowerFX

Customers can now call stored procedures in Power Automate without incurring performance penalties, leading to improved efficiency in action-based apps.

Feature Details:

  • Direct Stored Procedure Calls:  Customers can utilize Power Fx to directly call stored procedures, eliminating the need for additional steps.
  • Seamless Integration: Adding a SQL Server Database object to their data sources enables customers to access Stored Procedures actions directly from the database object.
  • Performance Optimization: This feature helps customers avoid performance hits during app initialization by calling Power Automate. Additionally, it reduces the need to move data in and out of collections, resulting in better overall data call and update performance.
Continue reading

Microsoft Dynamics 365 Field Service – An Approach to Data Migration of Work Orders from External Systems

If you are transitioning to Microsoft Dynamics 365 Field Service for the first time from a legacy system and have scheduled work orders and bookings that need to be migrated, there are a lot of considerations in regard to the generation of service tasks, billing products/services, durations, and pricelists.

In this article, I will detail one approach that aims to simplify the process and ensure that all the correct configurations are applied.

Continue reading

Dataverse Long Term Data Retention

What is Dataverse Long Term Data Retention?

Currently in Public Preview (Q1 2024), Dataverse Long Term Data Retention allows your organisation to archive data to long term storage. But what exactly does this mean?

This means that you can achieve a number of goals:

  • Reduce your overall Dataverse Database Capacity (more on this later)
  • Have more control over data that will only primarily be used for auditing or occasional read-only access. It is designed as an interim stage between having live data, and deleted data. Microsoft calls this ‘retained data’.
  • The ability to query retained data on demand.
  • Build long term retention policies that will work within your ALM, meaning that you can define as a solution layer and carry your long term retention policies between your higher environments.

Note, that this feature should only be enabled in non-production environments for testing purposes at this stage (see Known Issues).

How do I set up Long Term Data Retention?

Continue reading

Extending the Patient Clinical Timeline on Microsoft Cloud for Healthcare

The Patient Clinical Timeline enables care managers to track key clinical information such as conditions, episodes of care, procedures, or medications by providing an at-a-glance view via the calendar control.

It also enables the quick creation of events via the control.

One of the key advantages of this control is the ability to extend it to custom tables within your solution.

In this article, we will explain the basics of the configuration of the patient clinical timeline and how to format your configuration schema file properly.

Continue reading

Microsoft Cloud for Healthcare Updates in 2022 and 2023

Recent changes to the industry with a focus on value-based care and telehealth services have been the focus of MC4HC platform enhancements. We see several fundamental changes to the data model that enable providers to integrate frontline services more easily with the platform and user experience enhancements focused on care planning and service delivery.

In this article, I go into some critical changes that have either gone into General Availability (GA) in late 2022 or will go into GA sometime in 2023.

Continue reading

Power Apps Figma UI Kit – A Year in Review and Future of Express Design


Figma is a software company that offers an innovative, collaborative design and prototyping tool. It allows designers and teams to create, prototype, and share designs for websites, mobile apps and other digital products.

In May 2022, Microsoft announced plans to integrate with Figma, the collaborative design tool, when they introduced Microsoft’s Express Design.  This enabled auto-generating apps from Figma files and other image files.

Convert Figma files, PDFs, paper forms, and hand drawn sketches into apps with express design in Power Apps.

According to Ryan Cunningham (VP, Power Apps) more than half of the people using AI to generate apps from images or designs are new to the platform, and more than a third of all makers are getting AI-powered suggestions in Power Apps today.

How does Integration work?

Continue reading

Figma UI Kit for Microsoft Power Apps Walkthrough

Microsoft released support for Figma design files in 2022 and allows you to create Power App screens (both tablet and mobile) with pre-defined Power App controls (e.g. Scrollable sections, labels, controls, colours, etc).

Today I’ll do a quick run-through demonstrating how you can quickly create Power App screens using the toolkit and how to import into your Power Apps environment .

« Older posts

© 2024

Theme by Anders NorenUp ↑