Hi all,
I am trying to connect to a SharePoint list and filter by user().email=person.email()
Filter('Active Field Leadership', 'Performed By'.Email=User().Email)
I previously had it wrapped in a Sort by columns function
SortByColumns(Filter('Active Field Leadership', 'Performed By'.Email=User().Email), "Date", SortOrder.Descending)
i have been using a filter() query in my browse screen, but I think it has maxed out on the number of entries in the list.
How can I create a connection to the list that only pulls the list items of the user, rather than pulling all items and trying to filter?
@Anonymous
22 within the first 500. 34 when i allow 2000 records
@Anonymous
1) 20
2) 2
3) 500
4) 66
So weird, when i double check the sharepoint list I should have 26 entries. 6 entries after the ones shown. in the current visual
Same queries in the version that allows 2000 rows
1) 26
2) 8
3) 915
4) 481
@yashag2255 wrote:Can you please share the outputs of below expressions:1) CountRows(Filter('Active Field Leadership','Performed By'.Email=User().Email && ID > 0))2) CountRows(Filter('Active Field Leadership','Performed By'.Email=User().Email && ID > 500))3) CountRows(Filter('Active Field Leadership',ID > 0))4) CountRows(Filter('Active Field Leadership',ID > 500))I am guessing that the issue you are seeing is because of the non delegable Email condition for the Lookup Field. This can be confirmed by the outputs I requested in this comment.If Email condition is causing this issue, then we can get rid of this condition while collecting the collections and apply this when we are filtering the results into gallery
@Anonymous
@Anonymous this is getting a bit longer, but if its not a prolem to you, you can try out:
1) 566
2) 22
Still not showing the 6 most recent items.
User | Count |
---|---|
10 | |
3 | |
3 | |
2 | |
1 |
User | Count |
---|---|
15 | |
8 | |
7 | |
3 | |
2 |