How to Fix Missing User ID Output in Power Automate HTTP Requests
Question details
The user is attempting to extract a User ID from a Power Automate HTTP request response, but the flow fails because the results array is unexpectedly empty.
- Product
- Power Automate
- Device & OS
- not provided
- Scenario
- Running a multi-step Power Automate flow that creates SharePoint folders and relies on sequential HTTP requests to pass user identification data.
- Observed behavior
- The flow stops executing before the third HTTP request because the expression fails to locate the User ID in the second request's empty output array.
Ensure you have SharePoint site owner or administrator privileges so you can review and modify library access permissions for the affected users.
Verify and Grant SharePoint Target Library Permissions
An empty results array in a SharePoint HTTP request usually indicates that the target user lacks the necessary access rights to the specific library.
When an HTTP request queries user data in SharePoint, the system evaluates the permissions of both the connection account and the target user. If the specified user does not have access to the destination library, the API will return an empty results array, causing downstream flow actions to fail.
Navigate to the SharePoint site containing the Test Library. Click the gear icon in the top right corner and select 'Library settings'.
Click on 'Permissions for this document library' and then use the 'Check Permissions' button in the ribbon to evaluate the access level of the specific user (User A).
If the user lacks permission, click 'Grant Permissions', enter the user's email address, assign at least 'Edit' or 'Contribute' access, and save the changes.
Return to Power Automate, trigger a new test run of your flow, and check the HTTP request output to confirm the results array is now populated.
Implement Safe Expressions in the Flow
Update the variable expression using safe navigation operators to prevent the flow from crashing completely when an expected data node is missing.
Enhance Your Workflow with WPS Office
While troubleshooting complex Microsoft Power Automate flows, you need a reliable suite for your daily document tasks. WPS Office is a free, lightweight, and highly capable alternative to Microsoft Office that ensures seamless compatibility and a familiar interface without the heavy subscription costs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to complete the fast setup process.
- 3. Open and Edit Microsoft Formats: Launch WPS Office and directly open your existing .docx, .xlsx, or .pptx files to seamlessly continue your work.
Frequently Asked Questions
Why is my Power Automate HTTP request returning an empty results array?
This usually occurs because the authenticated account or the target user lacks the required read or write permissions for the specified SharePoint list, library, or site, causing the API to hide the results for security reasons.
What does the question mark (?) mean in a Power Automate expression?
The question mark is a safe navigation operator. It ensures that if a property is null or missing in the JSON payload, the expression safely returns null instead of throwing a fatal execution error.
How do I view the raw HTTP response in Power Automate?
Go to your flow's run history, select the specific failed or successful run, click on the HTTP request action card to expand it, and look for the 'Show raw outputs' button to view the complete JSON response.
