I am seeking a solution to use PowerAutomate to download data from MYOB to spreadsheets via SharePoint and upload them to PowerBI integrating this data into our monthly dashboards. Are there any Microsoft PowerAutomate MYOB Connectors available?
Hi LearningGuru,
I see that you’re looking to use PowerAutomate to integrate MYOB data with SharePoint and PowerBI for your dashboards. Currently, there is no direct Microsoft PowerAutomate MYOB connector available. But you can check out the MYOB API. It's a tool that lets you link third-party products with the AccountRight database. You can use it to pull or add info to the database and set it up to do the tasks you need.
Feel free to get in touch if there's anything else I can assist you with.
Cheers,
Princess
Good luck getting that to work.
MYOB's API assumes use of OAuth tokens assigned via a code-grant-flow sequence with their authorization host.
That's doable if you are writing your own webapp and have control of the call-back process to retrieve the authorization code to then request the access & refresh tokens, but problematic with PowerAutomate, where you don't.
If anyone has managed to do it from PowerAutomate, I'd be interested in how.
There seems to be a lot of these limitation with reporting via the MYOB system, as now that there are a lot more accounting software suitable to SMEs and further developed in their capabilities around, would this be further looked into developing at all?
