Data Import & Export

How to Add Fixed Text to an Excel File with Power Automate

Olivia MillerOlivia Miller Oct 10, 2026 871 views

Question details

The user needs to automatically add a constant text string (such as a customer code) into an Excel table on SharePoint using Power Automate, triggered by a Microsoft Forms response.

How to Add Fixed Text to an Excel File Using Power Automate
Product
Microsoft Power Automate / Excel
Device & OS
not provided
Scenario
Processing incoming Microsoft Forms responses and adding a required, non-dynamic fixed value into a specific column of an Excel target table for another system to read.
Observed behavior
The form data maps dynamically to the table, but the user must inject a constant string into a column that isn't collected during the form submission.
Before you start

Ensure your target Excel workbook contains a properly formatted Table (Insert > Table) and is saved in a reachable SharePoint Document Library or OneDrive folder. Your Power Automate account must have permission to edit this file.

Solution 1Recommended

Use the 'Add a row into a table' Action with Fixed Values

Configure your Power Automate flow to map dynamic content from Microsoft Forms alongside hard-coded text strings into your Excel table columns.

Power Automate allows you to combine dynamic content (variables collected from apps like Forms) with static, fixed text in the same action. When you select an Excel table, the connector automatically generates input fields for each column in your table.

1
Set up the Form Trigger

In Power Automate, create an automated cloud flow. Select the trigger 'When a new response is submitted' (Microsoft Forms) and add the 'Get response details' action to fetch the form data.

2
Add the Excel Action

Click 'New step', search for 'Excel Online (Business)', and select the 'Add a row into a table' action.

3
Locate Your Excel Table

In the action properties, select your SharePoint site from the Location dropdown, choose your Document Library, select your specific Excel file, and finally select the Table name from the dropdown list.

4
Input the Fixed Text

Once the table is selected, its columns will appear as fields. Map your dynamic form data to the appropriate fields. For the column requiring the constant customer code, simply click into the field and type the fixed text directly. Save and test your flow.

Use the 'Add a row into a table' Action with Fixed Values
Use Expressions for Complex Scenarios: If your fixed text needs to be combined with a date or formatted uniquely, you can use Power Automate's expression builder (e.g., the concat() function) instead of typing plain text.
Free Microsoft Office alternative

Format Your Excel Data Tables Easily with WPS Office

While automated workflows like Power Automate are specific to Microsoft services, WPS Office is an excellent, free alternative for creating, formatting, and analyzing the underlying Excel tables required for your workflows.

  1. 1. Open Your Spreadsheet: Launch WPS Spreadsheet and create a new blank workbook or open your existing data file.
  2. 2. Format Data as a Table: Highlight your data headers and rows, then navigate to the Home tab and click 'Format as Table'. This structure is required by automation tools.
  3. 3. Save as .xlsx: Go to Menu > Save As, and choose 'Microsoft Excel Workbook (*.xlsx)' to ensure total compatibility before uploading to your cloud drive.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) required for cloud automation.Lightweight, fast, and runs smoothly on Windows, Mac, and Linux.Includes intuitive tools for formatting data as tables with a single click.Familiar spreadsheet interface ensures zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why isn't my Excel table appearing in the Power Automate dropdown?

Power Automate can only interact with structured tables, not raw worksheet data. Open your Excel file, highlight your data range, press Ctrl+T (or Insert > Table) to format it as a table, name it, and save the file back to SharePoint.

Can I update an existing row with fixed text instead of adding a new one?

Yes. Instead of using 'Add a row into a table', use the 'Update a row' Excel action. You will need a Key Column and Key Value to identify which specific row to update, after which you can type your fixed text into the target column field.

What if my target column is a drop-down list in Excel?

Even if the column has Data Validation (a drop-down) in Excel, Power Automate will write the text into the cell as a raw string. Ensure the fixed text you type in Power Automate perfectly matches one of the allowed drop-down options to avoid data inconsistency.