Introduction : In this blog, we will see how to reset CRM D365 Environment. Requirement of Client is Sales App but while installing Environment what if we installed all Apps ? Solution : We can reset the Environment. In this scenario, Our client requirement is only Sales App and we have installed all Apps. Step 1: Go to portal.office.com -> admin centre -> Dynamic 365 We will see that our environment is installed as Production and we don’t see option to reset the Environment. Step 2 : Now go to -> https://admin.powerplatform.microsoft.com/ -> Environments -> Select Environments -> Edit and make it as Sandbox and Save it. Once we Save, we can see Reset option. Step 3: Then click on RESET Step 4: When we click on the Reset, Form will be opened and we can see options to redeploy the Apps. Select Apps we want to redeploy. In our scenario, our requirement is Sales App only , we have selected only Sales App. Click on Reset and confirm. Result :   Hope this helps to view only those apps which you need !

In this blog we’ll see how to Connect Power BI to the MySQL . Before connecting to MySQL make sure you have MySQL connector install on your machine. Follow following steps to connect to the MySQL Open Power BI Desktop and select Get Data > Database > MySQL Database. For example, if you have a local MySQL server running and can connect to it by entering “localhost” or name of local machine, enter name of database and press OK button. If you are getting error saying “DataSource.Error: Object reference not set to an instance of an object.” To resolve this issue, go to File | Options and Settings | Data source settings and edit your data source and set the credentials to “Database credentials”, not Windows credentials.  You can get data from MySQL views, use the “SQL statement (optional)” and enter a SQL query. In next blog we’ll see how to connect the Power BI to MySQL if MySQL is running on the cloud.

Configuration of Environment through LCS. After we purchase licence, Login the LCS through Admin account. You can see the follow link to complete setup environment. Before configuring the environments there are some pre-requisites need to be performed. Declaration of project milestone. Click on setup milestone, Enter the end date for each milestone and save. 2. VSTS Setup. Before this we need to follow the below steps: Login in Azure DevOps. Create a project. 3. Create personal access token. Save this token. Click on “Setup Visual Studio Team Services” a.  Enter the site Enter the AzureDevOps url, which consists of https://organizationname.visualstudio.com/ and click on continue. Enter Personal access token generated above in Azure DevOps. b. Select the project Select the project from the list and click continue. c. Review and Save 3. Project configuration and project on-boarding. Click on “Complete project configuration”(This is one time setup) And click on “Project onboarding” Check all the 12 points by clicking on next and then finish the complete onboarding review page. And click on configure button of environment Enter the name of environment and select the region. Then you can see the status of environment in queued state. After 7-8 hours you can login to your environment.      

We can Make the SQL Server Accessible over Internet by following steps: 1. System should have static IP where SQL server is installed. 2. Open SSMS, right click on server > properties and check SQL Server and Windows Authentication mode 3. Go to Server > Security > Logins and configure password for users, who will be accessing the SQL server remotely. In this we are setting up password for the use ‘sa’. 4. Go to Server property and check  “allow remote connections to this server” 5. Go to SQL server configuration manager > SQL server network configuration > Protocols for SQL and make sure TCP/IP is enabled 6. Click on TCP/IP and enter port number in IPAll section 7. In firewall setting create Inbound rule for the port through which it will listen, in this case we are selecting port 4729   8. In next steps we will enable port forwarding (i.e. It will redirect request received on public IP and port to another IP and port combination) In mapped IP we can mention static IP of system also (i.e. 192.168.1.30) 9. Now from other system outside of current network, access the SQL server and enter server details and credentials. Enter server name eg 113.143.120.100, 4729\SQL Hope above Helps!    

Hi, in this blog we will see how to create a storage account in azure portal. On the Azure portal menu, select All services. In the list of resources, type Storage Accounts. As you begin typing, the list filters based on your input. Select Storage Accounts. On the Storage Accounts window that appears, choose Add. Select the subscription in which to create the storage account. Under the Resource group field, select Create new. Enter a name for your new resource group, as shown in the following image. Select Review + Create to review your storage account settings and create the account. Hope this helps.

Introduction: This blog will show you how you can color individual rows differently based on different conditions and the row headers in matrix (Not alternating rows). Our Scenario: I want to apply colors to different rows of the following Buckets: Current – No Color 1-30 Days Past Due – Yellow 31-60 Days Past Due – Orange 61-90 Days Past Due – Red 91 or More Days Past Due – Red Step 1: Create a new calculated column in your data source which applies a numeric value to each header type that you would like to have highlighted. We have created a Calculated Column using the following query. Step 2: Select the Matrix to which you want to apply the formatting and go to conditional formatting section in the Format Tab and turn the Background Color Option “On”. Step 3: The Conditional Formatting is applied for different fields in the Values section in the Matrix. So we will apply conditional formatting according to No.  field first. Select Format by “Rules”. In Based on field select “Sum of Color Column” and in Summarization select “Sum”. In the Rules section add the Rule as shown in the Screenshot.  Step 4: Apply the other rules for different colors same as above. Step 5: The Colors have been applied to different buckets according to our rule for “No.” Column. Step 6: Repeat the same steps by selecting different fields from the drop down under Conditional Formatting, one by one. Step 7: Thus we have colored the different rows of the Matrix successfully based on our condition.

Introduction This blog explains how we can trigger Power Automate based on the required condition. Suppose you have a requirement where you want your flow should get trigger based on some condition then you can check condition on “Trigger” itself rather than adding a new action to check condition. Use Case: Trigger flow when Lead is created and Lead Source Type is “Trade Show” Trigger flow when Lead is created and Flag is “Yes”. Trigger Flow when Lead is created, Lead Source Type is “Trade Show” AND Flag is “Yes”. Trigger Flow when Lead is created, Lead Source Type is “Trade Show” OR Flag is “Yes”.   Steps to be followed: Trigger flow when Lead is created and Lead Source Type is “Trade Show” Click on Ellipsis (…) –> Click on Settings Go to Trigger Conditions and Click on “+Add” Add condition. @equals(triggerBody()?[‘leadsourcecode’],7) NOTE: “Lead Source” is an option set field add value of that option to check. After adding condition click on Done. Test your flow.   Trigger flow when Lead is created and Flag is “Yes”. Repeat step number 1 to 3. NOTE: Flag is the “Two Option” field for two option set fields use true or false in condition. @equals(triggerBody()?[‘cf_flag’],true)       Trigger Flow when Lead is created, Lead Source Type is “Trade Show” AND Flag is “Yes”. Repeat step number 1 to 3. AND Condition @and(equals(triggerBody()?[‘cf_flag’],true), equals(triggerBody()?[‘leadsourcecode’],7))   Trigger Flow when Lead is created, Lead Source Type is “Trade Show” OR Flag is “Yes”. Repeat step number 1 to 3. OR Condition @or(equals(triggerBody()?[‘cf_flag’],true), equals(triggerBody()?[‘leadsourcecode’],7))

Introduction: This blog provides steps to follow in order to access the SharePoint Recycle Bin in MS Flows   Steps: 1) In Actions, select “Send an HTTP request to SharePoint” 2) Enter the below details: Site Address: Select your site address from the list. Method: GET Uri:_api/web/recycleBin?$filter=DeletedDate eq datetime’Time Deleted’ and DeletedByName eq ‘Deleted by’ and Title eq ‘Filename with extension’. Headers: Accept application/json Pls. Note: The parameters marked in yellow are taken from the trigger “when a file is deleted in SharePoint” 3) Select Action “Parse JSON” 4) In parse JSON, the content is the body of HTTP Response Enter the below Schema: { “type”: “object”, “properties”: { “odata.metadata”: {“type”: “string”},“value”: {“type”: “array”,“items”: {“type”: “object”, “properties”: {“odata.type”: {“type”: “string”},“odata.id”: {“type”: “string”}, “odata.editLink”: {“type”: “string”},“AuthorEmail”: {“type”: “string”},“AuthorName”: { “type”: “string”},“DeletedByEmail”: {“type”: “string”},“DeletedByName”: {“type”: “string”}, “DeletedDate”: {“type”: “string”},“DeletedDateLocalFormatted”: {“type”: “string”}, “DirName”: {“type”: “string”},“DirNamePath”: {“type”: “object”,“properties”: { “DecodedUrl”: {“type”: “string”}}},“Id”: {“type”: “string”},“ItemState”: {“type”: “integer”}, “ItemType”: {“type”: “integer”},“LeafName”: {“type”: “string”}, “LeafNamePath”: {“type”: “object”,“properties”: {“DecodedUrl”: {“type”: “string”}}}, “Size”: {“type”: “string”},“Title”: {“type”: “string”}},“required”: [ “odata.type”,“odata.id”,“odata.editLink”, “AuthorEmail”,“AuthorName”,“DeletedByEmail”, “DeletedByName”,“DeletedDate”,“DeletedDateLocalFormatted”,“DirName”,“DirNamePath”,“Id”, “ItemState”,“ItemType”,“LeafName”,“LeafNamePath”,“Size”,“Title”] }}}} Sample Output: Conclusion: In cases where we need to get the original location of file after it is been deleted from SharePoint, we can  access Recycle Bin of SharePoint and obtain the original path.

Key Technologies:  SQL Server Reporting Services, CRM Online Create a report in SSRS. Configure data source and credentials. Query the dataset and map the fields on the table. Date format on the report needs to be displayed as it is in CRM (“dd/MM/yyyy“). But the problem is when we use fetchXML to retrieve the data, datetime field returns 2 fields for my dataset (one value is datetime in UTC and one value is string datetime in local user setting). So we need to convert the string value to datetime, but ‘CDate’ gives an error because it is presuming that the date is always in US format(MM/dd/yyyy) like 24/07/2012 is an invalid date  for CDate because 24 is an invalid month. Similarly, we can’t use the Format date function, need to convert it to datetime first. For any reports SSRS interprets all of dates as US format Ex: 06/03/2013. Actual date is 6 March 2013 but in SSRS it is displayed as 3 June 2013 which is incorrect as client uses date format in dd/MM/yyyy The solution is to change the language properties in the report to specific region, which  is set to en-US by default. Go to the Report properties and for Language property try setting the value of Language to “=User!Language”