Dataflow "Created On" Dates

(0) Share

Report

Posted on by EMKody

147

Hi all,

I have a dataflow setup that copies data from out Salesforce environment, and places it into a Dataverse table to be used in various solutions. The problem that I am currently facing is that the "Created On" and "Modified On" dates for all entries are updated every time my scheduled flow runs (daily). Is there something that I can do so that the "Created On" date only shows the date that entry was actually added to the table? I have been able to achieve the desired behavior by unchecking the "Delete rows that no longer exist in the query output", but this ends up creating a new entity for each Salesforce account each time the dataflow runs.

Thanks in advance for any help!

Categories:

Microsoft Dataverse with Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

ChrisPiasecki 6,428 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @EMKody,

Have you tried setting up an Alternate Key on a column that has unique values? This will allow you to update existing records rather than creating new duplicate records, thus keeping your created on date intact.

Field mapping considerations for standard dataflows - Power Query | Microsoft Learn

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
EMKody 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Chris,

This is super helpful! I was unfamiliar with the concept of "upserting". I will implement and report back!

Thanks,
Kody
EMKody 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Chris,

I recreated my dataflow and included an alternate key, however it seems that my "Created On" date is still updating each time the flow runs.

Thanks,
Kody
ChrisPiasecki 6,428 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @EMKody,

Did you map the alternate key field as outlined in the article?

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
EMKody 147 on at

Like
a
(0)

Report
Copy link

Link copied!

I did, not sure what my issue was the other day, but after letting the flow run for a few days I am seeing the desired behavior! Thanks for your guidance @ChrisPiasecki!