What you need to do is build an Array of the data (which you say you have a Table, not sure what that means), but what you wanted to do it
1. Get the Data from Power BI
2. Add an Apply to Each action, with the input being the output from the Power BI Data
3. Then inside the Apply to Each you would have your Add a Row into a Table
--And since Apply to Each is... essentially a Loop (sort of), you would use the Dynamic Property Values from step 1 (my steps list not yours)
where the data comes from the columns in power bi dataset and it would be pointing to the Row of data in the dataset based on the ordinal
in the loop. As when you get data, it gives it to you in JSON, Array format so you can loop it.
for Example let's pretend you had a column named FOO in Power BI, then when you set the Input to the Apply to each to the proper element of the Dataset, for example in SharePoint or Excel it would have body/value (and rows are under value in an array), then in your New Items data you would put something like
item()?['FOO'] where item() represents the CURRENTITEM of the loop and foo was your Column name. Putting the ? in between the path, ensures that if the Column is NULL or the property doesn't exist, it doesn't cause an unhandled exception in your flow.
Does that make sense?
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
