Posts

Using expand query in Power Automate Flow.

Image
Hello Guys, In our previous  blog   we have seen how to update lookup field for entity using MS Flow. Today we will see how to use expand query in MS Flow. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Consider a scenario where we have contact, account, country and region table. Contact entity is having lookup of account and country. Also country entity is having lookup of region. Now we want to retrieve contact record along with account, country and region. So we want while retrieving contact it should also retrieve fields of account, country and region. let's check how it works! We have created one manual flow which will retrieve contact based on GUID as shown below: Now when we run this flow, it will retrieve all fields of contact as shown below: As you can see our lookup fields are also there. Now if you notice it has not retrieved region as region field is not available on conta

How to update Lookup field for entity using Microsoft Power Automate Flow.

Image
Hello Guys, In our previous  blog   we have seen Bing Maps and Power Automate Flow. Today we are going to see how to update lookup field for entity using MS Flow. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Consider a scenario where we have two entity named Account and Contact. Both these entity is having one common lookup field named country which you can see in below image: Now as we know this both entity are related as parent-child, whenever we are creating a new record for contact the country of account(Company on contact) should be copied or updated on contact entity. We can achieve this using power automate flow. We will be creating a flow which will run on create and will update country in contact. As you can see in above image, we have already created the flow and updating the country field with account's country value. This flow will run and update contact as you can see i

Getting address based on latitude and longitude from Bing maps using Power Automate Flow.

Image
Hello Guys, In our previous  blog   we have seen how to display maps in canvas application. Today we are going to explore more about Bing Maps and Power Automate Flow. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Today we are going to see how we can retrieve address based on latitude and longitude using Bing maps and Microsoft Power Automate Flow. We will be creating a flow which will be triggered on creation of contact entity. Here we go. Visit  https://make.powerapps.com  and select your environment and solution. Now click on new and add a new automated cloud flow and configure it as shown below: Configure first step as shown below: Now add a new step and search Bing Maps, and select Get location by point(preview) and configure it as shown below: Add a new step, search parse JSON and configure it as shown below: You can use below schema: {      "type" :  "object" ,

Displaying Bing Map on Canvas application in Power Apps.

Image
Hello Guys, In our previous  blog  we have seen how to retrieve Latitude and Longitude using Power Automate Flow. Today we are going to learn how to display Bing maps on canvas application in Power Apps. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. In our previous blogs we have displayed Bing Maps on Model Driven App. Consider a scenario where we need to perform the same thing on canvas application then how to achieve this. Bing Maps connector allows us to achieve this functionality in canvas application. Let's see how to do that. Visit  https://make.powerapps.com  and select your current working environment. Once done and select your solution. we will be creating a canvas application and Bing Map Connection from the scratch. First  we require Bing Maps Connector. Click on New -> More -> Connection Reference. Configure it as shown below: Now when you select New Connection, it

Getting latitude and longitude based on address from Bing maps using Power Automate Flow.

Image
Hello Guys, In our previous  blog  we have seen how to enable Bing Maps in D365 CRM. Today we are going to explore more about Bing Maps and Power Automate Flow. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. To work with Bing Maps using Power Automate we require to setup Bing Maps developer account. Click on  Bing Maps Portal . Click on Sign In Button and specify your credential.  Click on "Yes, let's create a new account" and fill the info as shown below and click on create. We will need an API key for our MS flows. Click on My account and choose My Keys. Specify the details and click on create. So now key is created. You can click on show key and copy the key paste it somewhere for future purpose. Now we will be creating two fields on Contact entity where we can display and store latitude and longitude. For time being we have already created this two fields as shown below: