Michael Ghebremedin Dynamics 365 Notes

  Power Automate Flow How to Create Email Message with a Table of list of record.   If you are working on a scenario where you must include a list of records in an email, then I would say keep on reading. Let’s pick a simple scenario, when and account is assigned to a user lets send the list of Contacts associated to the account to the new Owner.   Our next step is going to be , to retrieve all associated Contacts to the account, we are going to use the List records action from the Common Data Service, I prefer to use the Filter Query if you are not comfortable with rest calls just go ahead and use the Fetch Xml Query you can use advance find to build the appropriate Fetch Query   Here there are two options you can take:   Call Create HTML Table and build your table Build a list then pass the list to Create Html Table I personally prefer the second approach, its cleaner, it will give you the ability to select which fields you want to include in your table and

  Create Power Automate Flow that triggers on Demand Let start by finding When a record is Selected     Note :- This component belongs to the old Common Data Service, I have noticed you can use it with the new Common Data Service, which is good in my book.   For our example here we are going to select Accounts as our Entity, you can enter your environment under Environment, it will take the URL of the environment you are targeting. If you have any parameters to pass to the Flow you can select any of the following Inputs         Text         Yes/No         File         Email         Number         Date Text 1.        Add drop-down list options :- will give you the ability to add dropdown values 2.        Add a multi-select list option :- as it name explains it will give you the ability to add multiselect 3.        Mas as Optional :- By default the Text is always required so if you want the Text Imput to be optional you select this one 4.        D

I have seen a lot of complicated Power Automate Flows to handle Empty Lookup Values when trying to Update records. As you know setting a lookup field with empty value is going to cause the Power Automate Flow to error out. Example: Setting Lookup =   accounts() We are going to work with a scenario where we are going to retrieve Parent Account field value and populate it on another Account. To handle this issue, we are going to declare a variable that hold the Lookup Value (String)   Then we are going to analyze if the source record has Parent Account populated or not If the Parent Account has Value then we are going to set the variable with accounts(ParentAccount)   Otherwise we are going to set the value to null   The last thing to do here is to populate the field on your Update  This is going to save us time on our Power Automate Flow development and keep the flow clean and concise at the same time.