PowerApps inbuilt database server availability (sql to read/write from PowerApps) with standard plan

(0) Share

Report

Posted on by Ashok-Tati99

Hey Guys..

I'm developing powerApps with standard plan. (Poor 😞 we dnt hv plan 1 or plan2 and so no CDS).

Does PowerApps has any internal db sql server availability wher I can read/write data from Apps? If Yes does it has any limitations like flushes after few day?

What is the best way to store data(SQL) from powerApps with standard plan.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

PowerApps doesn't come with a backend data source for storing data. If you have an Azure subscription then you could spin up a Azure SQL DB. It isn't free but you don't have to buy a license for every user and if it is a small database it won't be that expensive. If you and your users have a O365 license then you could use SharePoint or an Excel spreadsheet as a data source.

Was this reply helpful? Yes No
Ashok-Tati99 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks Jeff!! Helpful information. Is there any link which clinically show how to create/save/retirve data from share point on to powerApps.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hey,

on the internet there is plany of tutorials and helpful materials to work with Sharepint and Powerapps.

Eg.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online
https://jobs.collab365.community/powerapps-tutorial-how-to-build-your-first-powerapp/

Was this reply helpful? Yes No