Fix SharePoint Approval Status Showing Numbers Instead of Text
Question details
The user needs to display descriptive text for SharePoint approval statuses rather than raw numeric values in Power Automate.

- 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).
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).
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.
Open Microsoft Power Automate, locate the flow connected to your SharePoint list or library, and click 'Edit'.
Add an 'Initialize variable' action at the beginning of your flow. Name it 'ApprovalStatusText' and set its type to 'String'.
After the SharePoint action that retrieves the item, add a 'Switch' control. Set the 'On' field to the SharePoint Approval Status dynamic content.
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'.
In subsequent steps (like sending an email or Teams message), replace the original SharePoint status field with your new 'ApprovalStatusText' variable.

Request Help from the Microsoft Power Automate Community
If the workflow involves complex logic or the status is nested deeply in custom arrays, seek assistance from community experts.
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. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the downloaded installer file and follow the quick on-screen instructions to set up the software.
- 3. Edit Your Documents: Open your local Word, Excel, or PowerPoint drafts directly in WPS Office to prepare them for your SharePoint workflows.

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




