Creating a dashboard on powerapps based on o365 mail ids

[vish_p]

I would like to show all the records pending with a particular user (identified using O365 mail id).

My app has a sharepoint list as datasource,so i have changed the created by column to show email id instead of name

and now i am inserting a new screen in my app ,which i need it to fetch the currently logged in user email,compare it with "Created By" column of my sharepoint list and return only matching records..anyway ?

I tried the following formulas in 'Items' & 'Visible' property of gallery 

Filter( 'PO list', Created_x0020_by = User().Email)

Lookup( 'PO list', Created_x0020_by = User().Email) 

both of them doesn't seem to work well..please help

[Srautio · Accepted solution]

Hey there,

I believe its a case of having to use Author.Email rather than CreatedBy.

So

Filter('PO list', Author.Email = User().Email)

Try that and see if it helps.

Might wanna make sure User().Email actually returns the email in the format you are expecting aswell

[vish_p]

Author.Email was what i was missing here..now it works thanks