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:
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!