How to filter items which including user().email address from approvallog?

[Jackywei_BDF]

Dear all:

I am a starter for power apps with sharepoint.

I have a question about Filter function.

I recording approver's email address into approvallog, now i would like to filter items from approvallog which including user().Email.

But i don't know how to do for it.

Would you please help me out?

Thanks a lot:)

[WarrenBelz]

Hi @Jackywei_BDF ,

If ApprovalLog is a Person field, you need this

Filter(
   YourSPList,
   ApprovalLog.Email = 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.

Visit my blog Practical Power Apps

[Jackywei_BDF]

@WarrenBelz :

Approvallog is Text column in sharepoint list, it is including approver's comments & Email address & approve time. it is totally text.

Such as below screenshots

How to Filter Email address from it and   = user().Email?

Thank you very much!

[WarrenBelz]

@Jackywei_BDF ,

It is helpful to include all the information in your first post - note this is not Delegable and assumes that the email address will always be the second item with the first space before it.

Filter(
   AddColumns(   
      YourSPList,
      "Log",
      Last(
         FirstN(
            Split(
               ApprovalLog,
               " "
            ),
            2
         )
      ).Result
   ),
   Log = 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.

Visit my blog Practical Power Apps

[Jackywei_BDF · Accepted solution]

@WarrenBelz ：

Thanks for your reply.

I have settle this issue by following function.

Filter(list, User().Email in Approvallog)