Unanswered

Email String Read by Filter as Office365Users.UserProfileV2

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have an email column in SharePoint with data property as string will it be possible for my filter to read this as a Office365Users.UserProfileV2. Goal is to show this as Display name in my drop down, is this even possible?

Any guides & ideas will be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Anonymous

Yes this is all possible.

However, having is selected in your dropdown will be a matter of matching against the Items property of your control. If the Items are based on a Search of users, then you can use the UserProfileV2 as your default property. Otherwise, you just have to match Items to Default.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

Thanks for the response, could you provide a sample of this?

I am planning to have dropdown or combo box to have an "All' for my collection so that my Gallery will show all the Names in the rows.

I wonder if this solution is still achievable if I have emails string separated by ";". As column will have sometime 2 to 4 emails. Should I consider search box instead?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Sorry for my delay on this. Are you still having the question or have you resolved it?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

I was able to separate the email string, how do I show this on my dropdown box as Office365 user display name?

Any inputs?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Sure thing - what is the Items property of your Dropdown? (And is it a dropdown or a combobox?)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

I am using a dropdown with items property of string.

Currently this are email address string which I also manage to separate multiple values with the delimiter ";" and applied distinct values.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous

I'm not entirely sure what you mean by the Items property is a string. Items properties are always tables. They may be tables of strings, but they cannot be just a string.

So, I will assume perhaps that you have a table of strings of emails and will proceed with that.

Your formula (for example) would be the following on the Items property of the dropdown:

ForAll( ["email1@domain.com", "email2@domain.com", "email3@domain.com"], {Value: Office365Users.UserProfileV2(Value).displayname} )

This would give you a dropdown with Display Names of the users. However, each selection would now be the Display Name only (dropdownx.Selected.Value will be a Display Name). If you still want the email address as well and simply want to display the name, then change formula to the following:

ForAll( ["email1@domain.com", "email2@domain.com", "email3@domain.com"], {Value: Office365Users.UserProfileV2(Value).displayname}, Email: Value )

Now dropdownx.Selected.Value will be the Display Name and dropdownx.Selected.Email will be the email.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

Thanks for your reply, I should have added its a string collection. Sorry I forgot to mention this.
I cannot seem to make this work in my collection.

ClearCollect(
PersonDropDownColALL,
PersonDropDownCol,
ForAll(
Filter(
Distinct(
Split(
Concat(
GalleryDataCol,
Users & ";"
),
";"
),
Result
),
!IsBlank(Result)
),
){Value: Office365Users.UserProfileV2(Value).displayname}
);

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

This is a bit convoluted. Can you explain more about the purpose of this formula and the definitions of the PersonDropDownCol and the GalleryDataCol?

Are you trying to populate a dropdown with the display names of the users currently in a Gallery?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes,

Both PersonDropDownColAll and PersonDropDownCol are colletions. These collection contains below:

PersonDropDownCol, {Result: "All Users"} and I added this to my PersonDropDownColALL so that this will be the first item in my dropbox.

My GalleryDataCol is basically my collection from Source SharePoint list.

Yes, I am trying to populate the dropdown with the display names of users in the gallery.

Was this reply helpful? Yes No