The ask, create a Power Automate cloud flow to calculate exponentiation, a base value taken to the power of an exponent value. Ultimately, this flow will be one of many flows filling in where Microsoft hasn't yet provided an expression. For this ask, create a new cloud flow and choose "When Power Apps calls a … Continue reading Power Automate: Do While Loop | Calculate Power Of
Power Automate Variables
Power Automate: SharePoint Online | Update Document Set Metadata
The ask, update the metadata of a document set using a Power Automate cloud flow. In this ask, the document sets are created when certain conditions are met in an external source system. Post-creation, that metadata is kept in sync, receiving updates as changes are made in the source system. So, creating the document set … Continue reading Power Automate: SharePoint Online | Update Document Set Metadata
Power Automate: Lookup Table Arrays
As Power Automate cloud flows grow in complexity, makers often need to nest loops within loops. Nesting loops isn't bad, but nesting the same loop more than once is inefficient. An alternative approach, loop the content once without nesting it and build an array of objects, which creates a lookup table that can be referenced … Continue reading Power Automate: Lookup Table Arrays
Power Automate: Understanding | ticks()
For those new to working with Date and time values in computing, just note that they are measured and calculated using "the number of ticks that have elapsed since the beginning of the twenty-first century." Essentially dates and times are just large, whole numbers. And Power Automate has several available expressions to work with these … Continue reading Power Automate: Understanding | ticks()
Power Automate: Outlook Emails w/ Item Lists
There are hundreds of connectors available in Power Automate. Each connector represents a different service, and services can be daisy-chained together to create automations called "flows". Often though, flows need to send emails with listed items, reporting on the executed actions. The easiest way to accomplish this, store the items in an array variable, then … Continue reading Power Automate: Outlook Emails w/ Item Lists
Power Automate: Working w/ Arrays
The Power Platform prides itself on being low-code. While accurate, each solution requires different levels of coding. Power Automate, the low-code workflow creator, empowers developers to use variables when coding their business automations... Among the available variable types, array is a common data structure in many programming languages. For the uninitiated, arrays are essentially collections … Continue reading Power Automate: Working w/ Arrays