PowerApps DS #03 - HOW TO - Power Apps and SQL Server

0:00 - Intro
0:40 - Video Starts
0:56 - SQL Database Structure
2:43 - Connect Power Apps to SQL
6:56 - Filter Function
12:44 - Max, Min, Average, Sum
14:07 - Numeric Filters
17:12 - Text Filters
20:07 - Search Function
21:40 - Operators Filters
22:37 - Date Filters
29:36 - End

🔔If you enjoy my content Please Subscribe!
-----------------------------------------------------------------------------------------------------------------------------------------------------
Follow me on my social Networks:

[sppsghosh]

Thank you Piero for the video! Do you have any video in which you have created canvas which will elaborate the master detail relationship using sql server tables and one master table have 4 details tables. How to do that and also if the detail tables can be updated as well.

[benjisamuel]

your course is very good my friend. actually one of the best. but it has been nice if you create those boxes and all the commands step by steps, so it makes learning easier.

[oluwatobiyusuf]

This video was really insightful. Thank you Piero

[healthspanlane]

Excellent video, Piero! Thanks the clear steps and explanations. Will the filters and functionality on the Home screen work the same way using a gallery grid instead of a data table?

[ojsojs]

Nice tutorial. I have just a question. Using SQL View as Data Source, How to update a specific table only?

I am new to Power Apps. I have an empty vertical gallery with sql view as data source. Let say I have a view name SampleView created at SQL. This SampleView has table1 and table2 joined.If I use Sampleview as data source for empty vertical gallery. How can I update record on table2 only?


Let's say I put Text Input named TextInput1 in the gallery. Its value came from table2. If I modified the value of the first row of TextInput1, how can I update it back on table2?

[.sagnikpaul]

From where we are getting the values which are getting automatically populated in the combo boxes. We are fetching the values from SQL server only? If so, then what is the process?

[AG-mmun]

Hi
Thanks for video.
Apart from this PowerApps/SQL video, have you done any more, specifically for PowerApps Canvas apps and SQL?

[filberful]

Hey Piero. Have you came across a scenario where you didnt have access to all the columns of a table.Is it possible to still perform filter funciton?

[thegauravsinghrawal]

Hi Piero, Could you share the SQL scripts for the tables/views etc. used for this application so that I could try building the same app at my side?

[rohanshaw]

Great video!! I am trying to create a view in SQL server but it keeps saying it is returning no results but when i execute the query on the server I can see the results. Is there something I am missing? If i connect my gallery to another view it works but not my new one. I am using an on prem gateway. any help greatly appreciated.

[akokohjoel]

Pls sir is the SQL serve table on desktop computer then Link to power app?

[sivasaireddy]

When am patch is not submitting the data to SQL table. It is throwing error and error is "Network error when using Patch function . The requested operation is invalid'. Does we need any permission to patch the data into SQL table

[snehalpatil]

This application is of which type ..e.g- canvas/model driven/portal and above screen contains form or gallery...plz reply

[nicholasjeffries]

Amazing video. Is there a way to write SQL statements when connecting to the database? E.g. Select * from colum 1, 2 etc. Like you can do in Power BI

[benjisamuel]

Sir, Is there any way you can tell me how to create the boxes and create the filter step by step i will be thankful.

[varunkumar-uevc]

Hi Piero,
How can we deal with lakh records from SQL server to powerapps?