[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 676
  • Last Modified:

SharePoint Form & Submit Options

Hi

I'm using SharePoint Online as part of Microsoft's Office 365 (Plan E3) system.

We are integrating an InfoPath form so that users can fill out for resource requests. I have the form working perfectly. I have setup a "Submit" button on the form which sends the request to a shared mailbox that can then be accessed by the relevant resource creation team.

What I would like to do is CC in the the person that has submitted the request. Using InfoPath I have added the expression :
Submit Expression 1and
Submit Epression 2
When I click the submit button on the form, the email comes through:
Resulting EmailBut as you can see the address that has been entered into the CC field is in a strange (none SMTP) format and the user that submits the form doesn't get an email.

Any ideas folks?
Thanks
Mark
0
Mark Galvin
Asked:
Mark Galvin
  • 2
1 Solution
 
CloudedTurtleCommented:
Try using this formula in your CC field...
substring-after(userName(), "membership|")

Open in new window

The Username value for Office 365 is an odd format. It would be great to see some extended InfoPath functions/fields to select the "User.Email" but I am not holding my breath for them.

-CT
0
 
Clay FoxDirector of Business IntegrationCommented:
Yah, you may want to use the user lookup web service to get the actual address or if everyone has the same domain do a  concat(substring-before(user.name, "@"),"@","domain.co.uk) and just build it yourself.
0
 
Clay FoxDirector of Business IntegrationCommented:
I missed the extra garbage at the front but just use substrings to eliminate everything before the second bracket.
0
 
Mark GalvinManaging Director / Principal ConsultantAuthor Commented:
Awesome fix. Thanks CloudedTurtle!!!!
0

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now