Person field to display 1 user

[Lefty]

I have a person field from SPO

How can i make it to pre-populate with a single user, which will never change?

[Lefty]

@mdevaney 

It doesn't recognize Mail as a valid function, i get red line in my functions, saying the function send email has invalid arguments

What would be be correct syntax if i wanted to change this:

Office365Outlook.SendEmailV2(Form1Head.LastSubmit.ManagerName.Email

 To something like this, this of course doesnt work:

Office365Outlook.SendEmailV2(Form1Head.LastSubmit."MYEmail.domain.com"

[mdevaney]

@Lefty 
OK, does any value show up in your put this code in the Text property of a label?

Form1Head.LastSubmit.ManagerName.Email

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[rebeccas]

The card Update would be: 

{DisplayName:"Name Here",
Claims:"i:0#.f|membership|" & Lower("Email Address"),
Department:"",
Email:"Email Address",
JobTitle:"",
Picutre:""}

For it to also display that name you can put on the DefaultSelected of the combo box: {DisplayName: "Name Here"}

[v-xida-msft]

Hi @Lefty ,

Do you want to populate a Person field with a specific user within your Edit form?

If you want to auto-populate a Person field with a specific user within your Edit form, please take a try with the following workaround:

Set DefaultSelectedItems property of the Person field ComboBox to following:

If(
    EditForm1.Mode = FormMode.New,
    { 
        Claims: "i:0#.f|membership|" & Lower(User().Email),
        DisplayName: User().FullName,
        Email: User().Email,
        Department: "",
        JobTitle: "",
        Picture: ""
    },
    Parent.Default
)

On your side, you may type following:

If(
    EditForm1.Mode = FormMode.New,
    { 
        Claims: "i:0#.f|membership|" & Lower("User1@email.com"),   // replace the User1@email.com with actual email address of the specific user
        DisplayName: "User DisplayName",   // Type the display name of the specific user here
        Email: "User1@email.com",
        Department: "",
        JobTitle: "",
        Picture: ""
    },
    Parent.Default
)

In addition, for your second question, the 

Form1Head.LastSubmit

formula would work only when you submit your Form1Head form successfully. You could not reference this formula result from another screen (where the Form1Head form is not located).

As an fixed solution, please consider set the DefaultMode property of the Form1Head form to following:

FormMode.New

then apply above formula (If(....) formula) as default value within this Person field ComboBox, then you could reference this Person field (ManagerName) value from any place within your app. So you could modify your send email formula as below:

Office365Outlook.SendEmailV2(
                             ManagerNameComboBox.Selected.Email,  // Reference Person field value here directly
                             "Subject",
                             "Body Message"
)

Note: Please replace the ManagerNameComboBox with actual ComboBox control name from your Form1Head.

Best regards,

[Lefty]

@mdevaney 

Just tried, and no its blank... so it appears its not resolving the users details or even an email.

Maybe what I need is the name of the line manager is patched to SPO before this form is submitted? 

[SkiDK]

Hi @Lefty ,

I've come across this too a while back (I remembered). I'll give you my code and hopefully it works for you:

So to create the user, I first created a variable of the user. For some reason I couldn't just patch the Office365.SearchUser(//user) and had to 'recreate' the user object first with all the fields separate in order to patch it to the SP list.

Set(AddressedToUserObject, {
    DisplayName: First(Office365Users.SearchUser({searchTerm:"User Search Term"})).DisplayName,
    Email: First(Office365Users.SearchUser({searchTerm:"User Search Term"})).Mail,
    Department: First(Office365Users.SearchUser({searchTerm:"User Search Term"})).Department,
    Claims: "i:0#.f|membership|" & First(Office365Users.SearchUser({searchTerm:"User Search Term"})).Mail,
    JobTitle: First(Office365Users.SearchUser({searchTerm:"User Search Term"})).JobTitle,
    Picture: Office365Users.UserPhoto(First(Office365Users.SearchUser({searchTerm:"User Search Term"})).Id)
});

Then when I wanted to create/modify an item, I somehow couldn't Patch with the user variable in the same patch as other column fields, thus I first patched all necessary fields in the SP list except for the user fields. Then for each user object I created a new patch:

Patch( 
    'Invoices Accounting',
    LookUp('Invoices Accounting', ID = varCurrentItem.ID),
    {
        Addressed_x0020_To: AddressedToUserObject   
    }
);

Since in my list I have 4 user columns, I have 5 patches to update one item. One for all the columns except user columns, and then 4 patches for the 4 user columns. 

I know it's really not a clean way to do this, but back then I found out is was the only reliable way then to make it work and it still works now.

I hope you can find some inspiration out of this. Let me know if you have more questions about this.

Good luck,

Ski

EDIT: @Lefty  There was some irrelevant code in my first piece of code. I removed that now. Instead of "User Search Term", you write a term on which you can find the specific user (display name, mail, ... -> see image below). Look at next post (the solution) that shows good information about how to use Office365Users.SearchUser({searchTerm:"User Search Term"}): https://powerusers.microsoft.com/t5/Building-Power-Apps/Office365Users-SearchUser-Search-by-location...

[Lefty]

Hi @SkiDK 

Thank you for the detailed response, I will give your suggestion a try if i can't get this to work, as I think i'm very close to getting there (he says).

@v-xida-msft @mdevaney 

The only thing i believe i need is the ability to simply email 1 user in the To field, at that stage of the form.

I do not receive the email notifying this user they have an action, but if just go to the screen they would if they received the form, I can complete the form and the data is written back to SPO/form when i submit that screen so that all works.

I simply need the ability to email this user via function, and as its not recognising the manager Field, I'm happy to just type in the email address, the issue appears it does not like the syntax if i just put in the email address in place of the ManagerName field:

Office365Outlook.SendEmailV2(Form1Head.LastSubmit.ManagerName.Email

[rebeccas]

On the OnSuccess of the form submittal that has your "Manager" you want you can set a variable and then refer to that with the code I used above for your combo box. (of course this will only work within the same session, if they leave in come back you will have to look to a data source)

Form OnSuccess: 

Set(varMgrName, FormName.LastSubmit.MgrColumn.DisplayName);

Set(varMgrEmail, FormName.LastSubmit.MgrColumn.Email)

Combobox - Update

{DisplayName: varMgrName,

Claims:"i:0#.f|memership|" & Lower(varMgrEmail),
Department:"",
Email: varMgrEmail,
JobTitle:"",
Picture:""}

[v-xida-msft]

Hi @Lefty ,

Have you taken a try with the solution I provided above? Could you display the one user within the Manager field correctly with the formula and save data back to your SP List correctly?

If you want to send an email to a specific user, as direct solution, you could type the email address within the Office365Outlook.SendEmailV2() directly as below:

Office365Outlook.SendEmailV2(
                             "User1@email.com",    // hard code email address here
                             "Subject",
                             "Email Body Message"
) 

If you want to get the manager email address based on current sign in user, and send an email to the manager, I think the Office 365 Users connection could achieve your needs. On your side, you could modify your formula as below:

Office365Outlook.SendEmailV2(
                             Office365Users.ManagerV2(User().Email).mail, // Modify formula here
                             "Subject",
                             "Email Body Message"
) 

Note: The Office365Users.ManagerV2(User().Email).mail formula is used to get the manager email of current login user. The Form1Head.LastSubmit.ManagerName.Email formula could only return proper value only when you submit the Form1Head successfully.

Please consider take a try with the above solution, check if the issue is solved.

Best regards,

[Lefty]

Hi all

I did not want to over complicate things, so based on @mdevaney  suggestion of how to get the users name in the field, 
i've just added the field at the first stage (when user1 submits the form), kept it hidden on that form as its not needed tehre, the data is then submitted on the first save into SPO.

When the form gets to the stage where it needs that users email, the send email works fine as the data is already written to SPO:

Office365Outlook.SendEmailV2(Form1Head.LastSubmit.ManagerName.Email

Thank you everyone for your help on this