Insert Rows from Fabric Data Warehouse Table into D365 Table
I have a Microsoft Powerapps table that currently gets updated by a D365 form. There are some data validation/lookups that occur after certain values are entered.
In Fabric I also have a table that pulls the same table from D365 and checks another database for new data to be added back into D365.
I have setup a Dataflow Gen 2 in Fabric to land the table in a Fabric Warehouse. I also have a Dataflow in Powerapps that can see this table.
I've selected "Append" as the Import method in Powerapps Dataflow, it says it runs successfully. However, none of the new rows appear in the existing table.