Look up related

arunm1424 · ‎09-06-2023

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.

Lucas001 · ‎09-06-2023

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.

mandela · ‎09-06-2023

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

Create a Lookup field in the form table that points to the Contact table.
Set the Display field property of the Lookup field to the Email field in the Contact table.
When the form is submitted, the email address from the form will be used to look up the record in the Contact table.
The related form table fields will then be displayed on the form.