Do you have the following requirements? You want create a HTML table in Power Automate from JSON data You want to send an email with HTML table in the body of the email using Power Automate If you have these requirements and you are wondering on how to accomplish the same, you are on the …
Introduction This is third article about using Bing maps in Canvas app. In earlier articles we discussed about how we can show event organizer data in the gallery control and render them in the Bing maps. Today we are going to discuss how to update entity data from canvas app. Canvas app with Bing Maps in Dynamics 365 CE –… Read more »
Source: Mahendra Pal
Do you have the following requirements? You want to pass an array from a Canvas App to a Power Automate You want to pass an array from Model Driven apps to Power Automate. You have to parse JSON data in your canvas app and perform further processing. If your requirement is similar to this, this …
How do I access related entity fields when using Fetchxml in PowerAutomate?
If you are having any of the above questions, you are at the right place. Strictly speaking, this blog is more about how to access related entity information in PowerAutomate through FetchXml. But as I am going to explain from the beginning, if you are not aware of the basics as well, this blog might help you with that too.
To demo this scenario, I am using the below fetchxml.
Quite evident from the above fetchxml, I am retrieving all the contacts associated with an account. For the account record, I am retrieving the value of “Address 1” field which is of type text and “Industry” field which is of type optionset. Also note the alias – “pa” I am using while I join with the account entity. And below is my Power Automate flow.
Quite a simple flow nonetheless. Below are the steps for the flow.
Declare couple of variables to store the Account Address and Industry
Run the fetchxml
Iterate through the items returned by FetchXml and set the value of Account address and industry.
You might be thinking, it’s quite a mundane one. And to be honest it is. But what does baffle infact a lot is your related entity data (in this case for account entity) does not show up in the Dynamic content pane of Power Automate flow.
Then how do I get it. It’s actually quite easy. Just select any placeholder value from Dynamic content pane and then from the side menu (ellipsis), choose “Peek Code“.
Copy the expression that you see in the value
Now to get the Industry code all we need to do is use the appropriate field names in the expression. Below are the expressions for Industry code and Address 1 fields.
Industry - items('Apply_to_each')?['pa.industrycode']
Address 1 - items('Apply_to_each')?['pa.address1_composite']
As you can see, I now have the correct values. Or is it? There is a small glitch though. The Account Industry is showing as 5 instead of name. That is because it is Optionset and if you put the field name in the expression, it will always give you the optionset value. If you want the Optionset text you need to use the below expression.
Power Automate Azure Logic Apps Power Automate is built on top of Azure Logic Apps It is a SaaS service for workflow automation across several different apps and SaaS services. It is a PaaS service for workflow automation across several different apps, SaaS services, and IaaS services for enterprise integration. For more of self-service and … Continue reading “Power Automate vs Azure Logic Apps”
Source: Nishant Rana