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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (35,927)