Should You Ever Use SharePoint as a Power Apps Data Source?

Подписаться 19 тыс.

Просмотров 4,8 тыс.

50% 1

Should You Use a SharePoint List as a Data Source with Microsoft Power Apps?
🔹 In this comprehensive guide, we dive deep into using SharePoint as the primary data source for Power Apps. With over 70% of Power Apps users preferring SharePoint, this video is a must-watch for both beginners and seasoned pros.
🍬 Get my free video course, access to my free community
www.skool.com/power-apps-comm... ⬅️
-Darren Neese with PowerApps Tutorial
🔹 Chapters Include:
SharePoint as a Data Source: Discover why it’s a popular choice.
Premium Licensing & Data Sources: Explore cost-effective alternatives.
IT Permissions & SharePoint: Navigating the world of corporate IT.
Multiple Apps & SharePoint Challenges: Strategies for efficient app management.
Editing SharePoint Screens with Power Apps: Tips for customization.
SharePoint Lists: The ease and challenges of managing data.
Security Aspects in SharePoint: Balancing access and control.
🔹 Whether you’re dealing with licensing questions, IT permissions, or data visualization, this video covers it all. We also discuss the pros and cons of SharePoint, offering valuable insights for Power Apps developers.
🔹 Key Takeaways:
Understand SharePoint's role in Power Apps development.
Learn to navigate IT restrictions and permissions.
Master the art of list creation and data management in SharePoint.
Discover tips for optimizing SharePoint’s integration with Power Apps.
🔹 Don’t forget to like, share, and subscribe for more in-depth guides on Power Apps. Your support helps us create content that empowers the Power Apps community!
00:00 - SharePoint as a Data Source for Power Apps
00:59 - Premium Licensing and Data Sources
02:03 - IT Permissions and SharePoint
02:41 - Challenges with Multiple Apps and SharePoint
04:32 - Editing SharePoint Screens with Power Apps
05:35 - Ease of Creating Lists in SharePoint
06:17 - Views and Data Visualization
07:04 - Security and Soft Security in SharePoint
16:15 - Column Naming and Importing Data
17:38 - The Value of Knowing ASCII Codes
18:32 - Challenges in Renaming Columns
20:22 - Dealing with Complex Data Types
21:01 - Handling Choice Data Types
21:41 - Drawbacks of Complex Data Types
22:41 - Understanding ID Fields in SharePoint
23:30 - Effectiveness of Boolean Data Type
24:09 - Handling Pictures and Images
#DarrenNeese
#PowerAppsTutorial
#PowerApps
#SharePoint

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@PowerAppsTutorial 6 месяцев назад

🍬 Get my free video course, access to my free community www.skool.com/power-apps-community ⬅

@AndrewBrewster-ti9ei 6 месяцев назад

Additional list security settings: Turn off Edit in grid view in list settings > Advanced. Also set a custom permission level on the site and apply it to a permission group for the list that allows ordinary users to add/edit/delete as required, plus prevents them from creating their own views too. Turn off RSS for the list so people cannot subscribe to the list to get at list data without SharePoint forms.

@rockabillyron 6 месяцев назад

I mostly use 'Users can only see and edit their own records' in Advanced settings too. And give a SP group (with a few people) full rights on the list.

@skjones91199 6 месяцев назад

We have an automated process for requesting SharePoint sites via a flow approval, which also creates the site (well, I created it so I'm biased!). Thanks for the great information!

@jisaperez4909 6 месяцев назад

This is a good video. Very informative and helpful :D

@PowerAppsTutorial 6 месяцев назад

Thank you, Jisa!

@SarahGallardo-hd7vg 6 месяцев назад

Great video! 👍🏽 Clear and insightful discussion on using SharePoint as a Power Apps data source. Definitely will help many to weigh the pros and cons. Thanks for breaking it down! 🔍💡 #PowerApps #SharePoint #DataSources

@PowerAppsTutorial 6 месяцев назад

Thank you!

@SuPern0vA72 6 месяцев назад

Great content and format of presentation. Agree with all points made on SharePoint. It would be really helpful if you could create videos on how to configure/setup Dataverse (you mentioned it’s a bit more involved) , differences from SharePoint (eg guid instead of ID), and column types to avoid in databerse (would you still avoid lookups in databerse for example) Thank you and looking forward to future content

@PowerAppsTutorial 6 месяцев назад

Thank you for your positive feedback! I appreciate your suggestions on Dataverse content, and I'll definitely create videos on configuring Dataverse, highlighting differences from SharePoint, and discussing column types to avoid. Stay tuned for upcoming content, and feel free to share more suggestions. Your support means a lot! Join my free community for more content: www.skool.com/power-apps-community

@henriquedelafonte283 6 месяцев назад

thats a great discussion!

@PowerAppsTutorial 6 месяцев назад

Thank you!

@skjones91199 6 месяцев назад

Also, I've found it's easier to just use JSON formatting for SharePoint forms modifications (unless you use that cool technique to keep ppl from editing the list in SharePoint).

@DonCurrier 6 месяцев назад

You mean integrating Powerapps to create a new form so users have to use the app. We do that. And we use JSON formatting as well.

@skjones91199 6 месяцев назад

@@DonCurrier great!

@MrDashingAshish 3 месяца назад

Much helpful

@PowerAppsTutorial 3 месяца назад

Glad you liked it!🚀

@nickfurry9679 6 месяцев назад

Nice discussion, but i think im still gonna use SharePoint as datasource for now. hahahaha (the licensing for the premium stuff is too hard T-T)

@natcongreso2763 5 месяцев назад

Hi, I think I was able to do a workaround on one of the "CONS" which is "User wondering on your sharepoint data and modify directly". So what I did is to utilize power automate get,delete,add,edit items and made the powerautomate run only users using my account. From that flow all data are passed to power apps and used parsejson to put them on a collection. But the sad thing is i cant use Forms :D, so I made my own from scratch, then pass back the data using powerautomate again to sharepoint. I hope you get where Im going :P

@PowerAppsTutorial 5 месяцев назад

Nice workaround 👍

@andrewhess123 6 месяцев назад

Dang, I should of been here for this topic! I could talk for days!😀

@PowerAppsTutorial 6 месяцев назад

Awe... would have loved to have you in on it, man!

@vazaruspaytonas7017 6 месяцев назад

Wait don't use people picker column type? So what do you use in place of people picker column in both the list and the power app?

@PowerAppsTutorial 6 месяцев назад

You may want to avoid the People Picker column due to deletion issues. You can create a custom list that will contain the required users 😊

@vazaruspaytonas7017 6 месяцев назад

I will have to research how to do this. So use the office connectors and store as string in text column?@@PowerAppsTutorial

@PowerAppsTutorial 5 месяцев назад

You can create a sharepoint list and add the users manually

@shishirjakhmola5104 6 месяцев назад

I know SharePoint is not a Relational Database but I have no convincing argument to support it. Can you please help.

@PowerAppsTutorial 6 месяцев назад

Sure! SharePoint is primarily designed as a document management and storage system, not as a relational database. While it offers some features similar to relational databases, like lists and columns, it lacks key relational database characteristics. For instance, it doesn't support complex relationships like many-to-many or one-to-many without workarounds, and it doesn't offer the same level of query optimization or data integrity features that relational databases provide. SharePoint is more about collaboration and content management, whereas relational databases are designed for complex data relationships and high-volume data transactions.