In D365 Finance and Operations when you need to provide and restrict users from a certain operation you can make use of security roles. You can create security roles from Finance and operations environment itself or from its development tool i.e Visual Studio. In this blog, we are going to create a security role in Visual Studio as follows.   Create privilege    First of all we need to create privilege as follows now we need to add new entry point and set  object type in our case display menu item from properties Now add object name(display menu item  name) as follows   create role   Now we need to create role where above created privilege will be needed create new security role  as follows now we need to add new privilege in role as shown And from properties select privilege which we have created in previous step Create Duty   Now we have to create new duty and assign previously created privilege in its properties as shown Now we can see security role in FnO environment select any user from system administration>>users and click on assign role as follows and now search for priviously created role and click on Ok button now your security role is assigned to user with our role will be able to see the object like form, report etc except user with system administrator.  

Introduction: In this blog, we will learn how to Update multiple records of CDS from the Grid.   Use Case: We have a requirement where there is a Grid of CDS Data Source, on clicking the Save Icon on top of the Grid, it should Save every record which is selected through the checkbox which is there on every record of the Grid.   Steps: 1. There is a Screen on which there is an Editable grid of Quote Product Entity. To Create an Editable Grid refer to the following link. https://www.cloudfronts.com/create-an-editable-grid-view-in-powerapps/ To add Lookup Fields in the Grid refer to the following link. https://www.cloudfronts.com/add-lookup-fields-in-an-editable-grid-using-powerapps/ 2. This is the grid with a checkbox. 3. To Save selected records, first create a Collection:           OnSelect property of the Delete icon:           Set SaveIcon.OnSelect =  ClearCollect( <VariableName>, Filter( <GalleryName>.AllItems, <CheckBoxName>.Value = true ) ) For eg: SaveSelectedRecord.OnSelect= ClearCollect( SelectedQuoteProduct, Filter( GalleryQuoteProduct.AllItems, CheckboxQuoteProductGallery.Value = true ) )   4. When we select the Save Icon, it will collect all the records where the Checkbox is selected. 5. To Save the records from the CDS, set the OnSelect property of the Save Icon to the following formula:           OnSelect property of the Delete icon:           Set SaveIcon.OnSelect =  ForAll( <CollectionVariable>, Patch( ‘Gallery Data Source’, <GUID you want to delete> { <fieldName>: TextInput.Text, <fieldName>:ComboBoxName.Selected, <fieldName>:Value(CurrencyTextInput.Text) } ) ) For eg: SaveSelectedRecord.OnSelect=ForAll( SelectedQuoteProduct, Patch( [@’Quote Products’], LookUp( [@’Quote Products’], ‘Quote Product’ in SelectedQuoteProduct[@’Quote Product’] ), { ‘Product Code’: ProductCodeQPGallery.Text, ‘Product Name’: ProductNameQPGallery.Text, Quantity: Value(QuantityQPGallery.Text), ‘Sales Price’: Value(SoldPriceQPEditform.Text), ‘Discount Amount’: Value(DiscountAmountQPGallery.Text), Tax:Value(TaxQPEditForm.Text), ‘Extended Amount’: Value(ExtendedAmountQPGallery.Text) } ) )   6. Combine the Whole formula in the OnSelect property of Save Icon :           For eg: SaveSelectedRecord.OnSelect= ClearCollect( SelectedQuoteProduct, Filter( GalleryQuoteProduct.AllItems, CheckboxQuoteProductGallery.Value = true ) )  ForAll( SelectedQuoteProduct, Patch( [@’Quote Products’], LookUp( [@’Quote Products’], ‘Quote Product’ in SelectedQuoteProduct[@’Quote Product’] ), { ‘Product Code’: ProductCodeQPGallery.Text, ‘Product Name’: ProductNameQPGallery.Text, Quantity: Value(QuantityQPGallery.Text), ‘Sales Price’: Value(SoldPriceQPEditform.Text), ‘Discount Amount’: Value(DiscountAmountQPGallery.Text), Tax:Value(TaxQPEditForm.Text), ‘Extended Amount’: Value(ExtendedAmountQPGallery.Text) } ) )   Conclusion: Hope the above Blog helps you Save multiple records of CDS from the Grid.

Introduction: In this blog, we will learn how to set Default Value of Two Options on New Form.   Use Case: We have a requirement where there is a Field(Data Field: Two Options) on the form, which should show “NO” as Default value. The Field on the Form is a Combo Box.   Steps: 1. This is the form of Quote Product. We want to set Override Price as NO.   2. To set Default value of the field, click on the Combo Box.           DefaultSelectedItems property:           Set OverridePrices.DefaultSelectedItems =  { Value: <Field Name>.No} For eg: OverridePricesComboBoxQPForm.DefaultSelectedItems = {Value: ‘Override Prices (Quote Products)’.No}   Conclusion: Hope the above Blog helps you to set Default Value of Two Options on New Form.

User property disableMru = true; You can refer below code       selectProjectLayout: () => {         var lookupOptions = {}; var _projectLayoutName = null; var customFilter = ‘<filter type=”and”>’ + ‘<condition attribute=”cf_project” operator=”eq” value=”‘ + Operations.selectedProjectId + ‘”/>’ + ‘</filter>’; lookupOptions.allowMultiSelect = false; lookupOptions.defaultEntityType = “cf_tcmaplayout”; lookupOptions.entityTypes = [“cf_tcmaplayout”];         lookupOptions.disableMru = true;// used to hide recent items try { if (Operations.selectedProjectId !== null) { lookupOptions.filters = [{ filterXml: customFilter }]; Xrm.Utility.lookupObjects(lookupOptions).then( function (result) { if (result !== undefined && result.length > 0) { // your code } } }, function (error) { if (error != null) { Xrm.Utility.alertDialog(error.message); } } ); } } catch (e) { Xrm.Utility.alertDialog(e.message); } }

  Introduction : In this blog, we will see, why the Ms Flows are not getting triggered after Completion full copy of the environment. Use Case : It was requirement of our Project to Copy UAT environment To Dev but after Completion of full copy, None of the Flows in Power Automate were getting triggered. We tried the below solutions : Import and Export the flows and Change the Environment  of the flows but this also failed. Created a new Flow, but this also failed. Solution : Go to the https://admin.powerplatform.microsoft.com/ -> Select Environment -> Edit and Check the Administration Mode of the Environment. Note : The Administration mode of the Environment should be disabled. If the administration mode is enabled, all the Asynchronous Processes will not get triggered.   Conclusion: By doing this we were able to trigger the flows. Hope this will help you while Copying one Environment to the Other.

Introduction : Power Virtual Agents help us build simple and easy bots which can be integrated with websites, Microsoft teams, etc. Here are the steps to create a bot using PVA. Login to your environment in https://powervirtualagents.microsoft.com/en-us/ The pop up for create new bot will be visible, name the bot and create. Go to Topics Follow the numbers sequence in the below screenshot for the steps. After you click go to Authoring canvas, you can add messages, actions or call flows. This is where you write the responses and actions of your BOT, Topic Checker displays errors if any. You can test the Bot by clicking on “Test Your bot”, left bottom of the browser.You can check the working and update the bot topic  while testing by enabling the “Track between topics”. Conclusion: Publish the bot and click on demo website to the actual working of your Bot

RSS is powerful and taming it wisely really helps! 🙂 Here’s an example where I used it to get a notification whenever a new blog was posted by Microsoft in their Dynamics 365 Blog page. It is my attempt to stay updated on the latest posts so that I don’t miss anything. Scenario Let’s say, for example, this is the website I want to read RSS feeds from. So click on the RSS icon – https://cloudblogs.microsoft.com/dynamics365/ Copy the URL from the Feed page Build your Power Automate Start by building your Power Automate, you can select the Trigger as RSS. Paste the URL copied from your RSS source above, and then add a step to send a Notification. You can have anything here, it’s up to your use case of what you want to do with the Power Automate further on. Getting RSS Feeds on Phone using Power Automate Now, once all this is set, here’s how I’ll get notifications on the phone once I have Power Automate setup and authenticated to the correct environment of Power Automate. Whenever there’s a new blog posted on https://cloudblogs.microsoft.com/dynamics365/, I get a Power Automate notification on the phone like this And when you click on it, you’ll see what has been posted, it will open up in the Power Automate app And when you click on the link, it will take you to the actual blog Post   Hope this helps you in your application or use case! Cheers!!  

Since Power Automate is so powerful that you can creatively use it to improve your productivity at work. Here’s an example of how you can utilize a scenario where you need a quick checklist to make sure you respond all important emails for the day. Power Automate You’ll need to create an Automated Power Automate and select the trigger as Office 365 Outlook. Select ‘When a new email arrived (V3)’ from the same and make sure you only select the High Importance marked emails Next step, create a To-Do Item. Select the List you have created. In my case, I created a separate list called ‘Respond Important Emails’ And the step to configure the To-Do List item should be like this – In the above picture, I’ve made sure I select the correct List I want to create a To-Do in.And to give myself some time, I’ve added a reminder time of 2 hours from the time this Flow/Power Automate will run i.e. when the email will come in – How it works Now, when an Important email will arrive in my Inbox as below – Power Automate will create a To-Do in my created List And it will look like this – Also, the reminder is set to remind me 2 hours post the time the To-Do item was created. Just in case I’m into something else, I’d set myself a reminder. Hope this helps! And you can use your creativity to improve your productivity!

Sometimes we may get scenario wherein we have to make API calls to an entity from dynamics 365 Portals, so here is my blog that will guide you step by step to how to achieve the same. In CRM navigate to dynamics 365 Portals as shown below. Click on entity list as shown below Click on new as shown below. Enter name in the name field. Select the entity to which you have to make API request. Select website. Click on add view and select view. Click on save and save the record. Now click on OData Tab Select Enabled. Select Enabled. Now Select view (Note: Only the fields in the view will be exposed to the API). To access API use https://domain/_odata/GetAccountsData By accession above URL in browser you will be able to reterive data from Account entity.

When a product can be sold, purchased or stored in more than one unit of measure, it’s important that you set up the correct unit of measure conversions. I recently came across an issue where the unit of measure conversions I created in HQ was not showing up on POS. As you can see in the above image I kept receiving this error. Finally I fixed it after a lot of research and trials. The issue was very minor but it took a lot of time to detect it. Go to units and make sure the language selected in Translated unit descriptions is similar at store level and in workers form as well and then you should not face this issue Hope this helps!