Others

Fix Power Automate Returning 256 for SharePoint Calculated Column

Emma BrownEmma Brown Nov 3, 2026 869 views

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.

How to Fix Power Automate Returning 256 for 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.
Before you start

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.

Solution 1Recommended

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.

1
Open Flow Run History

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.

2
Verify the SharePoint Column Type

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).

3
Update Dynamic Content

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.

Review Dynamic Content and Expressions
Examine the Trigger Outputs: Hover over the dynamic content in edit mode to see the actual formula name. Make sure it matches the exact SharePoint column name you intended to use.
Free Microsoft Office alternative

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. 1. Visit the official WPS website: Go to wps.com to download the latest free version of WPS Office.
  2. 2. Run the installer: Open the downloaded setup file and follow the on-screen instructions to install the software on your device.
  3. 3. Open and edit files: Launch WPS Office to instantly open, create, and edit your Microsoft Office documents with full compatibility.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation and incredibly fast startup times.Familiar tabbed user interface for a seamless transition from other office suites.Free to use with built-in PDF editing capabilities.
microsoft office alternative - wps office

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').