web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to add a record au...

Power Automate

Answered

How to add a record automatically into dataverse table A when record add a into dataverse table B

(0) Share

Report

Report

Posted on by Erandi

265

HI,

my requirement is How to add a record automatically into data verse table A when record add a into dataverse table B. When a record add into Table B, should add it's column values into table A also(by flow). and also after updating record of the Table B, it should be updated into table A(by flow) ,I used when item is added and modified as the triggering point .

in my table A, I have used Email, Employee name fields. so I want to add those created record into table B also by the flow.

thanks

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Erandi,

You could have a look at using a dataflow for this with Power Query instead? That might be able to handle creates, updates and/or upserts a bit better:

https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

I have shared an example in this other thread:

https://powerusers.microsoft.com/t5/Building-Flows/Identify-unique-values-from-a-Dataverse-table/m-p/2372258/highlight/true#M264379

Below is that same example.

1. The dataflow

2. A Power Query to remove duplicates based on the combination of two columns

let Source = CommonDataService.Database("<orgid>.crm11.dynamics.com"), #"Navigation 1" = Source{[Schema = "dbo", Item = "crca4_factor"]}[Data], #"Removed duplicates" = Table.Distinct(#"Navigation 1", {"crca4_baseyear", "crca4_factorname"}) in #"Removed duplicates"

3. Loading that data into an existing table and mapping the source to destination columns

4. Example of dataflow refresh history run with upserts (with updated rows and inserted rows).

Was this reply helpful? Yes No
Erandi 265 on at

Like (0)

Report
Copy link

Link copied!

thank you very much @Expiscornovus it is very helpful answer

Was this reply helpful? Yes No

Join the conversation