Power app查看用户自己提交的记录

看了很多案例,竟然没有查看自己提交记录的显示功能?!

初步看有三种方法,

1) On the “OnStart” property of you app, place this expression:

Set(UserEmail, User().Email)

2) Now Items need to be modified as:

Filter(DataSourceName,email = UserEmail)

If you have more than 500 records in your datasource, please make sure you update the below setting:

Navigate File -> App Settings -> Advanced Settings -> Data Row Limit for Non-Delegable queries -> Set this to 2000.

但是FILETER 里面怎么写还是不清除, 也没有文档详细说明该调用什么属性

首先 ,干脆最简单的, 直接查ID 总是可以的 Filter(‘Help Desk_1’, ID= 15)

接着改一下 Filter(‘Help Desk_1’, ‘Created By’= User().FullName) 竟然显示空白, 也不知道 User().FullName 到底管不管用 , 哪怕最基本的有个ALERT 也好耶

后来觉得肯定是 哪里有问题, 那么 created by 似乎不是传统上理解的数据库一个字段吗???似乎 ‘Created By’.Email下面还有属性 ,但是为什么会怎样,有点不理解, 但是这样好用

Filter(‘Help Desk_1’, ‘Created By’.Email= User().Email)

Leave a Reply

Your email address will not be published. Required fields are marked *