How to Fix Power Apps Change the Rule to Produce a Value Error
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.

- 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.
Verify that your Power Apps environment is connected to the correct SharePoint source list and that you have edit permissions for the affected app.
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.
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).
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).
Ensure the parent DataCard's 'Update' property is correctly set to reference the text input control so the correct string is passed during submission.
Utilize the SubmitForm function to save your changes to SharePoint, and use the ResetForm function to clear the fields for subsequent entries.

Extract the Column Directly via Lookup Formula
If a combo box is unnecessary for your user interface, modify your LookUp formula to explicitly return a text value.
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.

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.




