Daniel Amundsen’s Post

"Readability" A lot of choices I make when designing a Power Automate flows concern readability. I always try to make my flows understandable for each and every engineer that sees it, which could possibly cause a less popular decision every now and then. Problem? Well, no, readability is not (per se) the enemy of performance or best practice, but they are swimming in the same pool. #ConsultantLife

🚀 Power Automate’s Copilot: AI Simplifying Automation! In my latest tutorial, I explore how AI-powered Copilot is revolutionising Power Automate workflows. Whether you’re new to automation or already familiar with Power Automate, this video offers hands-on examples, limitations, and fun insights into what Copilot can (and can’t) do. You’ll learn: ✅ How to generate flows with simple prompts ✅ Automating tasks like saving Microsoft Forms responses to SharePoint and refreshing Power BI datasets ✅ Using GPT-powered prompts to enhance workflows—like custom replies for sentiment analysis While Copilot makes automation more accessible, it’s not without its challenges. I’ll share a funny live demo storywhere Copilot worked perfectly (much to my surprise!) and explain where it still struggles, such as creating detailed documentation. This video is perfect for anyone curious about AI in automation, beginners looking to get started with Power Automate, or advanced users wanting to experiment with AI-driven workflows. 🔗 Check it out here: https://lnkd.in/gm34WRDE Have you tried Copilot in Power Automate yet? I’d love to hear about your experiences and favourite use cases! Drop a comment below! 👇 #PowerAutomate #AdventOfAutomation #CoPilot #GPT #ChatGPT

#PowerAutomate #Copilot is making automation easier than ever! In this tutorial, I share practical examples, surprising insights, and tips to get the most out of AI-powered workflows. From saving Microsoft Forms responses to SharePoint to using #GPT -powered prompts for custom replies, you’ll see Copilot in action—along with its current limitations. Check it out and let me know how you’re using Copilot! #AdventOfAutomation

How did I turn a 5-hour task into just 2 minutes? Give a tech-savvy, data-driven enthusiast like me some boring, repetitive tasks and Power Automate, then watch the magic happen! I’ll automate the boring out of these chores faster than you can type your “Ctrl+C, Ctrl+V!” From scratch, armed with tons of YouTube tutorials, coffee, and late nights, I taught myself Power Automate. Saving myself a bunch of time for actual added value functions rather than on easily automated admin tasks. Saying goodbye for good to monotony and hello to efficiency Who knew that a bit of self-learning and automation could make life so much easier and a lot more fun?  #datadriven #automation

Automagic Insight 🪄 Power Automate Tip of the Day! Did you know? With just a few clicks, you can set up a try-catch setup in Power Automate to handle any action that might need an alternative output when it fails! Here’s how: 💡 Select the action you want to run if the first action fails (like the Parse JSON action in the image). Click on the three dots (…) in the upper right corner of the action and choose Configure run after. 💡 From here, choose specific conditions under which the following action should run, such as when the action has failed. 💡 Next, select the action to handle the failure gracefully and set its run after to execute if the previous action is skipped (which it will be if the HTTP action succeeds)—essentially creating a “catch” for the failure scenario. This setup allows your flow to keep running and respond appropriately, even if an action encounters an error. It’s a simple way to build resilience into your workflows—keeping them automagically on track! #PowerAutomate #Automation #MicrosoftPowerAutomate #WorkflowOptimization #BusinessProcess

Automagic Insight 🪄 Power Automate Tip of the Day! Looking to control loops more precisely in Power Automate? Here’s how you can use Do Until with Current iteration index to add more logic to your flows: 💡 Step 1: Use the Do Until action to create a loop that runs until a specific condition is met. In this example, we’re looping until the variable varIndex matches a specified integer. 💡 Step 2: Inside the loop, set varIndex to Current iteration index. This dynamic content tracks each iteration, allowing you to manage and monitor the loop’s progress. 💡 Step 3: Customize the loop’s limits. Set a maximum count (e.g., 1,337) and timeout to prevent the loop from running indefinitely, ensuring it only runs as long as necessary. This approach is perfect for scenarios requiring precise iteration control, especially when processing large datasets. With Do Until and Current iteration index, your automations stay efficient and error-free! FYI, the upper limit for number of loops are 5000. #powerautomate #automagicinsight #dountil #loopcontrol

Automagic Insight 🪄 Power Automate Tip of the Day! Did you know? In the Parse JSON action, you can handle null values in Power Automate without breaking your flow! 💡 Just set up the schema to allow a field to be either a string or null, like this: "tin_number": {        "type": ["string","null"] } This way, your flow stays resilient even when optional fields or missing data return as null. Let Power Automate do the heavy lifting—automagically! #powerautomate #automagicinsight #nullhandling

JSON Expression tip for Power Automate

Automagic Insight 🪄 Power Automate Tip of the Day! Did you know? There’s a quick way to check if a value is an array or an object in Power Automate! 💡 By using a simple conditional expression, you can dynamically identify the data type in your flow. Just use this expression: if(startsWith(string(<value>), '['), 'Array', 'Object') This checks if <value> starts with a [ (indicating an array). Use it as is or in a condition. This small but powerful trick helps your flow handle different data types smoothly, making it adaptable and efficient—keeping things, well, automagically seamless! #powerautomate #automagicinsight #datatypes #smartflows

In Power Automate, efficiently processing data often requires distinguishing between objects and arrays. I just spotted this post, with an interesting approach to the subject. I wonder how it compares to using 'typeOf()' in the expression. #powerautomate #DataProcessing #Automation