How to add relationship defined column in dataverse

Pete Orrell 20

Im following the tutorial found here . I'm at the point of defining a relationship for the User table. I have created the relationship, however when I go to add the column to the Expense Report table, I am unable to find it.

Syed Saleem Peera 2,110 Reputation points Microsoft Vendor

2024-07-11T06:44:34.3433333+00:00

Hi Pete Orrell,

Thank you for reaching out to us on Microsoft Q&A forum.

Can you please specify the exactly where you are encountering this error along with the screenshot for reference.

Thank you.
Pete Orrell 20 Reputation points

2024-07-11T22:24:27.9866667+00:00

Hello @Syed Saleem Peera ,

As instructed in the tutorial, I have opened the User Table:

Then created a Schema Relationship Many-to-one

Then called the Lookup column name as Requestor

The tutorial then directs to add a column with the same name to the Expense Report table, however when i go to add that column it is not available as an option

2 answers

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Syed Saleem Peera 2,110 Reputation points Microsoft Vendor

2024-07-12T03:42:47.3033333+00:00

Hi Pete Orrell,

Thank you for reaching out to us on Microsoft Q&A forum.

Instead of searching for the lookup column name Requestor, search for Traveler. Please refer to the screenshot below.

We tried from our end; it's working fine for us. Kindly refer the below screenshot.

If you are still facing any issue, where you are encountering this error along with the screenshot for reference. Please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.
Please sign in to rate this answer.
Pete Orrell 20 Reputation points

2024-07-12T04:10:25.2566667+00:00

Hello, thank you for your reply. I did not name my Lookup column as "Traveller" as per the tutorial, but 'Requestor'.

Pete Orrell 20 Reputation points

2024-07-12T04:12:30.9933333+00:00

I am able to view that column in the User Table

But not the Expense Report table as mentioned in the tutorial.

Syed Saleem Peera 2,110 Reputation points Microsoft Vendor

2024-07-12T04:22:22.5266667+00:00

Hi Pete Orrell,

Could you please share the screenshot where you find 'Requestor' for better assistance?

Thank you.

Syed Saleem Peera 2,110 Reputation points Microsoft Vendor

2024-07-13T03:59:50.9333333+00:00

Hi Pete Orrell,

Could you please share the screenshot where you find 'Requestor' for better assistance?

Thank you.

Pete Orrell 20 Reputation points

2024-07-15T02:43:24.8733333+00:00

The Requestor column is here in the User table

Syed Saleem Peera 2,110 Reputation points Microsoft Vendor

2024-07-15T07:32:17.2933333+00:00

Hi Pete Orrell,

Thank you for your patience.

Please follow the instructions at https://learn.microsoft.com/en-us/training/modules/create-data-model-expense-report/4-relate-tables. Refer to points 9, 10, and 11 to understand how the traveler is created. Kindly refer the below screenshot.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Syed Saleem Peera 2,110 Reputation points Microsoft Vendor

2024-07-15T13:53:47.6333333+00:00

Hi Pete Orrell,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.
Sign in to comment

Share via

How to add relationship defined column in dataverse

2 answers