PowerApps Writing back to SQL?

[nirvana_moksh]

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.

[Shanescows]

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.

[negiiiin]

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?