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.
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.
Use Extract JSON code only connector to select only a subset of object properties matching specified regular expression.
Use parallel branches while experimenting with a Power Automate flow actions and save yourself time by quickly finding the solution.
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.
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.
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.
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.
To create an empty array in a Power Automate formula, just use json(‘[]’). That’s it — there’s your entire tip.
Today’s tip is from Matt Collins-Jones. (Have a tip of your own? Send it to jar@crmtipoftheday.com) I (MCJ that is – t.j) was building a flow yesterday and I was using the manual flow trigger and wanted to upload a document/file. I was in the classic UI and I noticed I couldn’t get the name […]
of the