Filter when current user is same as person in list

[MathijsM]

Hello guys, 

I'm struggling a bit and hope one of you can help me out. I have a gallery where I want to display for which courses someone subscribed. So when the current user of the canvas app is the same as someone in the sharepoint list of subscriptions, I want to show that in the gallery. The formula's I tried seem not to work unfortunately. The latest one is: 

Filter('DA - kl - subscriptions', ('Name Participant'.Email = VarCurrentUserClaim) 

Here, VarCurrentUserClaim is a global variable:

//Set current user claims value in a variable
Set(
VarCurrentUserClaim,
Concatenate(
Lower(User().Email)
)
);

Does anyone know what I'm missing? Would be very grateful for your help

[Vickielala]

You can try this
Filter('DA - kl - subscriptions', 'Name Participant'.Email = User().Email)

[MathijsM]

Thanks for your reply!! I already tried this one, and it does not work unfortunately. 

[v-xiaochen-msft · Accepted solution]

Hi @MathijsM ,

I used the same formula and it worked successfully.

Screenshots:

Is there any error message in your canvas app?

Please try refreshing your data source to check if that can resolves the issue.

If the problem still exists, please share some screenshots.

Best Regards,

Wearsky

[MathijsM]

@v-xiaochen-msft thanks for your help and effort. 

I should have posted it, but I already solved it. The issue was that the email of the subscriber in the sharepoint list was slightly different from the user email. I had to use the substitute function. Now it works 🙂 

THanks again.