22-25 April 2026

Translytical Flows vs Embedding a Power App in your report

Proposed session for SQLBits 2026

TL; DR

When the business ask for write back what options do we have? Lets compare Power Apps, Power Automate and the new Translytical flows and see which works for who.

Session Details

You create a brilliant report, it matches all the requirements and then someone asks for write back. They want to add adjustments, commentary or other random ideas. Although we would love to say no, we end up building solutions to provide write back and triggering events. Previously the obvious options have been an embedded Power App or a Power Automate button. Then Microsoft released Translytical Flows that use User Defined Functions to open up the possibilities.

In this session we will demo building this new feature from scratch along side a demo of a simple Power App doing the same write back. Then we will have the fun of comparing the functionality, useability and maybe even the licencing. Who will win?

Plenty of demos, audience participation and time for questions.

3 things you'll get out of this session

Know the pros and cons of using embedded Power Apps vs Translytical flows

Speakers