Hey There,
i just created my first App based on a SP List for recording working hours on different projects. I created all screens necessary for the recording of workin hours. Users can first select the clients, then with a distinct filter all orders by the selected client. In the next step they type in the number of hours on this project. The acutal date is suggested automatically and informations like order number, name of creator eg are deposited and will be delivered to the sp list.
In a BrowseGallery the Users should get a list of all recorded assignments. The Gallery is filtered by User and works fine in the moment. But i get a Warning because of the 500s limit.
Do you have an idea how i can change my code to bypass the limit? the user-filter is necessary. The 500 records will be reached in about 2 month i guess. Furthermore, do you have experience how the performance of the app will be when there are some hundreds od records in the sp list.
Heres my Items-Code in the gallery:
Solved! Go to Solution.
Hi @THN_Hlmn
It looks like Zeiterfassung_Neu.Author is a SharePoint Person field and unfortunately, it's not possible to filter this type of column with a delegable query.
Here's a link with more details:
https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/
The main workaround is to store the author email in a separate column.
Hi @THN_Hlmn
It looks like Zeiterfassung_Neu.Author is a SharePoint Person field and unfortunately, it's not possible to filter this type of column with a delegable query.
Here's a link with more details:
https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/
The main workaround is to store the author email in a separate column.
Hi @timl
thx for your fast reply!
I will try your described solution as given in your link. I will let you know if i made it work
😃
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
187 | |
82 | |
50 | |
37 |
User | Count |
---|---|
288 | |
243 | |
123 | |
75 | |
56 |