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.
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?
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
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?
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.
@@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.
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!
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
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