Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
In order to get details of related entity for the selected entity without separate retrieve call we can leverage Expand Query .As a business scenario for the same vaccination use case extracting details of accounts that are present in list of contacts who took vaccination.
Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on the left-hand side as shown in the below figure.
After Step 1, Click on New Flow and select instant cloud flow and provide the trigger as Manually trigger a flow and click on Create as shown in the below figure.
After Step 2, name the flow as List Rows – Expand Query take another step and take initialize variable and name it as Initialize variable – Set ConsolidatedDetails Array and provide inputs like below
Name : ConsolidatedDetails
Type : Array
as shown in the below figure.
After Step 3, select new action and under Data verse Connector and select action List Rows and name it as List rows – Contacts on the contact entity and provide the following inputs as below
Table name : Contacts
Select columns : fullname,telephone1,contactid,_parentcustomerid_value
Filter rows : (cr5bc_vaccinationcompleted eq true) and (parentcustomerid_account/accountid ne null)
Expand Query : parentcustomerid_account($select=address1_city,address1_composite,websiteurl,name)
After Step 4, Take Apply to Each Action and provide value as
And take Set Variable name it as Append to array variable and provide the following values as
Name : ConsolidatedValues [ Select Initialize Array variable from Drowdown]
“Customer Name”: items(‘Apply_to_each’)?[‘fullname’],
“Account City”: items(‘Apply_to_each’)?[‘parentcustomerid_account/address1_city’]
After Step 5, save, test, and run the flow and observe the details as shown in the below figure.
Conclusion: In this way one can easily extract details of related entities linked to the base entity using expand query.
Business Applications communities