I have been trying to use the expand transformation in order to get related data in one call. I need data from 5 tables and would rather not have 5 Get Row steps.
Here is what I tried so far for the Aggregation Transformation field on the SQL Get Rows action:
I am referencing:
Each time I get an error:
'aggregate|filter|groupby' expected at position 0 in 'apply=expand(myTable)'
What is the correct syntax to use the expand transfromation on the Get Rows action in Flow?
The Aggregation Transformation field only support aggregate function, filter function and groupby function on Get rows action in Flow currently. The expand function is not supported in Aggregation Transformation field.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.