Append New Rows to Table

[scojo1971]

Good Morning,

I am new to building a Power App and looking for some advice on how to only add new rows of data to my Dataverse Table.

Here's my process flow so far:

1. Each morning I get new "raw data" via an email attachment in the form of an Excel Spreadsheet.

2. When the "raw data" hits my inbox, a Power Automate Flow is triggered to run and takes the attachment and drops it into a Share Point Document Library.

3. Once the file is added to the Share Point library a second Power Automate flow is triggered to run, which runs a Power Query data flow that refines the data in the attachment and ends by adding new data to the Dataverse table.

I have set up test data up with only 4 rows of data. 

So I am pretending that:

• my first on my first day I get the first row of data.
• my second day I get the first and second rows of data
• my third day I get the first, second and third rows of data
• my fourth day I get the first, second, third and fourth rows of data

If was back in access, then I would use a right join and keep the null values when appending these new rows.  I am just not sure how to do this in Dataverse.

Any ideas or suggestions would be appreciated.

Thank you,

Scott

[dpoggemann · Accepted solution]

Hi @scojo1971 ,

You need to define an alternate key on your Dataverse table and map to this key when sending in the records to be able to "update" them in your flow.  This will stop duplicate records from being created based on the unique key identifier.  https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-pow... 

[scojo1971]

@dpoggemann , I really thank you for responding to this and providing a link to such a great post.  I was starting to investigate this idea myself since I hadn't heard back from anyone from the community.  I appreciate you!

Scott