PowerApps Dev team and experts
Would you say it is a better dev/user experience so move data from SharePoint to CDS when possible?
My question stems from my current multiple experiences of how erratic the data access is when reading from a SharePoint. Just until last week, my PM system which is developed in PowerApps with SP, stopped showing basic results in a gallery but is storing any new data to SharePoint list.
Such uncertainty does beg a question on the reliability of the existing code set version and approach.
Any insight will help me decide whether to move all my data to CDS for expected reliability.
Thanks
ManishM
Solved! Go to Solution.
When I posted this Azure SQL DB was a standard connector. Since Oct 2019 Microsoft made the Azure SQL DB a premium PowerApps connector so if you have 1 app it is $10/month/user if you have 5 or more apps it is $40/month/app. You also need pay to use Azure SQL DB. The cost depends on the bandwidth you need. I have one app with 5 users and the basic plan has enough bandwidth and works great. The standard plan is $15/month. You can pay a lot more if you need a lot of bandwidth.
Don't sell yourself short on Azure SQL DB. Although SQL Azure SQL DB is very powerful and can be intimidating the basics of what you need for a PowerApp is somewhat simple. You said you know Excel. With Excel VBA you can easily connect to Azure SQL and create very powerful reports. I suggest you be become familiar it even if you use CDS or Sharepoint. You can setup a basic database for $5/month or you can install SQL Server Express (free) on a local machine. You can connect a PowerApp using the data gateway. I developed my app this way and eventually moved it to Azure SQL DB. What was cool about this approach you can use SQL Profiler to see exactly how PowerApps talks to the database. This is very helpful for optimizing performance and debugging problems. There are numerous online courses you can take. There are 100's of books. I have several including 'Azure SQL Database Administration'.
All,
I will throw in my humble opinion here if it assists. Firstly the issue of cost is varying in relevance from insignificant to overwhelming, depending on the depth of the organisation's pockets and the number of users that will access the app. My experience and summary below is based on the premise that it is a very important factor.
We have a Power Apps installation with a complete SharePoint backend (and a couple of older Excel/OneDrive reference lists). It has about 50 active apps using SharePoint lists which also use the Power Apps integrated forms (which in the main are simply copied from the standalone app).
We have in excess of 100 lists and Libraries, some with over 10,000 items and documents in the tens of thousands, including over 30,000 photos in one. Users are in excess of 100 in the field as well as numerous office staff.
The one thing that needs to be managed is the data structure. Anything that is likely to be filtered is plain text or numeric, with all lookup/choice work done in Power Apps, mainly in collections.
Pretty much all things we need this setup has been able to achieve easily.
@WarrenBelzI agree on cost issue. If you look at a medium-large organization PowerApps can be cost prohibitive. Especially if you have numerous apps requiring the $40/month plan. Some users will only have occasional use for some apps. They really need a usage based model like Azure Functions. SQL Server is a very powerful tool for reports, getting information and transforming it. If I did a PowerApp using Sharepoint Lists I would probably create an Azure Function to replicate data in Azure SQL DB on a nightly basis. This way I would have the cost benefit of Sharepoint Lists and reporting benefit of SQL Server.
Thanks @mogulman ,
I actually suggested this (it was SQL) in a post yesterday to a user with cost restraints.
@Yobeekster Have to disagree that CDS is for 'developers'. You can create a complete application with PowerApps, CDS, and if needed Power Automate without ever writing a single line of code.
Hi @Anonymous ,
Yes, I agree that things can be developed without code (or very little) with CDS, but I should clarify, that what I am speaking of has to do with architecture development and troubleshooting. I am also leaning on what developers with CDS experience have said. It is difficult to invest time in CDS when developers don't want to use it OR that they suggest not using it in place of Azure. As time goes on, this will change, I hope.
It is my opinion, that at the time of this writing, CDS be left for developers, and it is something that I steer other non-developers who are contemplating a data source to consider. On the surface, CDS is great, but once you need to peel back a layer underneath, it can get convoluted (like any program). But if its Azure, then there are alot more resources available to help (people and books), as was mentioned by other users.
Dear Community Members, We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd. During this period, members will not be able to Kudo, Comment, or Reply to any posts. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!
We are excited to announce the Summer of Solutions Challenge! This challenge is kicking off on Monday, June 17th and will run for (4) weeks. The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities. Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”) - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024 Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods. You must enter into each weekly Entry Period separately. How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different. Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers. At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing. Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner. A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random. Individuals will be contacted before the announcement with the opportunity to claim or deny the prize. Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners. Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event. ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE** Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08 23 @WarrenBelz 31 @DBO_DV 10 @Amik 19 AmínAA 6 @mmbr1606 12 @rzuber 4 @happyume 7 @Giraldoj 3@ANB 6 (tie) @SpongYe 6 (tie) Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08 10@WarrenBelz 25 @DBO_DV 6@mmbr1606 14 @AmínAA 4 @Amik 12 @royg 3 @ANB 10 @AllanDeCastro 2 @SunilPashikanti 5 @Michaelfp 2 @FLMike 5 @eduardo_izzo 2 Meekou 2 @rzuber 2 @Velegandla 2 @PowerPlatform-P 2 @Micaiah 2 Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27 Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8 SunilPashikanti8
On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners. The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights. Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.
We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for. We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer. Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together. Here's to new beginnings and endless possibilities! If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport. To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages