Share
Report
4Hello,
I am designing a flow which will run once daily. It will pull data from a Power BI data set, put it into an array, and then check that array against a table in Microsoft Excel. And entries that are in Power BI but not in the Excel table need to be added to the table (there will be a total of 6 columns to fill in) and any entries that are in Excel but not in Power BI need to be deleted from the table.
I know this will require Run a Query Against a Data Set, Select, Compose, Apply to Each, Get a Row, and Add a Row but I'm having a hard time getting them to work correctly. At the moment I have Run a Query Against a Data Set (pull data from Power BI), then Select (rename the columns from Power BI), then Compose (make an array with the Power BI data), then Apply to Each, Get a Row, and if Get a Row fails, then Add a Row. But it seems to be adding a bunch of blank rows to Excel.
Appreciate any help you can provider, thanks!
All responses (
Answers (
