Deploy app from Power Automate to Business Central

(0) Share

Report

Posted on by Sergio G

I have the following flow in Power Automate but it doesn't work. I have an .app saved in OneDrive and I want to deploy it to Business Central with Power Automate:

First step is Manual trigger
Second step is Get content file from OneDrive
Last step is Create record in BC through Microsoft Automation API with content file of second step

That flow doesn't work. It throws an error saying: ErrorCode: BadRequest Invalid Request Body

What I am doing wrong? Is this expected to work and this is a bug?

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Although I haven't tested it in detail, I think the third trigger should not use Create Record, it should use Execute action.

Hope this can give you some inspiration.

Thanks.

ZHU

Was this reply helpful? Yes No
Sergio G 42 on at

Like (0)

Report

Thank you for your answer Yun, but I already tested Execute action and you cannot attach a file, it only asks for systemid:

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

I’d try it with the http connector instead. Different scenario but I had to use that for passing pdf email attachments. BC connector just kept throwing an error. Asked MSFT about it on Yammer and got nothing back.

joshanglesea.wordpress.com/.../

For oauth2 authentication with the http connector in PA, you can follow this blog: joshanglesea.wordpress.com/.../

Was this reply helpful? Yes No
Sergio G 42 on at

Like (0)

Report

Of course that with HTTP connector that would work, the thing is that I want to skip OAuth2 step using directly the BC connector. I think that my question should be considered as a bug if no one can use it :/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, thanks for the feedback, I tried it and it does not work......
I suspect that the automation APIs provided by Microsoft do not support the currently released trigger in Power Automate.

More details about automation APIs:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/itpro-introduction-to-automation-apis#upload-extension-file

And as you know, HTTP connector should work but requires authentication.

I have tried to install AppSource Apps via Admin Center API before. Hope this gives you some inspiration too.

https://yzhums.com/12259/

In additional, we can use bound actions in Power Automate. But I'm not sure if the action of uploading the extension can be customized.

More details: https://yzhums.com/20111/

And if you think this is a bug, you can try submitting a service request to MS.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Sergio G 42 on at

Like (0)

Report

I contacted Microsoft and this is what they have said to me:

We have identified the issue about the extension content is a BLOB. Currently, our connector does not support editing of BLOBs

We heard this feedback multiple times and we prioritized it accordingly, so the good news is that this will be fixed in the coming months, although we do not have a precise ETA to share yet.

An potential workaround will be use a direct HTTP call, or a custom connector

Was this reply helpful? Yes No
Verified answer

Marco Mels on at

Like (0)

Report

Thank you for sharing final outcome.

Was this reply helpful? Yes No