Fix Power Automate Returning 256 for SharePoint Calculated Column
Question details
The user needs to resolve an issue where a Power Automate flow incorrectly outputs the number 256 instead of the expected value from a SharePoint calculated column.

- Product
- Microsoft Power Automate
- Device & OS
- not provided
- Scenario
- Running a Power Automate flow that retrieves or checks data from a SharePoint calculated column or document version.
- Observed behavior
- The flow returns the numeric value 256 instead of the expected Yes/No, text, or calculated numeric value.
Ensure you have access to both the SharePoint list settings and the Power Automate flow run history to verify the exact output of your dynamic content.
Review Dynamic Content and Expressions
Verify that your flow is referencing the correct field name and data type, as internal SharePoint fields may return system values like 256.
When referencing SharePoint data, Power Automate may pull the internal system value rather than the formatted display string. A returned value of 256 often indicates a raw internal state or incorrectly mapped data type.
Go to your Power Automate portal, select the failing flow, and open the latest run history to inspect the raw JSON outputs of the SharePoint action.
Check your SharePoint list settings to ensure the calculated column is explicitly configured to the correct output type (e.g., Yes/No, Text, or Number).
In your flow's edit mode, remove the current dynamic content token and carefully re-select the correct calculated column variable, ensuring you are not selecting a system ID or internal mapped field.

Request Assistance in the Microsoft Power Automate Community
If standard troubleshooting does not resolve the 256 output issue, post your flow run history in the official Microsoft Power Automate Community.
Try WPS Office for Your Daily Document Needs
While Power Automate and SharePoint are Microsoft-specific tools, if you are looking for a reliable, lightweight, and cost-effective office suite for your daily document, spreadsheet, and presentation tasks, WPS Office is an excellent alternative.
- 1. Visit the official WPS website: Go to wps.com to download the latest free version of WPS Office.
- 2. Run the installer: Open the downloaded setup file and follow the on-screen instructions to install the software on your device.
- 3. Open and edit files: Launch WPS Office to instantly open, create, and edit your Microsoft Office documents with full compatibility.

Frequently Asked Questions
Why does SharePoint return a number like 256 instead of a Yes/No value in Power Automate?
This often happens because Power Automate is reading the raw internal system state or an incorrectly mapped Boolean field instead of the formatted display value of the calculated column.
How can I check the raw data Power Automate is receiving from SharePoint?
You can view the raw data by opening a completed flow run, clicking on the SharePoint trigger or action, and reviewing the 'Outputs' section in the raw JSON format.
Can I use a Power Automate expression to convert the 256 value into the correct format?
Yes. If the number 256 consistently represents a specific state (like a True/False flag in older SharePoint configurations), you can use an if() expression in Power Automate to translate it. For example: if(equals(outputs('Your_Column'), 256), 'Yes', 'No').




