Announcements
Hi @Anonymous
I think the entry you're seeing there refers to the number of Flow runs.
With Office 365 (F1), you're entitiled to 2k Flow runs per license as shown in link below. Flow runs are aggregated per organisation so with 5 F1 license, that would account for 10k license.
https://flow.microsoft.com/en-us/pricing/
I'm certain that the entry you see doesn't give you access to on-premises SQL server, or custom connectors. For that, you'll need either a P1 or P2 license.
It's also worth noting that all of this changes in October. From that point, you'll need to license on a per user or per app basis to SQL and custom connectors, and there are more details in this blog post.
https://powerapps.microsoft.com/en-us/blog/new-licensing-options-for-powerapps-and-flow/
F1 licenses include PowerApps and Flow licenses. The special limitation on those licenses is the following:
AS described in this official article https://docs.microsoft.com/en-us/office365/servicedescriptions/office-365-platform-service-description/office-365-platform-service-description
Other normal restrictions apply to premium services like custom connectors and on-premises gateways. But there is no limitation on read/write access to data. F1 license users can't create or share apps, but they can run apps and use their full functionality.
The problem in your scenario is that the SQL server is on-premises. Although the SQL connector is standard and available for use by F1 licensed users, you will need an on-premises gateway to access the SQL server. Gateways are an premium feature and require either a P1 or P2 license. The 10,000 existing licenses that you have won't cover this functionality either, since they are undoubtedly standard licenses.
However, an Azure based SQL server can be accessed without a gateway. So if the database in question where moved to Azure then the F1 users could access it with their existing F1 license. The only thing that would be needed would be a regular licensed user to create and share the app with them.
Hi Pstork, on the off chance you're able to answer with current information, the link you provided now details that F1 does not provide Power Automate or Power Apps access, so wondering if there is anything to substantiate that F1 can interact with flows and power apps without any additional licenses being purchased.Cheers,
Sorry, that is evidently a new change. As I mentioned in the past F1 licenses could run Power Apps or Power Automate flows, but they couldn't edit them. Now it appears that an F3 license is needed for F class licenses to use Power Apps. The post with the link was from 2019. At that point in time F1 licenses were able to use the Power Platform.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 493 Most Valuable Professional
11manish 479
Haque 328
