Answered

PowerApps Find function not working as expected

(0) Share

Report

Posted on by cooper33

249

I have a Yes/No field in a SharePoint list that I want to hide for users whose email is not in a different text field (Emails) in the list. The email would be stored like this: UserA@contoso.com; UserB@Contoso.com

Assuming I am UserA, I should be able to see the field. I am showing and hiding the field using this formula in the Visible property:

If(Find(Lower(Emails), Lower(User().Email)) > 0, true, false)

This works as long as I am the only user in the Emails field (field value = UserA@contoso.com). It stops working once there are two users (UserA@contoso.com; UserB@Contoso.com)

I have added a label to show how the Find function is behaving which looks like this:

Find(Lower(Emails), Lower(User().Email))

The label is empty when there are two or more emails and 1 when I am only email. When I try the same values in Excel I get an actual number for both cases. Can anyone explain the difference?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Mr-Dang-MSFT Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
@cooper33, can you clarify:

What type of column is containing these emails? Is this a Person column? If so, is it a multi-select or single-select Person column?

Was this reply helpful? Yes No
Verified answer

cooper33 249 on at

Like (1)

Report
Copy link

Link copied!
The column that contains the emails is just a text column that's populated based on a multi user column. I want to filter by current user being in either of those

I ended up getting it to work by not using the find and instead filtering by the user field
ClearCollect(RecordsCollection, Filter(RecordsCollection, User().Email = CCEC.Email))

Was this reply helpful? Yes No