Issue with Type Person Column Email in Power Apps

[sebastiandcarri]

Hi

I'm having the next issue, when I try to get the email from a person type column it was replaced by the column name and I'm not getting the value.

I'm trying to filter a galley, my column name is Recognized but when I try to used Recognized.Email the Email option is not there and instead there is an option with the same name of the column, I created a new app but happens the same.

[StalinPonnusamy]

Hi @sebastiandcarri 

If this is a person column in Sharepoint then we can filter like

Filter(SPList, PersonColumName.Email="emailid")

Example

Filter(IssueTracker, 'Assigned to'.Email="stalin@ltiblogs.onmicrosoft.com")

 If this not works, Can you share Sharepoint settings for the person column?

[rebeccas]

I see on the third choice you have in screen shot is Recognized...have you tried starting to type and then clicking on it with your mouse? What happens then if so?

[sebastiandcarri]

@rebeccas Hi Rebeccas, that option is replacing Email field from the person type column, I don't know why it changed but for example when I try to filter a gallery by current user  usually the formula should be:

Filter(MySP, Recognized.Email=CurrentUser.Email)

I don't have the Email option from the column recognized so I tried Recognized.Recognized but didn't work. Only happens with this database, I created new SP lists with type person column and works fine with the .Email option, 

[sebastiandcarri]

Hi @StalinPonnusamy. I need the gallery to be dynamic and show the information filtered for the current user, 

I have it like your example but the problem is that I can't get the option .Email from the person column type, it was replaced as shown in the screen by Recognized, and still don't why.

This is the config.

[StalinPonnusamy]

Hi @sebastiandcarri 

It's weird. I recommend removing the connection, clear the cache, and add the SP connection back.

Then Items property of Gallery to

Filter(SPList, PersonColumn.Email=User().Email)

[rebeccas]

@sebastiandcarri 

Did you change the column name at any point? If you create a column and then rename it that doesn't work, you have to delete the old one and add a new one or you will have issues with the name. 

I can show you how to tell if that is it but did you rename it at any point before we go further into this?

[sebastiandcarri]

@rebeccas Yes, I did but it did work fine with the name change, after the change I was able to use the .Email data from the person type column. 

[StalinPonnusamy]

Hi @sebastiandcarri

Since this was working, I recommend creating a new person column on the same SPList and use it.

[rebeccas]

It mike "work fine" after name change but it will be inconsistent. 

If you open the SharePoint list in List Settings and hover over the column and then look at the bottom you will see the name never 100% changed. So some places will refer to the old name and some to the new name. 

See this above I changed the column name to JobNum but it still is really called Title. It might work sometimes but it will ALWAYS give you problems at some point. If you try this above and the names in both places are not the same I would delete the column and create it again.

Hope this is all your issue is because it is a fairly easy fix.