Tag: Marcel Lehmann
-
PowerPlatformTip 37 – ‘Table to JSON’
Are you a frequent user of Power Automate and often come across two-column tables, such as those with ‘Name’ and ‘Value’ columns? If you want a simple way to select individual entries within those tables, look no further! We’ve got a straightforward trick for you that’ll make your Power Automate experience even smoother. Follow these…
-
Upgrade Your Forms Experience: See Why This PowerApps and Power Automate Solution is the Ultimate MS Forms Alternative!
I’m delighted to present the MVP0 of our innovative project, which you can download here. (You can find the setup instructions for this there as well.) The While I’ve thoroughly tested it and resolved significant concerns, I kindly ask for your understanding if you encounter any bugs. Rest assured, ongoing improvements, adjustments, and expansions are…
-
PowerPlatformTip 36 – ‘Static Result’
👨💻💡 If you’re testing Power Automate Flows and want to avoid certain actions, check out the “Static Result” feature! This powerful tool ensures consistency in your workflow results by returning a static result without executing the action. 🚫⏰ 🙌 Whether you’re working with data that needs to remain unchanged or just want to save time…
-
PowerPlatformTip 35 – ‘Concurrent Control’
Use the ‘Concurrency Control Feature’ if u want: If you want to ensure that your flow is handled sequentially and avoid duplicates and conflicts in your data, use Power Automate’s “Concurrency Control” feature and set to 1. Avoid duplicates: Running multiple flows in parallel can lead to duplicates in your data. By setting this feature,…
-
PowerPlatformTip 34 – ‘PowerApps V2’
Use the “PowerApps V2” Trigger 👉 First, you can customize the connection used and run the flow with a service user, for example, making it more secure and manageable. 👉 Second, you can directly define the input type for the trigger, giving you even greater control over how your flow works. 👉 Third, you can…
-
PowerPlatformTip 33 – ‘Coalesce’
To use the Coalesce function in #PowerApps and #PowerAutomate allows you to return the first non-blank value from a list of parameters. This means you can simplify your formulas and reduce the amount of nested If statements needed. You can see also here a Video about that: PowerApps Coalesce Function – Return non blank values from Shane Young…
-
PowerPlatformTip 32 – ‘GroupBy’
Do you create dropdown or combobox lists that depend on other lists, such as categories, subcategories, and additional subcategories? If so, check out this tip to keep your performance optimal! Instead of loading everything multiple times, load all the data only once and always reference it using GroupBy. This way, you’ll avoid using DISTINCT and…
-
PowerPlatformTip 31 – ‘Microsoft Power Platform: Learning Resources’
Are you looking to improve your Power Platform skills? Look no further than the “Microsoft Power Platform: Learning Resources” website! With resources for beginners and experienced users alike, this website offers a comprehensive range of information on administration, development, data integration, and more. If you’re a SharePoint user, there’s even a section dedicated to integrating…
-
PowerPlatformTip 30 – ‘PowerApps – Code Review’
In PowerApps, we can use the AppChecker tool (also known as the stethoscope) to get hints and tips on Formulas, Runtime, Accessibility, and Performance. In 2021, the PowerCat team released the ‘Power Apps Code Review Tool‘, which provides even more insights into your solution. This tool assigns a score and grade to your app, and…
-
PowerPlatformTip 29 – ‘ParseJSON Description’
When we use ParseJSON, we sometimes encounter a problem where there are multiple occurrences of the same name in the DynamicContent, making it difficult to determine which value belongs to which name. To solve this issue, you can use a simple trick: add another line after the Type with “Description”: “YOURDESCRIPTION” in the ParseJSON code.…