cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bob_dvb
Advocate I
Advocate I

Why is Power Automate so difficult?

I must be missing something here, because on the face of it Power Automate looks like it should be very powerful. But each time I come to try and use it I fail. Now, I'm not what I would call a good developer, but after 30 years in tech, I hope I'm not an idiot. This afternoon I spent another unproductive two hours failing to compose a simple workflow. Something I could knock up in code but because I want it to be owned by non-developers and behind SSO, Automate makes sense.

 

I try to create a flow, except every time there's something wrong when trying to pass values between blocks or actually do anything useful with them. When I think I have it, I press save and get errors which prevent me from saving, and yet the errors can't be fixed because they make no sense. I ask Copilot what's wrong and it says there's nothing wrong, I give it the error message and it tells me nothing's wrong, then suddenly things that were apparently okay in the flow are now not okay, but unrelated to the things that were erroring before. Now I have new errors. Except these errors are for things that were automatically filled out when I created the flow, so how can they be bad parameters in the block?

 

For example, a Conditional block that errors, saying there's a problem with the input to the block, but Copilot disagrees. All the Conditional is doing is checking message body starts with a word.

 

I'm tired, I hate it when tools want to appear useful but because they can't explain themselves properly you have to know everything before you can know what's wrong.

19 REPLIES 19
ScottShearer
Most Valuable Professional
Most Valuable Professional

@Bob_dvb 

I'm sorry that you have had some bad experiences.  A quick check tells me that over 350,000 organizations and over 93% of all Fortune 500 companies use Power Automate.

That said, while I understand that you have over 30 years in tech (as do I), these forums are here to help.  Next time, just post your issues and there is a global community here to assist.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

To add on to what @ScottShearer said, I would add that I would not rely on Copilot to diagnose your problems. It often seems to make things up, gives you the wrong information, or based on how you phrase your question, just tries to agree with you. It is good at some things but use it with caution.

 

For example, earlier today I asked Copilot: Write a power automate trigger condition to check if the author is the same person who modified an item in SharePoint. It gave me the wrong answer. I just asked again, and it gave me a mostly correct answer. The correct expression is:

@equals(triggerOutputs()?['body/Author/Email'], triggerOutputs()?['body/Editor/Email'])

The mostly correct answer that Copilot just provided did not include @ at the beginning of the expression, which is needed with a trigger condition. It is little things like this that can be so frustrating when you are trying to learn Power Automate.

 

Your best bet is to post a screen shot of your flow with a description of what you want to accomplish. And provide any error information that is returned from the flow.

 

To get your feet wet so you gain more experience with what Power Automate, explore some of the self-paced training options at Browse all courses, learning paths, and modules - Training | Microsoft Learn. This will give you better insights into how Power Automate works with real examples.

 

Good luck and keep at it. With time and practice you'll be a super user, too.

It's not extremely user-friendly.

I guess the beginners need more practice and hands-on. I am facing difficulties in the beginning too, and slowly trying to get the flow out of it.

just hope that there would be more experts answering our questions. I posted a few questions, but still waiting for the answers.

You may want to consider joining the Microsoft Power Up program where Microsoft will provide you with training to learn the Power Platform. They recently started accepting applications again, and in the first week alone had over 80,000 people apply. You can learn more at Microsoft Power Up Program for career switchers

@CD00131 it's  unfortunate you are not getting on with Power Automate but it is definitely worth sticking with, and posting your questions here will get you quick and accurate responses, unlike asking Copilot! I started with Power Automate in the summer of 2018 and "got it" very quickly and it changed the whole course of my career at - as I was then - 58 years of age, from a humble UK-based intranet manager to the global product owner and Principal Power Platform Consultant for a massive Canada-based global company.

 

My advice would be to use the classic designer. I still find it more user-friendly and easier to understand  than the modern designer which still has occasional bugs and I don't find the interface as friendly as the classic.

 

So welcome to the forum and don't hesitate to post here with whatever questions you have.

 

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

Thanks Rob Elliott for your encouraging notes, sure, I will post more questions here, and I am learning every bits of Power Automate here and there. I hope one day I will reach halfway of where you are now.

The practical consequence of using LLMs to generate code is that many developers will find they have unwittingly moved themselves into a role they were probably trying to avoid: they have automated the creation of legacy code and have redefined their job role as debugging and fixing such code.

Kevlin Henney

Hi @Bob_dvb ,

Learning Power Automate (or any new skill) is a journey with ups and downs. It's not a smooth, linear path.

2024-06-03_19-24-05.PNG

You will experience periods of progress followed by plateaus or even temporary setbacks. This can be frustrating, but it's a normal part of learning.

 

A plateau is a period where you don't seem to be making progress, even though you're still putting in effort.

 

But keep going through the challenges and setbacks. Celebrate small wins and recognise your incremental progress to stay motivated. Understand that the learning curve is bumpy, and see obstacles as temporary, not permanent failures. With consistent practice and persistence, Power Automate may well eventually become "second nature".

 

Like others here, I have 30+ years in experience in tech but started my real learning journey with Power Automate only in 2021.

 

The Bumpy Learning Curve | LeanProductivity (sascha-kasper.com)


Ellis
____________________________________
My Blog Site

 

I am having an absolutely terrible time with this too. The error messages are nonsensical and Power Automate does not seem intended to work with CRUD operations of any complexity. A simple delete query based on a trigger in SQL could be written by a beginner with no SQL knowledge than the equivalent in Power Automate. 

 

The error codes/error messages are basically worthless and the uneditable "code view" mocks the user. 

BBean
New Member

I am certainly having lots of issues, but I'm also very new to Power Automate. My issue is, as mentioned in this post, this is supposed to be a no/low code solution to help people who aren't developers automate tasks. However, the finicky nature of creating a tree is so terrible it would frustrate all the users I have, also the debugging is difficult because the error messages make no sense and I can't find any help documentation to decipher what the heck the error messages are trying to state. 

As a side note, I'm very frustrated that when I try to automate creating a Planner task in a Teams channel based off a trigger, I cannot update the Notes section. I THINK it's possible with an update ticket action, but why not on the creation action? That just seems silly. As I was writing this another thing bothered me, the only text input field I could find in the task creator was the Title field, which has a limit of 255 characters. This application knows that, why wouldn't it by default only grab the first 255 characters of whatever you fill into the title field as the input? While trying to fix JUST that piece, my whole flow broke and I couldn't figure out how it happened. An apply to each action showed up out of nowhere and it's so high up in my flow that if I try to delete it the majority of my flow goes with it...awesome

Hi @Bob_dvb ,

 

Adding to the comment here and for support.  As a super user and someone that was self-taught through trial and error, what I can tell you the most comment learning experience I typically see with Power Automate is when users have a specific automation in mind (that may or may not be complex) and that becomes their first automation and project in Power Automate.

 

Goes without saying, many of the "first projects" are advanced-to-extremely advanced experience level.

 

That said, my recommendation to really get into Power Automate is drop the "need" projects and learn the basics with common connections and triggers, such as when an email arrives, do actions with the attachments, subject, body, etc.  Build lots of flows that you don't specifically need in your current demand. Those basic flows are the best way to learn and that foundation will help you solve your current world problems.  There are a lot of common actions that will make you feel very comfortable with Power Automate.  There are lots of videos, templates, books, and more.  Don't give up.  

 

 

If this was helpful: Please mark as a solution Give me a thumbs up Always glad to help, Tom! Connect on LinkedIn
sammary
Resolver I
Resolver I

Wow, I thought I was the only one having issues. This is not my first rodeo, I have done some programming in Basic, C, a little VBA, a little Python and a lot of UNIX Shell. And as far as I'm concerned PA is a major time sync.

 

I finally get a flow to work and then it stops, and I get error messages. Nothing changed so why does it work infrequently.

 

My flow watches an Outlook mailbox and when it sees a new email it is supposed to send it to a SharePoint folder. The flows says it was successful but nothing get delivered????

Midas
Frequent Visitor

I find that it helps to just aiming at collecting success stories. Start creating a flow, and quickly end up in a place where you can run it and it works. I have a friend who just started on the same path - he chose the method of teaching his skills as a booster for his learning path, because he believes he learns faster if he can articulate what it is that is being done, rather than just copying template flows and such. You can check him out on the link below if you are interested, and develop your skills in parallel with him 🙂 

 

https://youtube.com/@matkjeldsen

sammary
Resolver I
Resolver I

If anyone is interested ChatGPT actually provides MUCH better answers that CoPilot. I've noticed this with questions I've asked about VBA scripts, Python and of course Power Automate.

This forum is by far the best place to get accurate answers from people who really know what they're talking about.

I've been able to make some useful automations with it, but it has been a head-bashing effort every step of the way.

I don't have a background in programming but I've build some SharePoint Designer Workflows in the past.

This is both a)much more powerful and b)much less beginner-friendly. We are very lucky that there is so much help out there for working around the challenges and limitations of the system.

In regards to the Power Platform broadly, I think Microsoft basically failed at "no-code." To do anything worth your time, you will have to create an expression, write some code, or perform some power query against data. The current environment leads people to create applications and automations using terrible practices and without the proper considerations in place.

I'd like to see them create some learning path that allows you to select your platforms and brings you through a real world set of examples using all of its platforms (BI, Apps, Automate, etc...).

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (724)