Delegation complex type

%3CLINGO-SUB%20id%3D%22lingo-sub-1853331%22%20slang%3D%22en-US%22%3EDelegation%20complex%20type%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853331%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3CBR%20%2F%3EI%20am%20trying%20to%20filter%20the%20data%20in%20the%20SharePoint%20list%20based%20on%20the%20%22Person%22%20type%20field.%3CBR%20%2F%3EBased%20on%20the%20specification%20it%20is%20possible%20if%20you%20use%20DisplayName%20or%20Email%20properties.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Freenit_0-1604499508424.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231450i450AFDB5E9679FA3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Freenit_0-1604499508424.png%22%20alt%3D%22Freenit_0-1604499508424.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Freenit_1-1604499597849.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231451iFAFD5E806DCED23A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Freenit_1-1604499597849.png%22%20alt%3D%22Freenit_1-1604499597849.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3EI%20need%20to%20receive%20data%20that%20is%20responding%20only%20to%20the%20user%20that%20is%20open%20PowerApps%20application.%3CBR%20%2F%3EI%20am%20trying%20to%20filter%20data%20with%20%22Email%22%20and%20%22DisplayName%22%20but%20the%20result%20is%20the%20same%20-%20delegation%20warning.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EFilter('Materials%20Permissions'%2CPerson.DisplayName%20%3D%20Office365Users.MyProfileV2().displayName)%3C%2FCODE%3E%3C%2FPRE%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EFilter('Materials%20Permissions'%2CPerson.Email%20%3D%20Office365Users.MyProfileV2().mail)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%22Material%20Permissions%22%20is%20my%20SharePoint%20list%20where%20data%20is%20saving.%3CBR%20%2F%3E%22Person%22%20is%20the%20column%20in%20the%20SPO%20list%20with%20the%20%22Person%22%20type.%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20someone%20advise%20how%20to%20solve%20this%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1853331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello.
I am trying to filter the data in the SharePoint list based on the "Person" type field.
Based on the specification it is possible if you use DisplayName or Email properties.

Freenit_0-1604499508424.png

Freenit_1-1604499597849.png
I need to receive data that is responding only to the user that is open PowerApps application.
I am trying to filter data with "Email" and "DisplayName" but the result is the same - delegation warning.

Filter('Materials Permissions',Person.DisplayName = Office365Users.MyProfileV2().displayName)
Filter('Materials Permissions',Person.Email = Office365Users.MyProfileV2().mail)

"Material Permissions" is my SharePoint list where data is saving.
"Person" is the column in the SPO list with the "Person" type.

Could someone advise how to solve this problem?

Thanks in advance.

 

0 Replies