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

Notifications

Announcements

Community site session details

Community site session details

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

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard