Office 365 Query User Profile Action guide

Andrew , you are right on using the the format value. The placeholder values are very misleading as you can't see what you actually choose to show.

But is there any way of getting the phone number or any other useful info in the profile?

Yes, in the Property setting you set with the name of the property you need back, such as Phone. http://help.nintex.com/en-US/O365/#O365WorkFlow/Workflow Actions - INT/Office 365 Query User Profile.htm

But this needs a password. Users opening forms or running workflows have already been authenticated. They should already be able to look up info such as a phone number. Why should a password be necessary? Can I query the user profile without a password. If I setup my password and ID here, will I need to change it on the workflow everytime I reset my password... it would seem so...which would make this a real bother (when everytime my password is changed, workflows break). Is there a way around setting a password. I really do not want to ask our security folks to create a bespoke account for this. Like a SharePoint App Step, there should be a way of running it with publisher's permissions - Is there?

That's a great suggestion to not require credentials if used within an App Step. I would post that  here 3 - Nintex Workflow for Office 365: Hot (141 ideas) – Customer Feedback for Nintex

But you may be able to use a rest call within an App Step to do the same thing.

Get all properties of Specific User

http://siteurl/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='i:0%23.f|membership|username@siteurl.onmicrosoft.com0%23.f|membership|username@siteurl.onmicrosoft.com'

Get Specific UserProfile Property of Specific User

http://siteurl/_api/SP.UserProfiles.PeopleManager/GetUserProfilePropertyFor(accountName=@v,propertyName='WorkPhone')?@v='i:0%23.f|membership|username@siteurl.onmicrosoft.com0%23.f|membership|username@siteurl.onmicrosoft.com'

Done - but seems I've been doing that a lot since recently..."Publisher Action" Setting on Query the User Profile action, not requiring a fixed password, using the publisher's permi…

https://tenant.sharepoint.com/_spi/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='i:0#.f|membership|daniel.westerdale@tenant.onmicrosoft.com'

I get a 404 error when I test against my actual tenant using Postman.  Note, I have run the interceptor to login into the tenant.

Anybody else attempted this?

As aside, looking at the (sparse) documentation, if I use the alternative Office 365 Query Profile Action, then I have a configure each one per property.  It works ok tho with what ever email format I have entered for the test user.

when passing the email id in the query user profile action, please truncate the extra chars prefixed with email id in person type column. Then it will get the required property.

To get the phone number, SharePoint person type column will be sufficient. No workflow is needed.