Answered

Relationship is not working in the tables !!

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I got a problem that my relationship between contacts and "Application Test" table is not working. I have defined the relationship using lookup column. When I signIn and fill the form in "Application Test", it is successful. But when I try to check "User Name" which is a lookup column from the "Contact" table, it is blank. I am not sure why it is not working. Below snapshots explain the scenario.

UserName column is blank:

Can you please guide me on this?

@Lucas001 , @saudali_25 , @ragavanrajan I think you can easily solve this. Please check this as I believe I am making a simple mistake. Thanks!

Kind Regards,

Hafiz

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Lucas001 2,567 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

could you shortly give us a screenshot of your form, just to see if it is setup correctly?
Are you populating the field yourself, the question was raised some topics ago.

The relationship as well as the setup of your tables looks good to me.

Was this reply helpful? Yes No
Verified answer

Saud Ali 812 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming your User Name (Individual Lookup) column is null after your application is submitted.

Portal doesn't save contact information by default when we create a record from Portal until configuration/script is added to set Lookup column. Please follow these steps:

Go to Portal Management App
Open your targeted form (Assuming you're using Basic form, but you can set it for Web Form as well)
Go to Additional Settings
Navigate to sections Associate Current Portal user on Insert
Check Associate Current Portal User
Select your created column (e.g., User Name) in Portal User Lookup Column
Save & sync your changes!

After adding this configuration, your lookup column would be filled on submission of Application Test form.

Feel free to ask, if you have any questions.

Thanks,
Saud

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Lucas001 , @saudali_25 ,

Thank you so much for your support. @saudali_25 , your solution worked for me perfectly. Thanks heaps!!

Kind Regards,
Hafiz

Was this reply helpful? Yes No
PrexaTrial8 4 on at

Like
a
(0)

Report
Copy link

Link copied!

how to check the relationship in power apps if it's not working

Was this reply helpful? Yes No
PrexaTrial8 4 on at

Like
a
(0)

Report
Copy link

Link copied!

work

Was this reply helpful? Yes No