-
Extracting days and time from timespans in Power Automate
One of the most used date/time expressions in Power Automate is the dateDifference(), which is used to calculate the duration between two timestamps. This expression returns a timespan, reflecting the quantity of days and time that separate the two timestamps. However, users generally find challenges to manipulate the information contained within a timespan in future…
-
Handling date and time in Power Automate
Manipulating date and time is one of the most confusing topics when you start to work with Power Automate. There are numerous expressions to handle date and time, and understanding them may be essential for some use cases. For instance, the date and time expressions can be very useful in monitoring tasks progress, notifying users…
-
Utilizando variáveis em Power Automate
Na tecnologia, variáveis são um conceito bem conhecido que está presente basicamente em toda linguagem de programação. É uma ferramenta versátil que permite armazenar e manipular dados dinamicamente, de modo que a mesma variável pode ter valores diferentes atribuídos a ela de acordo com o contexto. No Power Automate, você também pode usar variáveis, e…
-
Como acessar as saídas brutas (raw outputs) no Power Automate
Como uma solução low-code, Power Automate é excelente para a automação de processos empresariais, capacitando organizações a otimizar seus fluxos de trabalho e automatizar tarefas de forma eficiente. Ao utilizar a ferramenta, às vezes nos deparamos com mensagens de erro que não são claras e ficamos inseguros sobre como resolver alguns problemas. No entanto, existe…
-
Writing expressions in Power Automate
Power Automate is a low-code solution to democratize automation and address its challenges, contributing significantly to save time in daily repetitive tasks. The expressions in Power Automate resemble Excel formulas or Power BI DAX queries, making the learning curve for Office 365 users much smoother. Understanding expressions empowers users to build highly effective and complex…
-
Accessing Dataverse records by ID in Power Automate
Have you ever got confused when using the Dataverse “Get row by ID”, “Update a row” or “Delete a row” actions in Power Automate? When integrating Power Automate with Dataverse, a common challenge is the correct reference to the record ID for reading or updating data. Many users get confused due to naming conventions adopted…
-
Object data type in Power Automate
Power Automate, as a low-code tool, provides a platform for users without a software development background to effectively create automation solutions. Some of the Power Automate features, however, incorporate programming concepts such as variables, loops, and conditions. One of the most significant features in Power Automate is the Object data type, a data structure commonly…
-
Cancelling Approvals with Power Automate
Every organization follows internal approval procedures for various purposes, such as reimbursing expenses, reviewing documents, confirming orders, and addressing various scenarios. Microsoft 365 and Power Platform provide the users with an Approvals management feature, allowing them to analyze and respond to approval requests from Power Automate or Microsoft Teams. The “Approvals” connector in Power Automate…
-
Sending values from Power Automate to Excel with Office Scripts
Excel is one of the most popular Power Automate connectors, enabling users to integrate thousands of different services with their spreadsheets. However, most part of the Excel actions available in Power Automate are related to table capabilities, while many users and organizations structure their spreadsheets without a table formatting. Fortunately, several non-table related tasks can…
-
Starting Power Automate Flows from Excel Button
Calling Power Automate flows from Excel or other sources is a powerful integration that allows users to automate and streamline various tasks, enhancing productivity and efficiency by triggering Power Automate flows directly from their spreadsheets. This approach brings the Power Platform capabilities to any Excel entry-level user, allowing them to trigger flows that generate reports,…
Digital Mill
#GoDigital
Digital Mill 