Answered

Relationship is not working in the tables !!

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (5)

Answers (1)

PrexaTrial8 4 on at

Like (0)

Report

Re: Relationship is not working in the tables !!

work
PrexaTrial8 4 on at

Like (0)

Report

Re: Relationship is not working in the tables !!

how to check the relationship in power apps if it's not working
Community Power Pla... on at

Like (1)

Report

Re: Relationship is not working in the tables !!

Hi @Lucas001 , @saudali_25 ,

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

Kind Regards,
Hafiz
Verified answer

Saud Ali 812 Super User 2024 Season 1 on at

Like (2)

Report
Re: Relationship is not working in the tables !!

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.
Lucas001 2,174 Super User 2025 Season 1 on at

Like (1)

Report

Re: Relationship is not working in the tables !!

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.