Power Automate
Use Case The Power Automate Desktop (v2.50) allows updating value of work queue items without changing the status of an item. However, it failed to update the input value while processing the work queue items (Processing Status). Through this tutorial I have explained the process to solve this problem by updating the value of ‘Queued‘ […]
Creating word documents from a template is a common action in Automation project. In this video, I demonstrated the detailed steps to create a Microsoft Word document from a template with a repeating section directly in Power Automate Desktop. I used power fx function as a substitute for “𝗦𝗲𝗹𝗲𝗰𝘁” action to avoid adding loop and […]
The introduction of adding images or documents (in preview) as input parameter in custom GPT prompt makes it easier for non technical users to extract specific fields without the need for pre-training models with sample data. This reduces the time and effort spent on preparing and fine-tuning custom models for document processing. Features & Benefits: […]
Use Case String parsing is a common scenario when building workflows to solve business problems. In this article, I have taken a complex problem of extracting number from a given string. I will demonstrate how we can create a utility flow by using expressions, select & filter actions to perform the extraction operation. Scenario An […]
Introduction The recent release of Power Automate Desktop (v2.50) allows updating value of work queue items without changing the status of an item. Through this tutorial I have explained the process to update the value of ‘Queued’ invoice items with the latest values stored in an input csv file. The value of work queue items […]
Use Case In Power Automate Desktop version ‘2.49.176’, two new actions for work queue have been introduced: In this article, I will demonstrate how we can use those actions to add work queue items directly in Power Automate Desktop without using loops and improve efficiency in automation. We can also fetch the items from work […]
Use Case The “Requeue item with delay” pattern delays the execution of work queue item but does not define the max attempts for its processing. In the below example, I have demonstrated the technique to stop reprocess work items after certain attempts. To achieve that, we can use ‘requeuecount‘ property as max retry count and […]
Use Case It is a very common scenario for automation workflow to maintain configuration data in SharePoint or Excel or Dataverse or any other data source. We repeated the logic for reading & accessing configuration object for all workflows. By leveraging reusability, I have designed a child flow in cloud that reads configuration data & […]
Full video tutorial is available on my YouTube channel: Use Case In UI automation, it is a standard process to sign in to an application (desktop or web) to process data in power automate desktop flow. Azure Key Vault is the safest place to securely store the application password. Storing password in Vault also allows […]
Use Case In many organizations, business users are not granted owner/co-owner access but are allowed to run or trigger flows by granting ‘Run Only User‘ access permission. Business users can’t cancel the flow due to this restriction. To address this limitation, we can leverage SharePoint list & power automate cloud flows to allow them to […]
