How to find duplicate accounts with SQL?
I’m quite often getting a request to check the data quality on CRM environments. You can use SQL Server Management Studio to write select statements to… Read More »How to find duplicate accounts with SQL?
Lasse Teeriaho
How to start and stop Power BI Embedded capacity from Power Automate – and save money
Power BI Embedded service has been something that I’ve avoided using because of its costs. Leaving it running for a month cost hundreds of euros.… Read More »How to start and stop Power BI Embedded capacity from Power Automate – and save money
LEFT & RIGHT functions with Power Automate
Power Automate does not have left and right functions available as expressions. Here’s a workaround that I used to check if an email’s attachment file… Read More »LEFT & RIGHT functions with Power Automate
How to create XML from SQL select query?
I was building integration and was required to create an XML file as end result. I found out that you are able to generate XML… Read More »How to create XML from SQL select query?
How to hide Teams groups visibility from Outlook lists?
Whenever you create a team in Microsoft Teams, it’ll also automatically create a group that also contains an email distribution list. This can lead to… Read More »How to hide Teams groups visibility from Outlook lists?
How to split a string into an array by line breaks in Power Automate?
Create a new variable that contains just a linebreak (it’s invisible in the pic): Use Compose to split the array by the linebreak variable. Expression: … Read More »How to split a string into an array by line breaks in Power Automate?
Power Automate Desktop cheat sheet
Here’s a great cheat sheet for the Power Automate Desktop actions. I keep it close when building stuff with PAD. Available here: https://cheatography.com/vjr/cheat-sheets/power-automate-desktop-actions/ Great stuff!
How to filter empty rows out of an array in Power Automate?
It is quite simple, just use the Filter Array -action and leave the condition empty:
How to send scheduled emails from a model-driven app?
After a lot of trial and error, I finally found a solution to how to send emails automatically on a defined schedule from a model-driven… Read More »How to send scheduled emails from a model-driven app?
What’s the difference between basic and advanced image matching algorithm in Power Automate Desktop?
For some reason, one of my client’s desktop automation’s suddenly broke down as the robot could not find a specific image on the screen anymore.… Read More »What’s the difference between basic and advanced image matching algorithm in Power Automate Desktop?
- « Previous
- 1
- 2
- 3
- 4