Load SharePoint Items into Power Apps Without Delegation Limitations

Load SharePoint Items into Power Apps

Loading large datasets into Power Apps galleries or data tables can be a significant challenge in app development, especially when dealing with SharePoint’s 5,000-item limit and Power Apps’ 2,000-delegation row limit. In this blog, we will be discussing how you can easily load all SharePoint items into Power Apps with a simple solution. These constraints often result in incomplete datasets being retrieved from a SharePoint list or library. In practice, delegation issues are difficult to avoid, especially when search, filter, or sort operations are applied to complex columns. The following formula offers a dynamic solution to the challenge of loading large datasets into Power Apps and has been used successfully … Read more

Top 3 Beginner Tips for Developing Canvas Power Apps

Canvas Power Apps is a handy tool from Microsoft that lets you build custom business apps without needing to write any code. Imagine you’re working with a blank canvas where you can drag and drop different elements to design your app’s interface the way you want. You can connect your app to many data sources, like Excel, SharePoint, or third-party services. You can also use Excel-like formulas to add logic and functionality. Canvas Power Apps is perfect for creating apps that work on the web, mobile, or tablet, and you can share them with your team to use on any device. Below, we’ve compiled the top three beginner tips to … Read more

Intranet Migration to SharePoint Creates Consistency and Better Search Functions

A global non-profit organization specializing in health services reached out to Improving Winnipeg to assist them with an intranet migration to SharePoint from their current Interact-hosted environment.  The existing intranet system lacked organization and consistency. Metadata used to tag pages and documents was often inconsistent and redundant, with page authors creating their own terms for content tagging. This lack of standardized terminology made it difficult to search and filter resources effectively. Additionally, there was ambiguity around content ownership, and the absence of clear responsibilities led to numerous outdated pages and documents.  Based on the issues our client was facing, it was clear they were in need of an intranet migration … Read more

Front-End Modernization and Responsive Design Enhancement Betters User Experience 

An internet-based reservation portal was using an outdated website that was no longer in line with corporate standards or current business practices. The company also wanted to change its reservation process to reduce the number of interactions customers needed to complete an order. They were in need of a front-end modernization. To help the client, we started a review of the current website and the user workflows by engaging with our UX team to perform analysis and redesign. After iterating on the design with the client, we implemented the redesign of both the look and feel of the site as well as the ordering process. The redesign included designs for desktop, … Read more

Automated Data Parsing Saves Time & Better Allocates Resources

A provider of real estate advisory services contacted Imaginet because they were loading large amounts of data into their databases using a batch process as opposed to automated data parsing. The data being loaded was used for making critical business decisions. All the data being loaded required validation and much of it required transformation as it came from disparate sources, each using their own document standards. The process that loaded the data was very manual, taking a lot of effort from multiple people.  Automated Data Parsing Setup We created a process where a user could upload the excel file and have it processed automatically. When the file was loaded it … Read more

Industry 4.0 – Part 1 – The History 

Industry 4.0

What is Industry 4.0 Industry 4.0 is a term that has been around for about a decade already. Also known as the fourth industrial revolution, it’s a term that’s quietly slipped by a lot of people’s radars. A quick recap is required. The first industrial revolution occurred in the late 1700’s with the advent of steam and coal power and genesis of the manufacturing industry taking over from agriculture as the backbone of the global economy.   The second industrial revolution took place in the late 1800’s and early 1900’s with the onset of new energy sources, electricity, oil, and gas, along with process refinements in the factory such as the … Read more