过滤用户电子邮件 - 无授权 [英] Filter User email - no delegation

问题描述

我在共享点列表数据源上使用 powerapps.尝试根据当前用户的电子邮件 ID 在 sharepoint 中的单行文本字段上进行过滤.收到此错误，

I'm using powerapps on a sharepoint list datasource. Trying to do a filter based on the current user's email ID on a single line text field in sharepoint. Getting this error,

我认为上面有 2 个错误.

I believe there's 2 errors above.

1) User().Email 函数本身不支持委托.

1) User().Email function itself does not support delegation.

2) '=' 运算符不支持委托.

2) '=' operator does not support delegation.

对于 (2)，不知道为什么会出错.'=' 运算符应该支持委托，

For (2), not sure why it's giving an error. '=' operator supposed to support delegation,

对于 (1)，我在启动时将 User() 对象保存到全局变量CurrentUserG"中.它似乎修复了这个错误.

For (1), I've saved the User() object into a global variable "CurrentUserG" on start. It seems to fix this error.

推荐答案

既然你在开始时设置了 CurrentUserG=User() 并且 User() 返回的是记录，而不是值，那么你可能需要:

Since you set CurrentUserG=User() at the start and User() returns a record, not a value, then you probably need:

Filter(Clock_In_Out, CurrentUserG.Email=User_Email)

如果没有得到所需的结果，请记住 PowerApps 中的文本比较区分大小写.如果您遇到此问题，只需在等式两边使用 Lower().

If you do not get the result you need, remember that text comparisons in PowerApps are case sensitive. If you have this issue, just use Lower() on both sides of the equation.

这篇关于过滤用户电子邮件 - 无授权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！