cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

PowerApps Writing back to SQL?

I have an app which is up and running and writes back to Excel Online hosted on OneDrive. We do not find this a secure way as we have to give users of the Power App edit access to the Excel Online as well to successfully make the comment/write back.

 

We want to replace this with a On-Prem SQL Server Table. I am unsure of what rights are needed for the SQL Table besides reader and writer and how to go about replacing this Excel Online connection and how to go about making this happen. 

 

Any documentation/advice would be really helpful.

21 REPLIES 21

That is great news. 🙂 Thanks for sharing the details. 

 

Be sure to mark the posts that helped you as answers so others can find them in the future.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
New Member

Good day all,

 

I am truly new in powerapps but I have good knowledge in Powerbi,

I need to pass user input from powerapp (I used to do that using powerBI but didnt meet my requirments)to sql to create a new table then run some R program on that table,

I mean pass 3 series of value to sql as below:

SELECT series1,series2

FROM MY_TABLE

WHERE row in (series3)

Can anyone help me about that?

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,489)