cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vish_p
Level 8

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
Level: Powered On

Re: Creating a dashboard on powerapps based on o365 mail ids

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
Level: Powered On

Re: Creating a dashboard on powerapps based on o365 mail ids

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

vish_p
Level 8

Re: Creating a dashboard on powerapps based on o365 mail ids

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 293 members 5,897 guests
Please welcome our newest community members: