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

(0) Share

Report

Posted on by Jackywei_BDF

201

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:)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,565 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Jackywei_BDF 201 on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
WarrenBelz 155,565 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
Verified answer

Jackywei_BDF 201 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz ：
Thanks for your reply.
I have settle this issue by following function.
Filter(list, User().Email in Approvallog)

Was this reply helpful? Yes No