Pre-Populating a Person Field using the Email String of Another Field

[EQ]

Hello,

I'm trying to pre-populate a person field based on the email entered in an input box. Below is a snippet of my edit form, table, and code. The person field is highlighted in yellow and the email string is underlined in red. Right now I am using a table that contains the person (person data type), their email (text data type), and their name (text data type).

When the email entered into the Associate_Director_Email input box matches the Person_Email in the table, I want it to return the matching person data type to the Associate_Director dropdown box (yellow). Any help is greatly appreciated. I can provide additional details if needed.

Associate_Director dropdown 'Default' code:

LookUp('Approvers List', associate_director_email.Text = Person_Email, Person)

Edit Form:

Table "Approvers List":

[Leif_Goleman]

@EQ -
I was able to find a fix to your issue. 

For your "Associate_Director_Email" text field, set the OnChange property to the following so you can get the GUID of the "Approvers List" table that corresponds with the email that you type in:

Set(

    PersonLookup,

    LookUp(

        'Approvers Lists',

        Associate_Director_Email.Text = Person_Email,

        'Approvers List'

    )

)

Note that you will need to press tab or select out of the text input to have the OnChange save the variable PersonLookup. Then, you will need to do another LookUp to the "Approvers Lists" table (be careful here and note that you are using the plural version of Approvers List with an "s") by setting the Item of the Form to:

LookUp(

    'Approvers Lists',

    PersonLookup = 'Approvers List'

)

This should populate the form with the data from the Approvers List table.

Please give a thumbs up if I was able to help you resolve your problem and thanks!

[EQ]

Thanks for the reply!

1. When I enter the OnChange code into the Associate_Director_Email (the final parenthesis gets cutoff in the pic) I get an error saying 'Incompatible types for comparison'. I don't understand how these aren't compatible since the input is text and the Person_Email is text.

2. When I enter the Item code into the Form I get an error code saying the types can't be compared.

3. When the Item code is in the Form I get the "No item to display" text. I tried putting "Defaults('Original Table');" before the code you provided but that does not help displaying the edit form.

Any further help is appreciated, thanks for your effort.

[Leif_Goleman]

I really want to help here, but I need a question answered first:
Does the form have only one data source connected to it? If so, is it just the "Approvers List" custom table you created?

[EQ]

The form is connected to another SharePoint table data source. The Approvers List (SharePoint) and another list that populates the titles of the cards in the form. This other list is what will be populated when the form is submitted. The Approvers List is a set of names and their corresponding email.

[Leif_Goleman]

One more question: Is this the SharePoint Custom form or is this a canvas app that you are working on?

[EQ]

It's a canvas app. The SharePoint custom form didn't provide enough functionality for our needs.

[Leif_Goleman]

@EQ , I have another solution for you:

OnChange of the Associate_Director_Email text field:

Set(

    PersonLookup,

    "Name of your text data card for Associate_Director_Email".Text

)

Finally, for the Item property of your form:

LookUp(

    'Approvers List',

    PersonLookup = Person_Email

)

Let me know how that goes!


Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.