web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Database connection wi...
Power Apps
Answered

Database connection with A1 Plus Plan

(0) ShareShare
ReportReport
Posted on by 101

Good morning,


We are a school and using an A1 plan.  I have just discovered that i cannot use the gateway/SQL connector on this plan.  I have an app that will register a username & password.  I'm wondering with ever tightening budgets, is there a free way to store this information that isn't in an Excel document without having to purchase powerapps Plan 1/2?

 

Thanks.

I have the same question (0)
  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Joko ,

    Firstly,the reason why you can't use gateway is that gateway can only be used in customized environment.And,only Plan2 users can create customized environment.

    Secondly,I would like to check some points:

    1. Do you want to store username & password as a data source?
    2. What do you mean that the information isn't in an Excel document?May be you don't want to use an Excel document as data source?

    Look forward to your reply.

     

     

     

    Best regards,

    Community Support Team _ Phoebe Liu

  • Verified answer
    Joko Profile Picture
    101 on at

    Hi there,

     

    Thanks for replying.

     

    Yeah, so i didn't want users to create passwords and have them stored within plain text and due to our currently plan we cannot use the custom connectors.  So what i have thought to do, is still have the passwords stored in excel but have them more as 4 digit pin numbers.  This stops our staff from using passwords that 'may' be the same as any network passwords.  It's a huge shame that i cannot use my own SQL server, but this is a fitting work around.

     

    Thanks.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 914

#2
11manish Profile Picture

11manish 617

#3
Valantis Profile Picture

Valantis 598

Last 30 days Overall leaderboard