Table of Contents Problem Statement Solution Overview Prerequisites Implementation Guide Step 1: Get Site and List IDs Step 2: Test with Graph Explorer Step 3: Initial Search Implementation Step 4: Handle Pagination Complete Code Examples Performance Considerations Conclusion Problem Statement After importing 10,000+ records into SharePoint using Power Automate bulk import techniques, we encountered Power Apps delegation limits that prevented effective searching and filtering of large datasets. There is the option of using Power Automate to get the results, however it adds more artefacts to a simple app designed for search.

Table of Contents Issue Overview Expected vs Actual Behavior Steps to Reproduce Issue Overview When SharePoint document libraries are configured with the “Open in client application” setting, users may experience unexpected behavior where new files open in the same browser tab instead of launching the desktop application as intended. Issue Summary: Expected: Files should open in desktop applications (Word, Excel, PowerPoint) Actual: Files open in the same browser tab instead of launching client apps Affected: SharePoint document libraries with “Open in client application” enabled Scope: Potentially affects user productivity and workflow expectations Expected vs Actual Behavior Expected Behavior When a SharePoint library is set to “Open in client application”:

The Issue SharePoint’s “Limited Access User Permission Lockdown Mode” feature introduces an unexpected side effect that can frustrate users and disrupt workflows. When this security feature is enabled, users who receive sharing links with edit permissions find themselves unable to edit files in desktop applications, despite having the necessary permissions. What Happens Expected Behavior: User receives an edit link, opens the file in Word/Excel/PowerPoint desktop app, and can modify the document.