web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Pages
Unanswered

Look up related

(0) ShareShare
ReportReport
Posted on by 12

I have basic form in that form having the field name Email ID and my contact table having the Email field. 
my requirement is using contact table Email what are all related form table field was want to show . how can I get it please explain.

Categories:
I have the same question (0)
  • Lucas001 Profile Picture
    2,541 Super User 2026 Season 1 on at

    Hi @arunm1424,

     

    this will be a bit more difficult.

    When I understand you correct you got a basic form of Email, let's say table 1, and want to relate that Email in another form to your contact entity.

    What you can do is create a lookup inside your table 1 to your accounts. Than create some column and use the formula data type and enter something like columnname.name to get the info of the contact entity. You can than adjust the form and diplay all information needed.

     

    The only question is how do you set up the email in your new entity? In case it's done dynamically over the page, create a PowerAutomate Flow which has a look at the mail filters the contact table and write the lookup in the new column.

    --------------------------------------------------------------------------------------

    Hope that helps.

    If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

  • Akah Mandela Profile Picture
    445 on at

    To get all the related form table fields based on the email address in the contact table, you can try the following steps:

    1. Create a Lookup field in the form table that points to the Contact table.
    2. Set the Display field property of the Lookup field to the Email field in the Contact table.
    3. When the form is submitted, the email address from the form will be used to look up the record in the Contact table.
    4. The related form table fields will then be displayed on the form.
  • arunm1424 Profile Picture
    12 on at

    Thanks for your response. i need more clarification how can i contact you sir. could you please help me.

  • arunm1424 Profile Picture
    12 on at

    thanks sir . I need more clarification how can I contact You. please help me.

  • Lucas001 Profile Picture
    2,541 Super User 2026 Season 1 on at

    Hi @arunm1424,

     

    it's exactly as @mandela and I stated. Have a look at that tutorial: https://www.youtube.com/watch?v=BPkv7S11Zp8 

    I hope it covers what's needed.

  • arunm1424 Profile Picture
    12 on at

    Ok sir now I am going to try it

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 64

#2
DP_Prabh Profile Picture

DP_Prabh 34

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 30 Most Valuable Professional

Last 30 days Overall leaderboard