How to Add Fixed Text to an Excel File with Power Automate
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.

- 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.
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.
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.
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.
Click 'New step', search for 'Excel Online (Business)', and select the 'Add a row into a table' action.
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.
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.

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. Open Your Spreadsheet: Launch WPS Spreadsheet and create a new blank workbook or open your existing data file.
- 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. Save as .xlsx: Go to Menu > Save As, and choose 'Microsoft Excel Workbook (*.xlsx)' to ensure total compatibility before uploading to your cloud drive.

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.




