cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vish_p
Helper V
Helper V

Creating a dashboard on powerapps based on o365 mail ids

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

1 ACCEPTED SOLUTION

Accepted Solutions
Srautio
Advocate I
Advocate I

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

View solution in original post

2 REPLIES 2
Srautio
Advocate I
Advocate I

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

View solution in original post

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (30,484)