Power Platform Community Forum Thread Details

Hi all!

I am trying to populate a Gallery's Items based on a check and a Filter function:

If(EmployeeEmailAddress = "user@mail.com", Filter(source, SharePointChoiceColumn, "SharePointChoiceColumnValue"))

but it seems to have issues and it is not working.

I have tried the following which works:

Filter(source, SharePointChoiceColumn, "SharePointChoiceColumnValue")

So this tells me that the If statement is the issue here... But why?

I need to be able to check based on my EmployeeEmailAddress value what records to get from SharePoint.

Something between these lines is what i want (nested checks):

If(EmployeeEmailAddress = "user@mail.com", Filter(source, SharePointChoiceColumn, "SharePointChoiceColumnValue"), If(EmployeeEmailAddress = "anotherUser@mail.com", Filter(source, SharePointChoiceColumn, "AnotherSharePointChoiceColumnValue")))

Can anyone suggest me a way of achieving what i want and explain why this is not working?

Kind regards!

Categories:

Building Power Apps

Hey I know this is a super old post, so I'm mostly posting this in case anyone arrives here from a search engine, but you can achieve this by altering your formula as that is not a standard Filter formula, and then also by altering your if statement.

Currently your if statement only returns a value when true, and when false it would be null, so we can replace that with a Filter that

If(
 EmployeeEmailAddress = "user@mail.com", 
 Filter(source, SharePointChoiceColumn = "SharePointChoiceColumnValue"),
 Filter(source, ID = -1)
)

It's worth also mentioning that the Email address must be the same case format in your formula, i.e. tom@tom.com is not equal to Tom@tom.com - you can get around that by using the Lower() function to convert them both to lowercase.

Cheers,

Sancho