cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anthony_Bellai
Frequent Visitor

Is it possible to have data filled out via power apps drop to an sql table?

Im builidng an app for a school district that will allow certain faculty to mark certain students as chronically absent and then whether or not they are still enrolled or if they have left the district. Following filling out the app I want the info to be stored in a table on sql. Student ID blank with address blank moves to a table for students who are found to no longer be attending school in this district while studentID blank is still attending they return to the table of all students which is where im pulling the data from to begin with. Please let me know what you guys think.

1 REPLY 1
LRVinNC
Super User
Super User

Absolutely.  You can store data in SQL, Sharepoint, Excel - just about anything.  The simplest way is to use an edit form which manages much of the update process for you when you execute a SubmitForm.  Or you can control the writes to your data source yourself using the Patch function.  Either way, it can write your data to the data store of your choice.  


There are a number of videos on connecting apps to data sources.  There are only minor differences between the different varieties.  Here's a very basic video on connecting to SQL Server:  https://www.youtube.com/watch?v=eqaEVsh4byQ.

I recommend any videos by Shane Young, but in particular:
PowerApps Forms - Introduction to data sources, data cards and layout

PowerApps with a Sharepoint List - even though this is Sharepoint, the concepts are the same.



LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (841)