web

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

News and Announcements icon

Power Platform CommunityForums Power Pages import data and create...

Power Pages

Answered

import data and create relationship

(0) Share

Report

Report

Posted on by marbaluv

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?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Lucas001 2,555 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

You're Invited to Keeping It Real with the Power Platform

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

oliver.rodrigues 36 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans