Hi, Im trying to use lookup/filter to find records from sharepoint List.
List has a column: user_email, which is single line text, contains user email in lower case.
when I use code below it will never return a record.
LookUp(list_name ,user_email = Lower(User().Email))
Can anyone re-occur this issue and maybe any tips?
P.S if I use Person columns in the list it works. but to minimize the storage I prefer to use email. another reason is that I never success to create list item with person column from powerapps😂
