Power Apps遇到问题整理

1.隐藏顶部标题，顶部内容

URL加上参数 &hidenavbar=true

2.entityrelationshiprole for given navigation property not found

关联表条件查询不能超过一级，当前表及其关联表。如果还要查到关联表的关联表就不行了

3.使用前表的新增记录做为其他表的字段内容

With(Patch(MeetingRoomBook,Defaults(MeetingRoomBook) ,{
    BookDay:BookDay,
    BookEmployeeEmail:CurrentEmail,
    BookEmployeeName:User().FullName,
    MeetingDescription:MeetingDescription,
    MeetingOrganizerEmail:MeetingOrganizerEmail,
    MeetingOrganizerName:MeetingOrganizerName,
    MeetingRoom:LookUp(MeetingRoom,MeetingRoomCode=MeetingRoomCode),
    MeetingSubject:MeetingSubject,
    TimeEnd:Trim(Last(Split(ChoicePeriod,"~")).Result),
    TimeStart:Trim(First(Split(ChoicePeriod,"~")).Result)
}) As book,Patch(BookSummary,Defaults(BookSummary),{
    BookByEmail:CurrentEmail,
    BookByName:User().FullName,
    BookByType:LookUp(BookByType,BookByCode="self"),
    BookType:LookUp(BookType,BookTypeCode="meeting"),
    MeetingRoomBook:book,
    OwnerEmail:CurrentEmail,
    OwnerName:User().FullName,
    TimeEnd:Trim(Last(Split(ChoicePeriod,"~")).Result),
    TimeStart:Trim(First(Split(ChoicePeriod,"~")).Result)
});ForAll(SelfMeetingLock As lock,Patch(BookMeetingScale,Defaults(BookMeetingScale),{MeetingRoom:LookUp(MeetingRoom,MeetingRoomCode=MeetingRoomCode),TimeScale:lock.TimeScale,MeetingRoomBook:book})));

4.创建的环境怎么分配给到开发人员能看到

需要让安全人员具备system customizer以及basic user安全角色

5.power automate 行筛选条件 cr62b_issign  是“是否”类型即 bool类型  statecode 是“单选”类型 即整型类型

cr62b_issign  and statecode eq 0 

6. basic user让用户可以看到这个环境，system customizer可以让用户创建和编辑应用，system administrator可以对当前环境做完整管理

7.企业微信取消power apps应用推荐

URL加上参数 &skipMobileRedirect=1

8.power automate 行过滤 表达式 eq contain

9.power automate如何设置查找列类型的值,设置表实体类型的值

直接设置表的复数形式(guid)就好了,eg. contacts(c96be312-4ac1-4358-99b6-1e14e2957b15),可以通过Expression设置null值

见使用关系修改行 - Power Automate | Microsoft Learn