cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lefty
Post Prodigy
Post Prodigy

Person field to display 1 user

I have a person field from SPO

 

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

1 ACCEPTED SOLUTION

Accepted Solutions

@Lefty 
I think the User email is missing on your Claims line.

 

{
    '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    Claims:"i:0#.f|membership|" & "Myemail@domain.com",
    DisplayName:  "My Name",
    Email:  "Myemail@domain.com",
}

 

---
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."

View solution in original post

19 REPLIES 19
Lefty
Post Prodigy
Post Prodigy

hmm possibly figured it but need to test:

{  
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",  
    Claims: "i:0#.f|membership|" & "", 
    DisplayName: "My Name",  
    Email: "Myemail@domain.com"
}
SkiDK
Solution Sage
Solution Sage

I think you can try it with the Office365users connector, like this with 'john.smith@mycompany.com' as example for an user:

Office365Users.UserProfile("john.smith@mycompany.com")

 

@Lefty 
I think the User email is missing on your Claims line.

 

{
    '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    Claims:"i:0#.f|membership|" & "Myemail@domain.com",
    DisplayName:  "My Name",
    Email:  "Myemail@domain.com",
}

 

---
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."

View solution in original post

@mdevaney 

 

Thanks, as i just tried it with what I had and it failed to send that user an email.

I'll try your approach.
Quick question, will this work, if the screen this field is on, has not been accessed yet, rather I am emailing this user in the field in a screen before any user comes to that screen:

 

Office365Outlook.SendEmailV2(Form1Head.LastSubmit.ManagerName.Email...................

 

Thanks @SkiDK 

Hmm, Didn't think it would be that simple, that seems to work, but I cant seem to use that field to email the user i get an error when my form submits

@mdevaney 

 

Thanks, but it doesnt allow me to send an email to that user, as per my previous message, this field is on Screen9, and the user submitting the form is in Screen8

I guess I can hard code the users email in the send to email, I was just hoping I would not need to

@Lefty 
The Office365Outlook.SendEmailV2 will work from any screen but keep in mind your Form will have to be submitted in order to use LASTSUBMIT in your formula.

 

---
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."

@mdevaney 

 

Yes the form has been submitted a few times, by the time it gets to this stage, all previous submissions work fine, but with this new addition to requirements, cant get it to function

@Lefty 

Does it work if you use the Mail property instead of Email?


Form1Head.LastSubmit.ManagerName.Mail

 

---
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."

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (63,398)