Power Automate
-
How to use Power Automate and Microsoft Forms to make a solution for anonymous reporting of internal concerns
It is not so easy to use the Power Platform to make a solution for reporting anonymous. If you use a Power App, you will be logged in and just because your name is not registered in the report, people with the right access can still go in and see who made it. But if Continue reading
-
How to handle external variables in managed solutions
The first thing I do, after creating the solution is to add the data source. I create a table with columns for solution, name of variable and value of variable Microsoft wants us to use managed solutions in a production environment. That’s all well and good, but what if you have variables in the solution Continue reading
-
Error handling in flows
When you write a flow or use a template, it is easy to just add one action after another and then save. But what happens if one of the actions fails? Nothing. You might get an email about your flow failing, but maybe you use a service account and don’t check the mail very often. Continue reading
-
When the look up value is in a JSON object inside an url
My task was to automate incoming e-mails that were stored in Dataverse, process them and register purchase orders and requests for quotes based on the information in the e-mail and attachments. At the time this challenge arose, I was well into filling in all the fields in a purchase order with look up values. I Continue reading
-
How to find look-up column values in Dataverse tables
My task was to automate incoming e-mails that were stored in Dataverse, process them and register purchase orders and requests for quotes based on the information in the e-mail and attachments. One of the tasks I had in my first flow connected to Dynamics CE was to create an order. Simple enough, I thought, and Continue reading
-
How to retrieve attachments from emails stored in the “Email Messages” table
My task was to automate incoming e-mails that were stored in Dataverse, process them and register purchase orders and requests for quotes based on the information in the e-mail and attachments. When an email is stored in the “Email Messages” table, the attachments are not stored within the same table. You must perform a lookup Continue reading
Tonje’s Tech Terrain: Navigating Microsoft 365, Power Platform, and Dynamics 