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 #1450: Create Dataverse app users like a boss using pac cli
Creating an app user is now as simple as running “pac admin create-service-principal” command.
Tip #1449: Formula columns love calculated columns
Can’t return the data type you need from a formula column? Do your homework then create a calculated column that simply casts to the correct type.
Tip #1448: Never delete columns in translation
Dealing with Dataverse translation file? Never delete columns. But you are free to delete rows and tabs.