I have a VERY simple use case. I have formal Table in an Excel file and I just want to publish this as read-only "list" like an app on my mobile device. Not even for multiple users, just for personal use. I was able get this into the Microsoft Lists app, but from what I can see, this only allows import of csv? Not Excel? And no way to keep that source in sync with the source file? No way to make updates in Excel and "refresh" the app to see the updates?
I tried Power Automate, but working through the actions, I see that I can only make this work with OneDrive for business (source Excel file) and SharePoint Lists (target "app side"). No visibility to Microsoft Lists.
From what I've pieced together, this is because I have Personal Office 365 subscription, and Power Automate could work for this if I had an Enterprise subscription.
I still wanted to pursue this so I stumbled onto Google appsheet (also a few other paid services). But since appsheet was free for this one user, personal use "app" I tried that.
Turns out it works perfectly! I can even provide appsheet with the URL for my Excel file (.xlsm, macro sheet no less) on OneDrive. So, I make updates there, and with nothing more than a simple refresh, my "app" on the mobile phone gets those updates.
I'd rather not use Google at all for this. Everything else about this works from Excel (Office 365 personal subscription). Including VBA, and PowerQuery. But, no path to use Power Automate for updates and syncing so something on my mobile device. Using a browser, or opening Excel are not viable options. Microsoft Lists could work, but again not path to automate.
Seems like Microsoft is losing our or a little behind with something like this, especially for such a simple use case that I can do for free using Google appsheet.
As far as it goes, I'd even pay (some small subscription fee) if there was a more robust back end to Personal Office 365.
Just wondering if I am missing something about how Personal Office 365 works with Power Automate. Or, if I am missing some other way to automate or sync an Excel file with a Microsoft list - under the constraint of the Personal Office 365 subscription
Share
Report
All responses (
Answers (
525
