Microsoft SQL Connector for Power Apps and Power Automate

[@babukurapati3822]

Always rocks, very helpful Deepak!, Thank you so much again Deepak!

[@DeepakShrivastava]

Thank you 🙏🏻

[@josephjojo756]

I have a flow which runs stored procedure from SQL on-premise. The flow triggers from PowerApps button control onSelect event. I have shared the app with end users, but they are not able to trigger the flow. Do we need to share the data gateway with end user?

[@mardithpascua8112]

Is it possible to change the SQL Server instance dynamically with the same data schema for the tables?

[@mickjaeger7127]

Do you have any videos about using Insert Rows (V2) in Flow? I'm grabbing data from an API parsing the JSON then use an Apply to Each block to insert the rows to SQL Server. Microsoft's documentation is weak in this area and my flow does insert data, but only NULLs :/ So sad!

[@gfreemankz]

Hi Deepak, could you please advise how you deal with the sharing issue? As you mentioned in the video, the problem with SQL server approach is that when you share the app with users, they will be able to modify data in SQL Server database since they received the db connection implicitly. Explicit connection is not a consideration also, since for writing data users need write permissions and I cannot simply grant them write SQL permissions to the database. So, basically, how can we let other users use the app fully (with all CRUD operations) without granting db permissions to them?

[@DeepakShrivastava]

You can try a few options, create a dedicated SQL account for your database so "connection" access will be limited to only your database. OR you need to set up an interim list/table where the user can submit the data, and then you can use a separate power automate flow to write it to the SQL table.

[@gfreemankz]

@@DeepakShrivastava yeah but even in these cases user is still able to modify other users’ entered data. Anyway. I managed to solve this issue by simply creating a new environment and removing “App Maker” access from users.

[@gfreemankz]

@@DeepakShrivastava thanks man!

[@brahmakiran6474]

Hi deepak, for updating the data in sql we have to do modifications in db Or not

[@brahmakiran6474]

Iam also in the same boat, could you pls provide an sample or link

[@temesgennissrane7582]

Very good explanation, but I was expecting how you are going to connect the flow to Power App and create the screens in power apps. I will be happy if you can explain that too. Thank you.

[@vineetwadhwa5915]

Superb video! Keep making new videos on Power platform🔥

[@DeepakShrivastava]

Thanks 🙏🏻 for watching.

[@trieutrinh2]

Does Office 365 E1 have premium connector?

[@shaikhsufiyan73]

Hi deepak how can we change the SQL connection reference , DB & server name in PROD environment dynamically

[@luisfernandomacedo1451]

Great! Did you release the video with more complex scenario?

[@rajad7261]

Hi rockey, I has been facing one issue, I have 4 different types datasources and also 4 users ,how to share one datasource to one user

[@harriscastro535]

I have a question please. How to share sql server conmections to a group with On premises gateway?

[@2007pradipta]

Can I escape multiple license ( Premium license for each user consuming ) in Automate ? it seem every one need Premium license.

[@dkanoongo]

Thanks for this informative video. I want to add shared Power Automate flows to my solution which are Powerapps button triggered,but I am unable to see them to add in solution.Please assist

[@DeepakShrivastava]

Thanks for watching. Could you please elaborate your question i am not very clear.

[@prabhakaranshanmugam5295]

Very informative as usual.. Please start a series on model driven apps and data verse..

[@DeepakShrivastava]

Thank you 🙏🏻. I will plan for it.

[@saurabhgoel6725]

Thanks for the wonderful and informative video. How do we deal with the Premium connector issue. What exactly does it imply?

[@ammadkhan4687]

Hi Deepak, I am learning Power Apps for my personal interest. My Company is not Supporting power Apps as they say, that it needs to have seperate license to share the apps with the users. I have informed them that we are already subcribed to M E3 License which has Power Apps. Only when we use premium connector then we need extra premium license for the user. I can understand their point of view. I am just curious, why companies are still investing in Power Platform? I mean at the end it actually for long run will cost them more then making a Solution based on other Old school Programming or Software development concept. I will be very glad if you could make some good selling points video on that particular scenario. Thank you very much for your beautiful effort. I really enjoy your content. Best Regards Ammad

[@praveenbandari558]

Sir please make a video on adding export button in power apps. That export button needs to export data from SQL server query whenever we select date ranges i.e. 10-11-2022 to 10-12-2022

[@sathishkumararava4985]

Hi Deepak, When users is added to office365 group, that user need to added to sharepoin user..! By using power automate. can you help me please

[@DeepakShrivastava]

Let me check you can do it using http rest api. Check out my video kzbin.info/www/bejne/eqWqiKiaebCtfsk

[@srikanthe1466]

Q.) With out using sql connector how to connect to sql server?

[@sahilgoyal5372]

Hi Deepak, How are you? I would like to connect with you for some discussion. is there any way to connect via telephone, LinkeDIn

[@DeepakShrivastava]

Please send me a message on LinkedIn or Twitter