Problem:

I am trying to use the Patch function in PowerApps to update a SharePoint list named City. The City list contains a lookup column Country referring to the ID, which has additional fields Language and Title marked in its definition. However, I am encountering the following error messages:

Version 1:

"The field 'Country_x003a__x0020_Title' is required."

Version 2:

"Error in 'City': Invalid data was used to update the list item. The field you are trying to update may be read-only."

Lists:

• Country: Contains fields Title, ID, and Language.
• City: Contains fields Name, Citizen Count, a lookup for Country, and an additional lookup for Language.

Code:

Here is the code I tried:

Version 1

Patch(
    City;
    Defaults(City);
    {
        Country: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
            Id: CurrentItem.ID;
            Value: CurrentItem.ID;
            'Country_x003a__x0020_Title': CurrentItem.Title; // Correct internal name
            'Country_x003a__x0020_Language': CurrentItem.Language // Correct internal name
        };
    }
)

Version 2

Patch(
    City;
    Defaults(City);
    {
        Country: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
            Id: CurrentItem.ID;
            Value: CurrentItem.ID;
        };

        Country_x003a__x0020_Title: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
            Id: CurrentItem.ID;
            Value: CurrentItem.ID;
        };
    }
)

Details:

• The Country lookup column requires the Title field to be populated.
• I have verified that the internal names of the fields in the SharePoint list match those used in the Patch function.
• The error persists even though I am providing values for Country_x003a__x0020_Title and Country_x003a__x0020_Language.

Question:

How can I resolve this error and successfully patch the Country lookup column with the required fields in PowerApps?