This week's workshop is about how to get all set up as a Power Apps freelancer. It is this Friday, 4/5/24 at 1pm EST. - Set up your freelancing profile (Fiverr & Upwork) - Advice on how to market and sell your services - Typical earnings - How to create estimates - How to spot difficult clients - The best way to gather requirements - How to set up your business finances (bank accounts) - ...and any related topics you guys bring up Pick from these 4 options that works best for you: 🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥🚥 1️⃣ Unlimited Membership - Dive into all our workshops! Access live, past, and future on-demand sessions for just $147/mo. Perfect for the enthusiastic learner. Sign Up Now 2️⃣ All On-Demand Membership - Love learning at your own pace? Get all past and future workshops on-demand for $97/mo. (Excludes live workshops) Join Here 3️⃣ One Live Workshop - Experience the live interaction and learning for just a one-time fee of $47. Reserve Your Spot 4️⃣ Single On-Demand - Just want this workshop? Access it on-demand for only $25. Get It Here

Struggling with the basics are the thing of the past after this workshop. So far, the workshops have focused on building a types of apps, but this one is to make sure everyone has the basics down. This will start at 1pm EST on 3/22/24 and will go for at least 3 but no longer than 4 hours. Topics that will be covered: - Understanding the purpose and capabilities of Power Apps - Navigating the Power Apps Studio - Basic functionalities and menus - Introduction to Canvas Apps and Model-driven Apps - Understanding the difference between them - Step-by-step creation of a simple Canvas app - Adding text boxes, labels, and buttons to a Canvas app - Basic properties of controls - Designing a basic user interface - Arranging controls on a screen - Adding and linking multiple screens in a Canvas app - Understanding the formula bar - Simple formulas for basic interactivity - Displaying lists of items with galleries - Basic customization of galleries - Connecting your app to data sources - Using controls to display a listing of data - Adding and using forms for data input - Changing app themes and colors - Customizing the look and feel of your app - How to save, publish, and share your app with others - Incorporating images and media into your app - Implementing basic search functionality in data galleries - Understanding how to trigger simple flows from Power Apps - Understanding and using basic variables and collections - Basic techniques for testing and debugging your app - Changing control properties based on conditions - Providing user feedback and simple error messages - There will be lab time for you to put your new knowledge to work - Question & Answer - Recommendations on where to go from these basics Post any questions you may have below in the comments section! See you there! 1️⃣ Unlimited Membership - Dive into all our workshops! Access live, past, and future on-demand sessions for just $147/mo. Perfect for the enthusiastic learner. Sign Up Now

SharePoint lists can handle a large number of items, but performance can start to degrade if not managed properly. Microsoft has set the threshold for a large list in SharePoint at 5,000 items, which is the List View Threshold (LVT). This is the point at which the platform may start applying stricter querying limits to prevent large queries from negatively impacting server performance. However, a SharePoint list can technically store up to 30 million items. The key to maintaining performance with large lists is in how you access and work with the data: 1. Indexing: Ensure that columns you frequently query are indexed. Indexing columns can dramatically improve performance when filtering and sorting data in large lists. 2. Views: Use filtered views that return less than the LVT. Carefully design views to show only the items needed. Use filters and specify the most restrictive filters first. 3. Queries: When designing queries (e.g., in CAML or OData), make sure they target indexed columns and return less than the LVT. 4. Archiving: Consider archiving old items that are not accessed frequently to another list or database. 5. Folders: Use folders to organize items in a way that ensures any view within a folder does not exceed the LVT. 6. Batch Operations: When working with data programmatically, use batch operations to limit the number of round trips to the server. Remember that the threshold is not about the total number of items in the list, but rather the number of items a database operation can involve at one time. Good list design and management can help ensure that your SharePoint list remains responsive and performant even as it grows.

Give it up for the new members of this community! Please introduce and tell us about yourself here. 😃👍