LJ Dynamics Writings - D365

In this article, I'm going to show you how to apply different types of ranges to AOT queries. We'll go through simple and complex ranges. Let's first create a simple query that has "CustTable" inner joined with "CustGroup" If we want the query to return values where the enum "Blocked" field value is Never, then it's either we type the value Never directly or type CustVendorBlocked::Never ** It's not recommended to filter on the enum integer value If we want the query to return values where AccountNum value is "US-001",  we can add the string value US-001 directly Now what if you want to filter on AccountNum "US-001"  OR  "US-002", you can do it in two ways: 

In this article, I will be showing you how to use Power Automate in order to do CRUD (Create, Read, Update, Delete) operations inside D365FO. Login to https://make.powerautomate.com Click on "Create", then click on "Instant cloud flow" Name the flow, choose how to trigger the flow, then click Create Click on the "+" sign, then click "Add an action" Look for "fin & ops" connector and click "See more" to see all actions for it Create Record Choose "Create record" Choose "Authentication" method and fill other field values, then click "Create new" Here, I chose Authentication method as "Service principle" Choose your connection name You need to fill the Client Id,  Client Secret and Tenant Id from the app registration If you don't have an azure app registration created, then you will need to create a new one. You can check my detailed article on how to create one  How to create App R...