Answered

How to use an automate flow to create relationships and lookup in Dataverse.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Not sure if this goes into PowerApps, Power Automate or Dataverse.

I have 4 CSV files that contain my data. I upload all 4 CSV files to Dataverse creating 4 separate tables of 1000+ records each. I want to create relationships between the existing data in those tables. How would I begin to do that using a flow? I'm having trouble seeing the concept of the flow.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You could try to create a relationship between 2 tables.

If you want to create a one to many relationship , you can create a lookup field in 'many' table.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply.
Turns out the tables I'm importing have complicated relationships and lookups. I had MSFT person tell me the import CSV feature in Dynaimcs/Model App is great for more simple imports. I should use SSIS and Kingsway to do the import in my case. As long as you don't run a timed job Kingsway is free to use.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have a good day.

Has the issue been resolved?

Best Regards,

Wearsky

Was this reply helpful? Yes No