Populate entity with Flow

(0) Share

Report

Posted on by notj

780

Attempting to achieve

I'd like to be able to populate the data in an entity from a SQL table. It's for a list of buildings. This information should be updated regularly.

Things tried

I tried using a dataflow but it seems like no matter what I tried, it would wipe out the data and replace it. This breaks every lookup field that uses the entity.

How are people accomplishing this in their environments?

Categories:

Entities

All responses (2)

Answers (1)

notj 780 on at

Like (0)

Report

Re: Populate entity with Flow

@HSheild thank you! This is all I needed.
Verified answer

H Sheild 3,000 Most Valuable Professional on at

Like (1)

Report

Re: Populate entity with Flow

Take a look at this article to get you started. It talks about Dynamics 365 but you can replace that word with CDS since it is that same thing and uses the CDS connector.

https://dynamicscitizendeveloper.com/2019/06/06/microsoft-flow-csv-integration-with-dynamics-365/