How to Fix Power Automate List Rows Not Showing Dataverse JSON Output
Question details
The Power Automate List Rows action runs successfully but does not output the expected Dataverse JSON data, such as process IDs and related names.
- Product
- Power Automate
- Device & OS
- not provided
- Scenario
- Creating or running a flow that retrieves rows from a Dataverse table.
- Observed behavior
- The action completes without errors, but the returned JSON body is missing the expected data fields.
Ensure you have the correct permissions assigned for the target Dataverse table and that your flow connection is fully authenticated.
Verify Table Permissions, Filters, and Selected Columns
Ensure the List Rows action is configured to retrieve the correct fields and that no strict filters are hiding the results.
Sometimes the List Rows action limits the data it retrieves based on your column selection or default view limits. Checking these parameters ensures you are actually requesting the missing JSON fields.
Open your flow in Power Automate and click to expand the 'List Rows' action.
Examine the 'Select columns' field to ensure you haven't unintentionally excluded the missing process IDs or related names.
Check any 'Filter rows' OData queries to guarantee they aren't inadvertently omitting the expected records.
Save and test the flow again. Navigate to the run history and inspect the raw JSON output to verify if the data is now present.
Seek Specialized Help in the Power Automate Community
If configuration checks do not resolve the issue, specialized community support can help uncover complex Dataverse JSON query issues.
Boost Your Everyday Productivity with WPS Office
While Power Automate handles complex Dataverse workflows, everyday document, spreadsheet, and presentation tasks are easier with WPS Office. Enjoy a free, lightweight, and highly compatible Office suite that streamlines your daily work without the heavy overhead.
- 1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install the software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open your files: Launch WPS Office and open your existing Microsoft Office documents, spreadsheets, or presentations directly with full compatibility.
Frequently Asked Questions
Why is the raw JSON output missing from my Power Automate run history?
Power Automate sometimes truncates large responses in the user interface. You may need to click 'Click to download' in the run history to view the full JSON payload returned by Dataverse.
Does the Dataverse List Rows action limit the number of records returned by default?
Yes, by default it limits the rows retrieved. You may need to enable 'Pagination' in the action settings and set a higher threshold (e.g., up to 100,000) to ensure all your records are fetched into the JSON output.
Why are lookup fields or related names missing in my Dataverse JSON?
When querying Dataverse, related names or formatted lookup values are often hidden unless explicitly requested. You might need to add specific OData formatting headers to your request to expose these associated text labels.
