Others

How to Fix Power Apps Change the Rule to Produce a Value Error

Amos GikundaAmos Gikunda Oct 28, 2026 868 views

Question details

The user encounters an error in Power Apps when attempting to update a text field using a SharePoint lookup value, resulting in a control receiving a record instead of a text value.

Fixing the 'Change the Rule to Produce a Value' Error in Power Apps
Product
Microsoft Power Apps
Device & OS
not provided
Scenario
Updating a SharePoint text field using a lookup value, typically after renaming a DataCardValue control.
Observed behavior
Power Apps displays the error message 'Change the rule to produce a value' on the affected control.
Before you start

Verify that your Power Apps environment is connected to the correct SharePoint source list and that you have edit permissions for the affected app.

Solution 1Recommended

Use a Combo Box to Extract the Text Value

Use a combo box connected to your source list as an intermediary to pass a specific text string instead of a full record to the text input.

A text input connected to a single-line SharePoint text column cannot directly accept a lookup record from another list. By introducing a combo box, you can extract the specific text value needed for the DataCard to submit successfully.

1
Insert and Connect a Combo Box

Add a combo box control to your screen and set its 'Items' property to reference the specific column in your source list (e.g., ListB.UserName).

2
Update the Text Input Default Property

Select the text input control causing the error and change its 'Default' property to reference the selected text of the combo box (e.g., ComboBox1.Selected.UserName).

3
Configure the DataCard Update Property

Ensure the parent DataCard's 'Update' property is correctly set to reference the text input control so the correct string is passed during submission.

4
Submit and Reset the Form

Utilize the SubmitForm function to save your changes to SharePoint, and use the ResetForm function to clear the fields for subsequent entries.

Use a Combo Box to Extract the Text Value
Data Type Validation: This method ensures that the text input receives a pure text string instead of a record object, completely resolving the value error.
Free Microsoft Office alternative

Manage Your Exported Data Seamlessly with WPS Office

While you build and troubleshoot custom workflows in Power Apps, WPS Office serves as the ideal, lightweight alternative for analyzing your exported SharePoint lists, managing spreadsheets, and creating documentation without subscription fees.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsFree, lightweight, and consumes minimal system resourcesFamiliar tabbed user interface for a zero learning curveBuilt-in robust PDF editing and conversion toolkit
microsoft office alternative - wps office

Frequently Asked Questions

Why does this error only happen to certain DataCardValue controls?

The error occurs based on the specific data type expected by the underlying SharePoint column. If one column is formatted as single-line text and another as a lookup, passing a record to the single-line text column will trigger the 'Change the rule to produce a value' error.

Can I use a Dropdown instead of a Combo box to fix this issue?

Yes, a Dropdown control functions similarly. You can set the Dropdown's Items property to the source list column and update your text input's Default property to Dropdown1.Selected.ColumnName.

How do I confirm if my control is receiving a record instead of text?

Select the control and highlight the formula in the Power Apps formula bar. The tooltip will display the data type being returned. If it shows 'Record' but the control requires 'Text', you need to append the specific column name to the formula.