I am trying to do a double expand query in the "List rows action" for dataverse to fetch data from related entities and as a result, it only returns an outcome from the first expand as for the second expand it does not return the headofdepartment value
Knowing that the expand query logically is correct and also to make sure that I have used the OData Web API with the same logic and that it returned the desired outcome:
https://ORGURLdynamics.com/api/data/v9.2/cr884_job_title_histories?$select=statecode,_cr884_employee_no_value,_new_jobposition_value,cr884_end_date,_new_companyname_value&$expand=new_JobPosition($select=_cr884_employee_value,cr884_job_positions,_cr884_department_value;$expand=cr884_Department($select=_new_headofdepartment_value))&$filter=(_cr884_employee_no_value eq ce425204-aaa6-ec11-983f-0022489ef0f2 and statecode eq 0) and (new_JobPosition/cr884_job_positionid ne null)&$orderby=createdon desc&$top=1
What am I doing wrong in the expand query in the list rows action?
Any help is greatly appreciated.
Solved! Go to Solution.
Have you tried removing the "Fetch xml query" field? Maybe it has to do with the fields you're selecting. Have a look about a similar issue in this post by Sara Lagerquist: A Double Expand Query and Some Missing Dynamic Content in Power Automate – Sara Lagerquist
Hope that helps!