Using SQL Server & Power Apps
Vložit
- čas přidán 4. 08. 2023
- Use a Azure SQL Server database for your Power Apps application! We'll step through how to do this here!
➡️ Get access to our free Power Apps crash course (and our community) here: go.superpowerlabs.co/superlan...
Here are the topics discussed in this video:
- "Big Boy" database?
- Why SQL Server?
- What's wrong with Dataverse?
- Join tables with view
- Stored procedures (must use Power Automate flows)
- Multiple environments or tenants!
- Data needs to be accessed outside the Power Platform
- You can use Dataverse outside Power Platform
- Why not to use SQL Server?
- Cost
- Dataverse could be faster!
- less API layers!
- you can link other data sources with Dataverse, like SQL Server, SharePoint, Excel, Azure AD, etc.
- Complexity (learning curve)
- Overkill the requirements
- No desire to learn any more coding
- SQL - Structured Query Language
- T-SQL - Transact SQL
- How to set up Azure SQL?
- Creating the database
- Creating our Power Apps application
- Using a sample app use case with Chat GPT:
- Onboarding, Engagement, & Satisfaction! - Zábava
➡Playlist: czcams.com/play/PLMgWds5p226mDattAUyg2DzRFjxDHW54w.html
🤝 Need to get some help with your project? Join our community here:
🔗 tinyurl.com/PowerPlatformCommunity or, if you want to work with Darren directly, book Call Here📲 superpowerlabs.store/powerapps-mastery
@19:08 Dataverse also has View, I think for small dataset size, Dataverse views might offer a better performance. On the other hand, larger and more complex datasets, SQL Server views can provide better performance.
Thanks for sharing your knowledge ❤
You are so welcome🥰
I loved this video and can't wait to see the rest of the project unfold!
Question: how does one decide whether to store files in a database (like your image column) or just store links to the files?
Preference 👌
Hello! Thanks for the tutorial. I have a question regarding the unique identifiers… are you tackling that in this video when you save a record automaticly?
Best regards
For the primary keys, we use a field called ID as an identity (sometimes called an auto number). However, you could very easily use a GUID or unique identifier as the primary key. Let me know if I can provide further details or clarification.
@@PowerAppsTutorial thank you for your answer. My question was if adding a record to SQL automatically creates an ID or GUID or do I have to declare it in Power Apps and patch it in a special field?
It depends on the configuration of your table, you can configure your table to automatically assign an ID or a GUID
Dear I used to have an old version of my apps
it was working perfectly so I didn't touch the formula or anything ,,, it expand the gallery perfectly without any errors put so on so far ,,, I think when I update the apps for different modifications not related to this pdf function, the capability is gone ,,,, the last publishing was one year from now ,,, when I update this august the capability gone .... something related to platform update happens by MS them self
You may need to review your formula ☺️
Can we integrated sql server without authentication with powerapps?
Integrating SQL Server with PowerApps without using any form of authentication is not recommended and, in most cases, not supported.
However, if this is your scenario, you can consider using the windows authentication
Is there a part 2 to this? 👍
Sure! Here's the playlist: czcams.com/play/PLMgWds5p226mDattAUyg2DzRFjxDHW54w.html