Answered

PowerApps Canvas App - Get External User (B2B)

(0) Share

Report

Posted on by kmw1130

995

I had created an app that is using the O365 Users (Email) matches the email in an SharePoint Employee List. We have recently set up another tenant that we will be moving to and some of the users are in that tenant with a different email address, but they are listed in the SharePoint Employee list. I need to be able to capture who the person is because they are filling out a survey and I am sending reminders to the ones that have not completed. On my app start I have variable for:

Set(varUser, Office365Users.UserProfileV2(User().Email).mail);
 
which I am using throughout the app to verify if the varUser has an entry in the Survey list on Sharepoint.
 
My thought was my first screen would be for the user to pick their name from the dropdown (Employee List) and set that as the varUser.
 
Is that possible?

Categories:

Building Power Apps

GCC, GCCH, DoD - Federal App Makers (FAM)

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@kmw1130,

You are using the Office365Users connector this will only looks up profiles in the current environment (tenant).

If the same person exists in another tenant (with a different email), Office365Users.UserProfileV2(User().Email) won’t find the cross‑tenant account, and your varUser logic won’t match.

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @kmw1130,

Adding to @MS.Ragavendar's post, if you simply want their name and/or email address, use this
Set( varUser, User() )

You can then use one of those fields varUser.FullName or varUser.Email to look up your data source.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
kmw1130 995 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz and @MS.Ragavendar Thank you both for your reply. They are invited as guest users, so they do show up in Azure, if that makes a difference. But I want to also be able to match their email with what I have listed in my Employee SharePoint list, to determine if they completed their survey. My thought was to have them type in their email address to compare what is in the employee list or have a dropdown for them to select their email from the employee list and capture that. Not sure if either of those are a doable option.

I will try the User() vs using the

Office365Users.UserProfileV2(User().Email).mail);

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kmw1130,

I probably need to reiterate @MS.Ragavendar's post here - the Office365Users.UserProfileV2 function will generally only return details from users in your tenant. The only two values available to you will be the FullName and Email properties of the User() function.

However you have the email, so why not simply match that with the value in the SP List ? I have a prod app with security permissions on a number of functions where external users need management and this works fine looking up a table using User().Email. Actually if they are not in the table, the landing screen stops them with a message they have no authority on the app, even if it is shared with them.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kmw1130,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@kmw1130, A quick follow-up to see, does the suggestion from @MS.Ragavendar / @WarrenBelz worked for you or still you were looking for any other approaches or assistance.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No