Fast synchronous logic processing?

(0) Share

Report

Posted on by dgray304

176

All,

Need to run fast synchronous functions (logic)(multiple tables involved) that run on dataverse events (CRUD).

I first looked at Power Automate. Works, but runs async. So, would allow overlap. Not exact enough. I want synchronous, cuz it matters when things change (seconds delay).

I tried Azure Logic Apps - way too slow 3-6 seconds for simple record update.

I tried the 'Dataverse Accelerator' app to create low-code plugins. But writing PowerFx in it's editor is a nightmare. Won't accept code straight from the documentation.

I like the plugins, cuz they can run synchronous. Giving me the exactness I need. But a pain getting the editor to accept valid code.

So I looked at the new Dataverse Functions. But these are not triggerable on dataverse events.

Or, give up on the platform interface tools and just write C# plugins?

What have you guys sorted in regards to writing logic in Power Platform?

Thanks,
Doug

Categories:

Power Platform Build Tools

I have the same question (0)

All responses (4)

Answers (1)

Michael E. Gernaey 47,125 Super User 2025 Season 2 on at

Like (0)

Report

Fast synchronous logic processing?

@dgray304 @Pstork1

It's not accurate to say "Power Platform" isn't made for it, it's just not true.

Model-Driven applications are Power Platform and have supported transactional forever.

It is true, that the best way to get a "generic" transaction you can build plugins, or use some of the built in ones.

But the details of your ask are still too generic to just toss out anything.

Also, when we talk about Performance... Whether you use unbound actions (which are plugins) from PA, or JavaScript, or from Triggered plugins, everything still depends on what you are building.

If I want to write to 3 Tables within a transaction, you would build something true, but what triggers it? The UI itself, is it a Canvas App, is it a Flow? is it a Modal Driven app

Plugins don't just "run" in the way you are referring so performance is relative end to end, unless you are only caring about how fast the data is stored or rolled back.

Are you looking at Business Processes? Also power automate aka power platform.

I would write up what the end to end business process looks like, then you can better determine what the whole thing looks like, versus simply saying "plugins" solve my problem /shrug

Was this reply helpful? Yes No
dgray304 176 on at

Like (0)

Report

Fast synchronous logic processing?

@Pstork1, What you say is what I'm finding out.

Subject task: It is an inventory control system.

Looks like only C# plugins or low-code plugins support locking, rollback and the performance I want.

Appreciated.

Doug

Was this reply helpful? Yes No
Verified answer

Pstork1 67,398 Most Valuable Professional on at

Like (0)

Report

Fast synchronous logic processing?

Low Code tools are great for a lot of things. But it sounds like you are trying to build a real time transactional system. Low code simply isn't appropriate for that kind of project. You need to look at more traditional development methods that let you do actual transactions that can be rolled back and that provide for synchronous execution. Power Automate isn't designed to do that. I don't know of any low code system that is.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Michael E. Gernaey 47,125 Super User 2025 Season 2 on at

Like (0)

Report

Fast synchronous logic processing?

Hi @dgray304

Your comments are far too generic. Just saying it doesn't do X without showing what you are doing, is .. not something we can help with.

Also your ask is not clear, just saying you want Sync, doesn't truly describe what you need as you infer things have to happen in order but with no details.

So, if you explain what you need in detail we can help.

As for things running synchronously, unless you are literally doing overlapping things its always going to be synchronous to that "thing" you are doing at that time.

So what is the process, the steps, the data activities you need to done in a "group/transaction" to make them be "serialized".

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No