cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirvana_moksh
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
negiiiin
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,052)