Tag: PowerPlatform
-
PowerPlatformTip 64 – ‘Comparing Lookup vs. First(Filter)’
In #PowerApps, when you need to retrieve the first record that meets certain criteria from a data source, you have options! π§ First(Filter(Source, Condition)) and Lookup(Source, Condition) both accomplish the same goal. However, letβs talk simplicity and consistency! π First(Filter(Source, Condition)) might look a bit more complex but hereβs the kicker: using this method can…
-
PowerPlatformTip 63 – ‘Mastering the Lookup Function’
In Power Apps, the Lookup function is a powerful tool for finding and returning the first record that matches certain criteria! But the way you use it can make a huge difference. Let’s clarify it:π 1οΈβ£ Lookup(Source, Condition, COLUMN): This syntax directly returns the desired COLUMN’s value from the first record that matches the filter…
-
π Sharepoint Helper: PowerApps & Power Automate for Effortless List Management π
Managing SharePoint lists can be quite time-consuming, especially when working in development (DEV) and production (PROD) environments. The process of creating, copying, or expanding lists often feels like a chore. Well, not anymore! Here’s a SharePoint helper that’s going to save you a ton of time and make managing SharePoint lists a breeze. Introducing the…
-
PowerPlatformTip 62 – ‘UpdateIf’
When it comes to data manipulation in Power Apps, the UpdateIf function is your ally! Here’s why:π π Flexibility: UpdateIf allows you to modify specific records in a collection that meet certain criteria! No need to loop through each record! π π Efficiency: Save time and make your app more performant! β³π Here’s a simple…
-
PowerPlatformTip 61 β βPower of Environment Variablesβ
Ever wondered why Environment Variables in Power Apps and Power Automate are akin to secret superpowers? π¦ΈββοΈ Let’s delve in! π€ 1οΈβ£ Portability: Say goodbye to hardcoding! With environment variables, you can effortlessly transfer your solutions across environments. No strings attached! π«π 2οΈβ£ Manageability: Imagine having a central command center for all your configuration settings.…
-
PowerPlatformTip 60 – ‘Power Platform Challenges’
One of the best ways to enhance your skills and knowledge in the Power Platform ecosystem is by embracing challenges. Let’s talk about Miguel Verweij’s monthly “Power Platform Challenge“! π― These monthly challenges, expertly crafted by Miguel, serve as a fantastic opportunity to learn, experiment, and stretch your Power Platform capabilities. They cover a wide…
-
PowerPlatformTip 59 -‘Handle Dynamic Content’
When working with Power Automate and dealing with objects or arrays, you may often come across dynamic content and expressions like item()[‘id’]. But what if the ‘id’ is not always present in each item? This is where item()?[‘id’] comes in handy.π The ?Β is called the ‘safe navigation operator.’ It ensures that even if ‘id’ is…
-
PowerPlatformTip 58 β βHTTP Actions’β
It’s all about harnessing the power of HTTP actions in PowerAutomate. These versatile tools allow you to interact with a wide array of web services using HTTP requests. Action Description Type ActionType HTTP to SharePoint Manage SharePoint list items and files Standard π Action HTTP – Office 365 Outlook Send emails, schedule events, manage contacts…
-
Simplify Team and (private) Channel Creation without premium
Often, creating standard and private channels involves navigating through complex permissions or setups. But what if it could be straightforward and accessible for everyone? This very thought sparked the idea for my app. The beauty of this app lies in its simplicity. It’s a fusion of a Canvas App and a Flow. What does this…
-
PowerPlatformTip 57 – ‘Mastering PATCH’
We often use the PATCH function to modify individual records, but did you know it can PATCH an entire table at once? π―π Patching a table instead of individual rows offers several compelling benefits: πΉ Efficiency: PATCH lets you update or insert multiple records simultaneously, turbocharging your app’s speed and responsiveness. ππ¨ πΉ Data Integrity:…