Filter Excel data by user email

(0) Share

Report

Posted on by arkkgroup

154

I have Excel data table with 3 columns: Name, Email and Role. Role can be Admin or User. I want to do these scenario:

1. Detect user email and find row for that user. 2. If user role is Admin, show all rows in Gallery. If user role is User, show only rows where user email equal email from data.

Still learning.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @arkkgroup ,
Assuming a Role of Admin used

With( { _Role: LookUp( Table, Email = User().Eamil ).Role }, Filter( DataSource, _Role = "Admin" || EmailFieldName = User().Email ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
arkkgroup 154 on at

Like (0)

Report
Copy link

Link copied!

Thanks. Seems to working.

Was this reply helpful? Yes No