SharePoint Document Issues

Fix SharePoint Approval Status Showing Numbers Instead of Text

Maira MehtabMaira Mehtab Oct 29, 2026 869 views

Question details

The user needs to display descriptive text for SharePoint approval statuses rather than raw numeric values in Power Automate.

How to Fix SharePoint Approval Status Showing Numbers Instead of Text
Product
SharePoint / Power Automate
Device & OS
not provided
Scenario
Automating document approval workflows or sending status alerts using Power Automate connected to SharePoint.
Observed behavior
Approval fields return numeric values (such as 0, 2, or 3) instead of expected text labels (Approved, Pending, or Draft).
Before you start

Ensure you have permission to edit the Power Automate flow and understand SharePoint's default status mapping (0=Approved, 1=Rejected, 2=Pending, 3=Draft, 4=Scheduled).

Solution 1Recommended

Use a Switch Condition to Map Numbers to Text in Power Automate

Modify your Power Automate flow to convert the raw numeric data from SharePoint into readable text variables.

Because SharePoint stores approval statuses as integers in its backend, Power Automate often retrieves these raw numbers. By adding a Switch action, you can manually translate these numbers back into their corresponding text values before sending emails or updating records.

1
Edit Your Flow

Open Microsoft Power Automate, locate the flow connected to your SharePoint list or library, and click 'Edit'.

2
Initialize a String Variable

Add an 'Initialize variable' action at the beginning of your flow. Name it 'ApprovalStatusText' and set its type to 'String'.

3
Add a Switch Control

After the SharePoint action that retrieves the item, add a 'Switch' control. Set the 'On' field to the SharePoint Approval Status dynamic content.

4
Configure the Cases

Create a case for each number. For Case '0', add a 'Set variable' action to change your string to 'Approved'. For Case '1', set it to 'Rejected'. For Case '2', set it to 'Pending'. For Case '3', set it to 'Draft'.

5
Update Output Actions

In subsequent steps (like sending an email or Teams message), replace the original SharePoint status field with your new 'ApprovalStatusText' variable.

Use a Switch Condition to Map Numbers to Text in Power Automate
Workflow Check: Always test your flow with a sample document to ensure the text variable updates correctly before deploying it to production.
Free Microsoft Office alternative

Manage Document Drafts Seamlessly with WPS Office

While resolving backend SharePoint automation rules, you can continue creating, editing, and reviewing your document drafts effectively using WPS Office—a lightweight and highly compatible alternative to Microsoft Office.

  1. 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer file and follow the quick on-screen instructions to set up the software.
  3. 3. Edit Your Documents: Open your local Word, Excel, or PowerPoint drafts directly in WPS Office to prepare them for your SharePoint workflows.
Fully compatible with Microsoft Word (.docx), Excel (.xlsx), and PowerPoint (.pptx) formats.Lightweight installation with an intuitive, tabbed user interface.Built-in PDF editing tools for secure document review.Free to use, making it an excellent standalone alternative for drafting documents before SharePoint upload.
microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint use numbers for approval status instead of text?

SharePoint stores the 'Approval Status' column as integer values in its backend database (0=Approved, 1=Rejected, 2=Pending, 3=Draft, 4=Scheduled). This optimizes performance, sorting, and indexing. Power Automate sometimes pulls this raw database value rather than the user-friendly display label.

Can I change the default numeric values in SharePoint?

No, the numeric values for the built-in Content Approval status are hardcoded into SharePoint's core architecture and cannot be modified. You must handle the text conversion within your reporting tool or workflow logic.

Is there an expression to convert these numbers directly without a Switch action?

Yes. If you prefer using expressions in Power Automate instead of a Switch block, you can use nested if() statements. For example: if(equals(triggerOutputs()?['body/{ApprovalStatus}'], 0), 'Approved', if(equals(triggerOutputs()?['body/{ApprovalStatus}'], 2), 'Pending', 'Draft')).