When you need to insert, update, or delete a large number of records in Dataverse, synchronous plug-ins can get in the way. Asynchronous plug-ins and Power Automate flows are triggered independently (out of process) but can be overwhelming for the system and can be throttled down. Did you know you can bypass either? Did you […]
Tip #1458: How to copy files between Dataverse tables
Explore the intriguing quest of transferring files between tables with Power Automate, as Megan V. Walker delves into a problem that seems straightforward but is fraught with unexpected challenges. Discover a layered approach to solutions, from no-code to high-code methods, and follow the journey that even experienced pros like Chris Piasecki and Guido Pietre weigh in on. It’s a story of integration, automation, and the ever-surprising twists in the world of data management.
Tip #1457: Format JSON for human consumption
Master converting JSON to a human-readable format using code-only connector with our simple three-step Power Automate flow, perfect for any data presentation needs.
Tip #1456: Enumerate and extract JSON object properties
Use Extract JSON code only connector to select only a subset of object properties matching specified regular expression.
Tip #1455: Experiment with parallel branches
Use parallel branches while experimenting with a Power Automate flow actions and save yourself time by quickly finding the solution.
Tip #1454: Azure Blob metadata and index tags in Power Automate
Access blob metadata in two steps: get SAS URL then HTTP request: HEAD to read or PUT to write.
Accessing blob tags is not that easy but get your SAS key that allows tag manipulation elsewhere then come back and finish the job.
Tip #1452: Compare dates in Power Automate
Want to compare dates in Power Automate without a fear to miss that birhtday? We give you 2 rules and 4 functions to deal with it.
Tip #1451: Aggregates in Power Automate
You don’t need an external service to create a fast, robust, and useful custom connector. In this post we demonstrate csv to json conversion and calculations or the aggregates. Source code is available: https://github.com/georged/code-connectors.
Tip #1447: Use Parse JSON for settings
I often see makers declaring multiple settings in a Power Automate flow using a single variable per setting.
Instead, use Parse JSON action and keep your flows compact by combining all related settings in one neat JSON object.
Tip #1446: Empty array in Power Automate
To create an empty array in a Power Automate formula, just use json(‘[]’). That’s it — there’s your entire tip.