@johnjohnPter ,
Yes there can be an issue with emails stored in a field in a different case to their email address in AD. I have a particular issue with inconsistency of capitalising their first and last name (or not) - I use a separate user list as a lot more information is stored in it beyond that in AD. You are correct that using Lower on the store field value will cause Delegation issues - you could set a Variable to Lower(User().Email) OnStart and store everything in your list in lower case.
If however you are getting the field content from a Person AD lookup, you should not have an issue with case as it will be the same as User().Email. If you do have a Delegation issue, you may be able to do this.
With(
{
_Data:
Filter(
'Work Orders',
'Work Order Status'.Value = "Assigned" Or
'Work Order Status'.Value = "New"
)
},
Filter(
_Data,
Lower('Technician Name'.Email) = Lower(User().Email) Or
IsBlank(colSelectedTechnicianName))
)
)
but note that the top filter needs to return record numbers under your Data Row Limit.
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
