You’re offline. This is a read only version of the page.
39
Hello, I have a problem importing data for power pages.
Here's the situation. In Dataverse, I've created a new column called id_user in the Contact table.
I have data in Excel format that I import into Dataverse. This Excel file contains a column named id_client.
I'd like to create a N : 1 relationship between id_user and id_client. The problem is that I can create a relationship between the two tables, but between the id_client and the primary column of the Contact table.
Can I create a relationship between id_client and id_user and avoid entering all the data manually?
Hi @marbaluv,
I guess you are going to create a LookUp field which automatically is connected to the primary column inside the related table. As you want to create a N:1 relationship you will need more entries in that one table to relate to the other table. What you can do is create a table with just 2-3 columns, user userId and clientId and match them there. You will have one big table and can later on use a flow or another lookup column to get all info from the Client table. What you want to establish sounds more like a N:N than a N:1 relationship.
--------------------------------------------------------------------------------------
Hope that helps.
If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.
Share
Report
All responses (
Answers (
