Daniel Amundsen’s Post

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

And if you encounter cases where you may get an object of 1 item or an array with multiple items (like when converting some xml to json) & you want to ensure a reference for that item is always an array then you can do… json( replace( replace( concat(‘[‘, string(<value>), ‘]’), ‘[[{‘, ‘[{‘), ‘}]]’, ‘}]’) )

Check If Array or Object

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

To all my Power Automate fellows The Parse JSON action might seem daunting, but once you get the hang of it, it’s incredibly powerful. It brings clarity to your data handling, making your flows much cleaner and easier to manage. 🌪️

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

#PowerAutomate Expressions A-Z Part 1 Yes, I have just discovered how to create carousel posts. Sorry. Thought this series might be useful for those of you just coming to Power Automate. #PowerPlatform #FlamingoHawaiianShirt

Automagic Insight 🪄 Power Automate Tip of the Day! Stop the Nesting Madness! Structure Your Flows Like a Pro Did you know you can stop a flow before all the logic has run? 💡 If you're guilty of endlessly nesting Conditions in Power Automate (🙋♂️ same here), let me introduce you to a game-changer: the Terminate action. This underrated gem can help you write cleaner, more efficient flows by using Direct If statements or Guard clauses instead of drowning in nested logic. Here's How It Works: 1️⃣ Rethink Your Conditions Instead of adding multiple layers of nested "If this, then that," keep it flat. Focus on the core logic and structure your flow so each condition handles one responsibility at a time. 2️⃣ Use Terminate Wisely The Terminate action isn’t just for when something goes wrong (like errors or failures). Use it when things go right too! Once your logic has succeeded and no further steps are needed, finish with a Terminate (Succeeded) action. 3️⃣Avoid the Depth Trap By not nesting conditions endlessly, you avoid the "4 or 5 levels deep" headache. Flat, clean flows are easier to read, debug, and maintain. Why Should You Do This? 🔥 Readability: Flows are easier to follow when you don't need to mentally untangle a web of nested conditions. 🔥 Maintainability: Simple, flat flows reduce errors and make it faster to spot issues. 🔥 Automagic Results: Structured flows keep your logic clean, efficient, and professional. Pro Tip: For every condition that finishes the logic, terminate it early when possible. This is especially useful in approval processes, data validation, or when your flow handles multiple independent paths. 💡 Let’s keep our flows clean and automagical! What are your favorite tricks for avoiding nested chaos in Power Automate? Share them below! ⬇️ #PowerAutomate #WorkflowAutomation #Productivity #AutomagicInsight

🚀 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