I'm building Canvas app with SharePoint custom list.
There are 4 column in SharePoint as
- Title
- PickEditor (User/Group) (Allow to select multiple users)
- PickEditorInText (Single text) (When Submit form, copy Claims from PickEditor culumn with concat, separated with ";" .)
- 'Created by' (System)
And by using Office 365 User connector, I stored user info with variable named "varUserInfo".
In Gallery, I would like to filter items with below condition.
- If current app user is same as Created by user, show item on gallery.
- If current app user is contained in PickEditorInText, show item on gallery.
Then I write formula like this.
Filter(EventReports,'Created By'.Email=varUserInfo.mail || varUserInfo.userPrincipalName in PickEditorInText)
This works fine but delegation warning with "IN" operator....
Is there any way to overcome delegation warning?
Thanks for your help.
