• How to mention tags, users, channels and teams using Power Automate
    Table of contents: Built-in mentioningMentioning using msteams property in Adaptive Card JSONMentioning using channel’s webhookMentioning using GraphAPIFurther reading In this post I would like to share with you my latest findings about the ways you can mention actually anything in Microsoft Teams in messages sent from Power Automate, whether it is a user, a tag, a channel or a team.
  • Embed images in emails from Power Automate Desktop
    I had a case recently, that the mail sent from Power Automate Desktop must’ve had images displayed within the body. However, no such option is available from user interface. Still, it is possible!
  • Timeouts in Actionable Messages
    Table of contents: Http ActionAuto-invoke Http ActionTimeouts in Actionable MessagesSummary This post was inspired by a message that Sergi Dominquez sent me on Twitter. It turns out, that when a request from Actionable Message in Outlook is sent to a server, Outlook waits only a specific amount of time for the response.
  • Showing and hiding content in Adaptive Cards
    Table of contents: Action.ShowCardAction.ToggleVisibilityOnly show when In Adaptive Cards there are multiple ways to show and hide content depending on other content or conditions, or even user interaction. But despite that most of them is available since the version 1.2 (so quite early) it requires a bit of knowledge how to actually implement them.
  • Troubleshooting Power Automate Desktop error codes
    Table of contents: Errors in Power Automate DesktopTroubleshooting errors in Power Automate DesktopError code: NoCandidateMachineError code: NoListenerConnectedError code: ConnectionNotEstablishedError message: Desktop flow execution failed. CorrelationId: ‘00000000-0000-0000-0000-000000000000’Error code: ActionRuntimeErrorError code: SessionNotFoundError code: RunFlowFailedError – Timeout has expiredError code: RunFlowFailedError – An error occurred while executing flow Stack empty.Other errors I am working with Power Automate Desktop for more than a year now. Over that time I faced a lot of weird errors that were occurring somewhere between cloud flows I used to trigger RPA and the bots themselves. Let me help you understand where are they coming from and how to resolve them (or create workaround).
  • Filter Excel table using Power Automate Desktop
    In this post I will show you how you can filter data inside a table in Microsoft Excel.
  • Display images in Adaptive Cards
    Table of contents: Images in Adaptive CardsWhere to store images?How to store images securely, but still display them in Adaptive Cards? Images always enricher Adaptive Cards designs. However in Microsoft Teams max. message payload is just 25KB and that includes also the size of card’s JSON. Therefore it is very often not possible to display even the smallest image inline. What other options we have?
  • How to automatically complete approval tasks in Power Automate and Microsoft Teams
    Table of contents: Some basicisWhat’s next? When writing my previous post on working with Tasks in Power Automate I realized existence of a column name Flow Notification URI inside of Flow Approval table, which I so far really underestimated. Let me show you how powerful it is!
  • Working with approval tasks in Dataverse
    Table of contents: The basicsTask createdTask completedTask reassignedTask canceled This post is inspired by some recent talks I have delivered. I will describe you deeply how approval tasks are organized in Microsoft Dataverse and what can we do with them.
  • Independent Publisher connector step by step
    Table of contents: 1. Create custom connectorGeneral informationSecurityDefinitionCodeTest 2. Test custom connector3. Install Microsoft Power Platform Connectors CLI4. Download your custom connector5. Tweak your connector6. Validate your connector7. Add file8. Make a fork on Microsoft’s github9. Open Visual Studio Code and prepare local repository10. Create Pull Request After I have successfully published and got certified with my first connector in the Independent Publisher connectors program (myStrom connector), I decided to share my journey and experiences with you, so that you can as well share your work with the whole world!
  • How 3 makers, 2 devs and a princess came together to save kittens for a hackathon
    Table of contents: The Story (Michael)The Flic and the flow (Tomasz)Show me something beautiful – The canvas app (Carmen)We need a real map – The custom connector to Azure Maps (Lee)Bring me the vibes – The Spotify connector(Yannick)The princess and the push (Luise)What can we learn from this epic quest? (everybody)1. Do one thing the right way, instead of a million things in a messy way2. Take care of documentation3. 1 + 1 = 34. We are all developers This is a re-post of the summary we wrote as a team after participating in hackathon during the South Coast Summit this year. The event was epic. The hackathon even more. Enjoy! The app and more details about our solution can…
  • The query string \”comment\” is missing or invalid.
    Table of contents: SymptomsReasonSolution I was seeing this kind of error in Nintex for Office 365 workflows for some time, but actually never had enough determination to check what is the root cause. However when customer started asking, I started digging.
  • Access denied to a site despite permissions are granted
    Table of contents: User information listHow to resolve it? Recently I faced an odd situation, that user was complaining that they have access denied to the site, even though when I was checking their permissions, SharePoint was displaying, that they do have “Contribute” access level granted.
  • Close frozen preview dialog in Nintex Forms
    Table of contents: How to solve it?What’s next? This is a quick tip post. I am facing this problem myself quite often when working with Nintex for Office 365, especially in “Classic forms”. Sometimes, when you click the “preview” icon, the dialog window pops up, covers the designer with an overlay and… freezes. How to solve it?
  • Adding utterances in LUIS via REST API
    Table of contents: Rest API endpointsObtain {endpoint} value and other parametersImplementation in Power AutomateWrap up When working with LUIS (Language Understanding Intelligent Service) from Microsoft, the most common scenario is that this is used in business processes. The very important feature of the service is that it can be trained with new utterances. This can be done either manually, via user interface or… using service’s REST API. Let me show you how to do it using Power Automate.
  • Read SAP status bar MessageType from Power Automate Desktop
    When you build RPA to handle processes in SAP, it is a good practice to check what status bar displays every time bot confirms data inserted on a screen or tries to navigate away from it. Just to be sure, there is no warning or error message, that should be handled by a bot.
  • Trigger one flow from multiple SharePoint lists
    Table of contents: How it worksHow I did it?Subscriber flowHandler flow This post was inspired by a situation I faced at one of my customers. I was migrating SharePoint 2010 to SharePoint Online and in one site customer had many lists, where users were able to create items. Every time someone created or updated an item, SharePoint Designer workflow was sending them confirmation e-mail. Case was, that the lists were using the same workflow simply replicated per list.
  • Locked file checking pattern in Power Automate
    Table of contents: The reason?Locked file checking pattern in Power Automate Extras In SharePoint Online, whenever you create a library and turn on “Require check-out” before editing documents option or not, users are able to open files for collaboration in browsers or in their local Office clients. When they do that, the file is getting locked from access that could lead to its metadata changes. If you create Power Automate flow which purpose is to update file’s metadata or approval status it will end up with failure when trying to do so.
  • Get Power Automate Desktop runs details
    Table of contents: Dataverse structureHow to access the data?Access the data in Power AutomateNext steps This post is totally focused on description of the Dataverse structure that is used to store details about runs of all Power Automate Desktop ui flows. Or as called today: desktop flows and cloud flows built using Power Automate platform.
  • Overcome 2000 items limit using Power Apps Collect function
    Table of contents: BasicsPrerequisitesSo how to do it? This is going to be a short post. I want to share with you my approach for overcoming the threshold called data row limit, that prevents function “Collect” to get more than the set number of items. The data source in my case is SharePoint.
  • Securing responses from Actionable Messages
    Table of contents: See it in action!Action-Authorization header to the rescueJWS headerJWS payloadCorrelationId and originator in Adaptive CardService-specific tokens In my previous post I guided you through a list of steps required to build, send and handle response from Adaptive Cards as Actionable Messages in Outlook. Let me now tell you, how to secure the response.
  • Adaptive Cards in Outlook – ultimate guide
    Table of contents: See it in action!Actionable Messages using Adaptive CardsRequirementsSend Actionable MessageStep 1, create Adaptive CardStep 2, define actionsStep 3, build flow to handle responseReplace existing Adaptive Card with confirmation Adaptive CardSend notification back to userStep 4, publish flow handling response Step 5, compose and send Actionable MessageActionable Messages DebuggerSend Actionable Message to othersMessage response verification It has been a while since I first thought about writing this post. Recently I had more questions around this topic and somehow realized, that indeed this is something about Adaptive Cards that I haven’t yet written about. So let me fix it with this ultimate guide.
  • Assign Adaptive Card to multiple Teams users
    Table of contents: Sequential scenarioParallel scenario I’ve been asked that question multiple times – how to assign a single Adaptive Card to multiple Microsoft Teams users and then collect responses. The point is, that action “Post an Adaptive Card to Teams user and wait for response” lets us to collect just a single response at a time. So how can we do it?
  • Mentioning in Microsoft Teams via Power Automate
    Table of contents: See it in action!How to mention in Teams via Power AutomateHow can we use it?Alternatives – aka what I tried so far<at>user mail</at> tagsAt-mention for Adaptive CardsAt-mention using GraphAPIAt-mention using Invoke an HTTP request with Azure AD This topic has been continuously raised by multiple people I’ve been talking to. How can a user be mentioned in Microsoft Teams when a message is sent from Power Automate? This issue seemed to never been really possible for us, Power Users, until couple days ago Microsoft released new action in Microsoft Teams set in Power Automate called: “Get @mention token for a user”. It’s even cooler, because it works with Adaptive Cards too!
  • For a selected message – new trigger in Power Automate
    Table of contents: The triggersFor a selected messageHow does this trigger work?What next? In the beginning of July Microsoft has added two new triggers for Power Automate to integrate better with Microsoft Teams: For a selected message and When a new team member is added. In this post I will go you in details through the first one from them.
  • RPA in a day labs are live!
    Table of contents: Student’s packageTrainer’s package How to use RPA in a day labs?PreparationsDuring the labsFinal thoughts With a huge pleasure I would like to announce that we (as I had some role to play in this as well!) have completed work over preparation and testing of the Microsoft RPA labs!
  • Trigger WinAutomation from UI flows
    Not so long ago I wrote a post where I was describing how to integrate WinAutomation with UI flows (here). It didn’t take much time for Microsoft to release a dedicated connector, that does the same thing, but well… Is much easier to use!
  • When a new team member is added
    Table of contents: Step by stepCalling Graph APIAdaptive Cards… With this new trigger you can add create a new level of governance for your Microsoft Teams. Especially when speaking about the on-boarding users or other automated processes for newly added Teams members.
  • PVA Series – Global variables
    Table of contents: First – documentationScreencastCreating global variableSetting global value via URL parameters in iframe modeSetting global value via URL parameters in embed mode Power Virtual Agents has just been equipped with the new functionality called “global variables”. With it we are now able to chain topics’ conversation and still be able to know the context from previous topics. Also – bots can be given the context from external applications using those variables. How to do it? Let me show you.
  • Restore removed files in SharePoint with Power Automate
    Table of contents: RecycleBin objectWhen a file is deletedRecycle Bin Item IDWhy is it useful? Having the trigger in Power Automate called “When a file is deleted” many asks if there is a possibility to restore that removed file or delete it permanently? Yes it is. Let me show you how.