Smart people are very useful. Sometimes just talking to them helps you understand the technology better. Consider, for example, John Liu educating ignorant yours truly about the intricacies of failing Power Automate flows. tl;dr For a flow run to be a success, all execution paths including those containing skipped actions, must complete.
The usual workaround for dealing with business required fields when creating records in automation is to make them non-required, deal with the automation and then switch the required option back on. Now, add an autonumber on top of that. That’s right, you want the mandatory field to be blank so that the generator kicks in. […]
I recently was evaluating using UI Flow RPA to automatically print barcode labels. Using Microsoft Word or Wordpad and a freely available barcode TTF, I passed the barcode value to the document and hit the print button. All worked as expected, except I could not get the flow to properly record selecting the correct font. […]
Today’s tip from Ankita Chavan – a good reminder to get your housekeeping in order while copying the environments. Got a tip of your own? Send it to firstname.lastname@example.org! We were working on the full copy of data from UAT Environment to dev Environment and we were testing existing functionality. We found that flow was […]
Power Automate is very handy to serve as a webhook. Add When a HTTP request is received trigger and you’ll get a URL to call after you save the flow. (Genuinely curious if it should be “an HTTP“ instead.) Any flow triggered by HTTP request executes asynchronously, i.e. it returns to the caller immediately after […]
When using the Parse JSON action in Power Automate, flow will guess what type of data your fields are. Sometimes it guesses incorrectly, such as thinking a number field should be a text string. When this happens, you will only be able to select the field for test fields, not number fields in update record […]
So you want to build a model-driven app or use CDS or some other premium feature. Your boss tells you that you have Power Apps and Flow access. However, you need to know if it is just the version that comes with Office 365 or “full” Power Apps or Power Automate. How can you tell […]
&tl;dr When using Increment variable or Decrement variable actions, use coalesce function in the parameter to avoid unexpected results.
tl;dr If you have email addresses coming from somewhere and you’re using them in Power Automate to filter and find the records, make sure to double the quotes. Full story One of the observations made by our lifetime tipster Jerry Weinstock was that citizens tend to create automations that follow happy path. I have to […]