Hello,
I'm building Power Apps Canvas Application and I'm using SharePoint list, in the list there are 3 people and group columns, in list there are 7000 + records and we are fetching current logged in user and applying filter formula "Filter('SE Request Form',((User().Email) in ('SE Primary Lead')) || ((User().Email) exactin ('SE Resource assigned name'.Email)) || ((User().Email) exactin ('Flex Resource'.Email)) || ((User().Email) exactin ('External resource assigned'.Email)))". here SE Request Form is SharePoint custom List, SE Primary Lead is multiple line of Text(which can have multiple Emails), SE Resource assigned name is People and Group column with multi select, Flex Resource is People and Group column with multi select, External resource assigned is People and Group column with multi select.
but we get only 1st 2000 records. I need to show all records which are assigned to them only.
Please suggest workaround.
Thanks,
Akshay